powerapp network error when submitting form

[chunjie]

Hi

i have a powerapp embedded in powerBI dashboard that allows users to write back data into a seperate excel table on sharepoint which is then used in the dashboard visuals. 

The app window in powerbi dashboard is able to reflect the changes and pick up data from the excel table on sharepoint, however when i tried to submit the form an error "Network error when using patch function: The specified record was not found." 

What i do not understand is that the app is able to pick up the data in the excel file but unable to update.

[Ritaf1983 · Accepted solution]

Hi @chunjie 

The "network error when using patch function the specified record was not found" usually occurs if there's a mismatch between the record you're trying to patch and the records in your data source. This could be due to an incorrect or missing identifier for the row you want to update, or the record may have been moved or deleted in the source Excel file.

Check the following:

1. Ensure that the Excel table has a primary key column that uniquely identifies each row.
2. Verify that the app's connection to the Excel table on OneDrive is active and has the correct permissions.
3. Make sure that the row you're trying to update still exists in the Excel table and hasn't been altered outside of PowerApps.

If the issue persists, consider refreshing the data source connection or checking for any recent changes to the Excel file structure that might affect the app's ability to locate the record.

For more information, I recommend posting in Power app forum :

https://powerusers.microsoft.com/t5/Get-Help-with-Power-Apps/ct-p/PA_General

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly