Check if a record exist. And if not create systemData - Coggle Diagram
Check if a record exist. And if not create systemData
When used with a data source, this function can't be delegated. Only the first portion of the data source will be retrieved and then the function applied. The result may not represent the complete story.
Delegation is where the expressiveness of Power Apps formulas meets the need to minimize data moving over the network.
Create string from a table
Check every record in the gallery (aka Items)
IF Thisrecord = " "
create new record
Concat converting Table to string.
Use the As operator to name a record in a gallery or record scope function, overriding the default ThisItem or ThisRecord. Naming the record can make your formulas easier to understand and may be required in nested situations to access records in other scopes.
May be required
As can also be used with record scope functions to replace the default name ThisRecord. We can apply this to our previous example to clarify the record we're working with: