Unanswered

Power Apps id in excel tables

(0) Share

Report

Posted on by Community Power Pla...

In my excel table is a column with the Power Apps Id, is that a random generated id or is there a system behind that? The idea: If I add a new row with my flow there‘s a problem to show that in Power Apps. In my excel table, there‘s not an id, as with the other tables I use in Power Apps

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

All of that is correct - you cannot use that as a unique ID - you will have to generate your own if you want to do that.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Boynog 84 on at

Like (0)

Report

@Anonymous ,

Create your own unique ID is better and use the GUID() function to generate.
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

ok, because if I add a new row with flows there's a problem to show this in power apps, I think because there's no id. So If I generat a new random id in my brain, maybe this works?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

I suggest using First(Sort(table, ID, Descending)).ID+1 to generate your ID.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

ok thanks for the tipp

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Unfortunately, Excel does not have an ID

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I mean the rows in the table

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

Unfortunately Excel row numbers are not visible to Power Apps - you will need to have a unique identifier in the record.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No