Hi Experts,
I have a canvas app created on top of an excel source.
Now with excel you are required to format it as table and then it can be used.
The ID column option I selected was auto-generate PowerApps ID.
Now it works fine at the first time.
But if someone goes in the excel and adds a new row, powerapp ID for that row is not generated automatically because of which for my calculations on the app, the new row is not considered.
Can someone help me know if this is the expected behavior or I am missing something here?
Thanks,
Aditya
Solved! Go to Solution.
Hi @Aditya1728
Just to clarify your question, the problem is that if someone directly adds a row in the Excel spreadsheet outside of Power Apps, the Power Apps ID is not automatically generated?
If that's the case, that's expected behaviour. Power Apps manages the ID value and creates this value only when we add records through Power Apps. If we add records outside of Power Apps, this value is not automatically generated.
If you have any calculated column in your excel, remove it. That would not work.
If you want an ID Column, watch this tutorial:
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Hi @Aditya1728
Just to clarify your question, the problem is that if someone directly adds a row in the Excel spreadsheet outside of Power Apps, the Power Apps ID is not automatically generated?
If that's the case, that's expected behaviour. Power Apps manages the ID value and creates this value only when we add records through Power Apps. If we add records outside of Power Apps, this value is not automatically generated.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
199 | |
97 | |
56 | |
51 | |
41 |
User | Count |
---|---|
266 | |
156 | |
83 | |
81 | |
56 |