Hi there - I'm trying to retrofit an existing sharepoint-driven powerapp to allow it to work offline and upload data when reconnected. At this point I've got to the below changes for the submission tick/check on the form page (1) and an upload timer running (2).
As you may have guessed this doesn't have the desired effect - any guidance or support greatly appreciated.
Thanks - Guy
I'm trying to do the same thing. Did you see Carlos Figueira's post ? I just had a colleague of mine test my application (an event check in app,) last night, and due to connectivity issues with the PATCH function the app didn't go as smoothly as I would have liked (100+ people checked in, and each item was being PATCH'd individually for check in.)
Here's Carlos post... I am going to try to solve this today and will let you know if I have any luck.
I have the same problem trying to refresh an onedrive excel connection when the app get connected again.
whta I do:
* Screen 1: button with the OnSelect: Refresh(formulario1);Navigate(Screen2,ScreenTransition.Fade) "Formulario1" is the datasource to excel in onedrive
* Screen2: I have a Data Table connected to "Formulario1" onedrive excel data Source
when I start the app with internet connection, the screen 2 shows the formulario1 values normally.
then I go to flymode and when press the button on screen1, it goes to screen 2 and shows me a connection error (Normal)
I go to flymode off an with the button goes to screen 2 and the data table shows me the formulario 1 values.
In that way it works fine. The problem occurs when I launch powerapps bein in flymode on, the app load, and when i press the button (In flymode on) the datatable doesn't shows nothin (Normal because still in flymode) but when I turn off the flymode, It shows an "unknown error" if I press the button.
It seems that the app isn't able to create a connection with the data source when the app has been launched on flymode.
I am stuck in the middle of Offline submission.
I have a table --production and its have 2 columns are productcode and productname.
The production table created from common data service datasource.
Can you please give me the example with produvtion table in the offline submission.
I have tried Onvisible and onselect but its not worked getting some syntax error.
Please give me the step by step.
Please anybody give me exact answer or suggestions to solve this issue.
This is the way to collect form data and then submit it when you come back online.
First using Collect:
Collect stores table or record values. I found the Submit form is not a correct format of table or record value.
Instead you have to store the fields from the form to the collection like so.
Each time you write a record offline it stores the data that is entered on the form into the collection (Table) as a row.
When you come back online you can't use the SubmitForm either since all that does is submits the currently displayed form.
What I found is you have to Patch your table, which I understand could be hard using common data source since it requires an id for the row.
Any other source is not a problem.
You write the data online like so.
In this instance, dataToWrite is an actual table with rows, since we created it while collecting record rows.
In my case I used a spreadsheet on OneDrive as the source.
You would want to clear it as soon as it is written.
I hope this provides a solution.
I forgot to mention after clearing the written data, it should be saved again to replace the local data (clear it) so the next time the cycle runs it won't rewrite the same records.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand