Power App Randomly Not Saving Data from a Collection

(0) Share

Report

Posted on by CT-09122101-0

Created a Power App that is a shopping cart to order used furniture in. We also have a screen on the app that allows end users to put a pick up request in to have our teams come get furniture they no longer use.

I am storing everything in Sharepoint Lists. Currently it writes the details of the order to one sharepoint list and the order header detail to a second list. The pick up part of the app also has a sharepoint list it writes to for the order detail, and then writes the order header detail to the same list the furniture app does. So in total i have 3 sharepoint lists that can be written to, but only two lists get touched per order.

I then have an email setup with information to go to the end user and myself once the order is placed.

What I am running into is that randomly an order will not place data in the sharepoint lists like it should but the app is sending the confirmation email. I changed the confirmation email to now send through power automate instead but i left one of the confirmation emails to go to myself so i could double check.

99% of the time the orders go through fine without any issues. the 1% that do not go through i get the order confirmation email, but not the power automate email. I have tried to trace this back and can not figure out what the issue that could cause this to happen. I have checked security rights for the end user and there is nothing that stands out. I have had the same end users whose orders did not save, resubmit the orders and they work fine. I am truely stumped.

Currently we are using the Collection functionality to store the data to the sharepoint list.

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Garima_PowerPlatform 170 on at

Like (1)

Report
Copy link

Link copied!
Hi,

Causing inconsistencies in how your app interacts with SharePoint and Power Automate

Error handling
IfError(
Patch(YourSharePointList, Defaults(YourSharePointList), YourRecord),
Notify("Failed to save order.", NotificationType.Error)
)

Implement error handling in Power Apps (e.g., IfError() or Errors()).

Check for delayed writes to SharePoint and use Power Automate retries.

Review Power Automate flow triggers and run history to find discrepancies.

Revisit SharePoint list permissions and make sure users can access all required lists.

Ensure data validation is in place for all required fields in SharePoint.

Test manually to see if you can replicate the issue.

Monitor SharePoint throttling and apply a delay if necessary.

Was this reply helpful? Yes No
Suggested answer

timl 37,212 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I guess that you're saving the records by calling Patch? If so, for the initial part where you write to the 2 tables, I would error handle this by sending the email if the 2 calls to patch succeed.

IfError( Patch( OrderDetailList, Defaults(OrderDetailList), {your order detail} ), Notify("Error saving order detail", NotificationType.Error), IfError( Patch( OrderHeaderList, Defaults(OrderHeaderList), {your order header detail} ), Notify("Error saving order header", NotificationType.Error), //Send email here only if there are no errors 'PowerAutomateFlowToSendEmail'.Run() ) );

Was this reply helpful? Yes No
ronaldwalcott 3,906 Moderator on at

Like (0)

Report
Copy link

Link copied!

Is the user using a mobile device, the network connection could be dropping?

At which point are you sending the email?

Was this reply helpful? Yes No