How to get auto-Increment column in editable grid connected to an excel data source

(0) Share

Report

Posted on by Sage22

Hello, How can I include an auto increment in Powerapps using an excel datasource when I update an editable grid?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

leyburn19 2,157 on at

Like (0)

Report
editable grid? never seen one. Are you saying you want to include an incremental number when saving to a an excel table

Was this reply helpful? Yes No
Sage22 40 on at

Like (0)

Report

I do have an id column but I would like to maintain it when adding or deleting rows. Also to use it patch the updated records between the collection and data source.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @Sage22 ,

So you have an ID column in your Excel table which is data source of your App. Could you please confirm whether or not you have set to use this ID column as the key column for the Excel table? As follow:

I assume you are using the ID column as the key for your Excel table, basically there is no need to include ID in the collection when you are wanting to add new rows, if ID column is already included you could also leave it blank. The syntax of patching to the table through the collection would be:

ForAll(collection, Patch(Table, Defaults(Table), {ID: First(Sort(Table, ID, Descending)).ID+1, ...}))

With this formula, adding new rows into the table would generate auto-increment IDs.

When editing or deleting existing rows, you will need to use ID to look up the specific rows so IDs are needed in the collection.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Sage22 40 on at

Like (0)

Report

@v-jefferni , no. I didn’t set my ID as the key. How do you do so in PowerApps?

Was this reply helpful? Yes No