I am building a PowerApp that has a main goal of adding an item to a SharePoint list. I have 3 screens: GalleryScreen, AddEditScreen & DetailsScreen. The GalleryScreen has an "add item" button for the use case where the item is not found in the gallery. This navigates to the AddEditScreen. Originally when you submitted the form, it would navigate back to GalleryScreen. However, we wanted to navigate to the DetailsScreen of the newly added item. NOTE: The SharePoint ID column does not iterate by 1 if an item was deleted, so we created a column called ID2. The default value of ID2 on the AddEditScreen would look for the last item in the SharePoint list and get the ID2 value for that and iterate it by 1 (For example, if OldExampleItem is the last submitted item in the SharePoint list with an ID2 value of 5, then the new item being created, NewExampleItem, would have a default ID2 value of 6 in PowerApps). Once we hit submit, we are navigated to the DetailsScreen. This allowed us to do a Lookup in the SharePoint list with the ID2 value on the DetailsScreen. When I'm testing within PowerApps this works perfectly fine. When I start testing outside of PowerApps (Play Mode or through the link), I run into an issue.
The issue:
I click "add item" and navigate to the DetailsScreen. I add everything needed & click submit. This navigates to the detail screen. However, instead of showing the details as expected, it shows "Getting your data...". NOTE: It still successfully submits and reflects that on the SharePoint list backend. I did some troubleshooting and found out that I can get this to work as expected if I (1) Search the gallery and click on one of the items - which navigates to the DetailsScreen (2) Click edit - which navigates to the AddEditScreen - and alter something, then submit the item. After this is done, you are able to add a new item successfully as expected. It no longer shows the "Getting your data..."
I'm glad that I figured out when this works and doesn't work, but I would like to try and fix this so that I don't need a workaround. I know that our users are not going to edit other items in order to add their items.
What I assume is that once I edit an item, it caches the SharePoint list. And once it's cached, we no longer need the Power App to "[Get] your data...", hence why it works after this. Does anyone have an idea why this happens? Can anyone advise me as to how I can fix this so I won't need a workaround. Please let me know if you need any additional information. I appreciate any help that anyone can provide.
Noticed a typo:
"The issue:
I click "add item" and navigate to the DetailsScreen."
It actually navigates to the AddEditScreen.
MS.Ragavendar
32
Michael E. Gernaey
19
Super User 2025 Season 1
WarrenBelz
18
Most Valuable Professional