Working Offline with PowerApps

[Bhaskar]

Hi All,
Can anyone help me to fix Runtime Error which i am getting for the app which i built for Offline Data sync from App to SharePoint excel.

Regards,

Bhaskar 
(bhaskarberg@gmail.com)

[mdevaney]

@Bhaskar 

You'll want to refer to the column name of the collection instead of your data table control in the app.

ForAll(Collection1, Patch(Table1, Defaults(Table1), {Title: Collection1[@Title], Email: Collection1[@Email]}));

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Bhaskar]

Still same error 😞

[mdevaney]

@Bhaskar 

Can you please share a screenshot of Table1?

[Bhaskar]

Datatable Online (Table1)

Datatable Offline (Stored in Collection1)

Save Button:

Set(RandomNumber,RoundDown(Rand()*1000,0));
If(Status.Value,
Patch(Table1,Defaults(Table1),{Title:Title_Column4.Text,Email:Email_Column2.Text});
Notify("Record saved to the cloud."),

Collect(Collection1,{id:Max(Collection1,id)+1},{Title:Title.Text},{Email: Email.Text});
Notify("Record Temporary saved."))

Sync Button:
If(!IsEmpty(Collection1),
ForAll(Collection1,Patch(Table1,Defaults(Table1),{Title: Collection1[@Title],Email: Collection1[@Email]}));
Clear(Collection1);Notify("Sync Process done."),
Notify("No Data to sync.Sync Aborted."))

Let me know if any further details required

[yashag2255]

Hi @Bhaskar 

Can you try to update the expressions to:

Save Button:

Set(RandomNumber,RoundDown(Rand()*1000,0));
If(Status.Value,
Patch(Table1,Defaults(Table1),{Title:Title_Column4.Text,Email:Email_Column2.Text});
Notify("Record saved to the cloud."),

Collect(Collection1,{id:Max(Collection1,id)+1},{colTitle:Title.Text},{colEmail: Email.Text});
Notify("Record Temporary saved."))

Sync Button:
If(!IsEmpty(Collection1),
ForAll(Collection1,Patch(Table1,Defaults(Table1),{Title: colTitle,Email: colEmail}));
Clear(Collection1);Notify("Sync Process done."),
Notify("No Data to sync.Sync Aborted."))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Bhaskar]

No this solution also did not help me 😞

still same error

[yashag2255]

@Bhaskar 

Can you confirm where this excel is stored? To be able to update changes on a table in excel sheet, the sheet should be present on online services like OneDrive For Business etc. If this is a static sheet stored on your local machine, then the functionality is not achievable. You will have to store it online. If you can share more details about the excel sheet, we will be able to help you better!

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Bhaskar]

Yes it is stored in One drive for Business

[GarethPrisk]

To be clear:

• You developed an app with offline capabilities
  • You are using SaveData to collect data (online)
  • You are using LoadData to use/update data (offline)
  • https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-savedata-loaddata
• You are then trying to sync the data to Excel (as ODfB) using a function when back online
  • Given how you wrote the function, presumably these are all new rows
  • Is Collection1 the "offline" collection? How are you populating it?
  • Can you populate Collection1 in the studio (online), and does the simple patch of Table1 from Collection 1 work

As others noted, this probably is a simple mismatch of Collection1 columns to Table1 columns. Since your screenshots are from the studio, I would just confirm that your Collection1 is correct and you're able to collect a single row into it, and then patch the data source. Then you can expand into the ForAll and If/Then processing.