I have a PowerApp where the primary source is a dataverse table. I load let's say 20 columns into the dataverse table coming from my SQL source. Then I've added 100 columns on the same table which are manipulated by the PowerApp. The dataflow with connection to the SQL is refreshed every 20 minutes and the records are normally updated properly.
In 99% of the cases this works fine, users log data via the app in the table for the 100 manual columns. They save the data and the saved data can be viewed afterwards properly.
However sometimes in like 1% of the cases, the saved data dissapears in my dataverse columns that are manipulated only in the app. It almost looks like the dataverse deletes and creates a new record instead of updating a record.
A few questions to get some more info if you don't mind:
1. Do you patch into Dataverse when a field is completed, or do you do them all at the end?
2. Have you checked to see if it's after 20 minutes of not saving data in that this happens?
3. Is the saved data saved and stored into Dataverse, and then it is overwritten? Or does the overwriting happen at the time a user saves from the power app, i.e. it saves blank values into the record?
Cheers,
Ryan
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
16
Share
Report
All responses (
Answers (
