Is it possible to use _PowerAppsId_ as a unique identifier

[nobosy]

Is it possible to use _PowerAppsId_ as a unique identifier for excel rows, I want a unique identifier for my excel rows so that I can use this formula 

Select(Parent);Set(itemid,ThisItem.powerapp)

[FernandoTC · Accepted solution]

Hi @nobosy .

I'm afraid you cannot use the _PowerAppsId_ as a field identifier, as it is not included in the record that PowerApps retrieves from the data source (Excel).

You should be creating an artificial id of your own like an incremental integer or some kind of code-id.

However, if you are planning to modify or manipulate that record withing a gallery (as I can deduct by your Select(Parent) formula), you can always use expressions as:

• Set(varName,Thisitem)-This will store the full record with all the fields.
• Patch(dataSourceName, Thisitem, {field1: field1value, field2: field2value,...})- To modify that record in particular.

Hope this helps.

[nobosy]

Thanks, Cheers @FernandoTC