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)

[yashag2255]

@Bhaskar 

Can you confirm if the excel sheet is open anywhere in a different browser or window in edit mode? When you are working with excel sheet as a datasource, it should not be open in edit mode elsewhere. If it is open, close the excel, wait for a minute and then click the button again to check if the runtime error still exists?

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 i have closed my Excel sheet and tried still the same error

If Possible Can we connect in Google Hangouts (bhaskarberg@gmail.com)?

[yashag2255]

@Bhaskar Can you try to clear the cache of your browser, logout and login again to check if the issue still exists? I do not see any issue with the latest formula.

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]

@yashag2255 after clearing cache tried to sync.. the data sync is success ,but still runtime error occurs.

[yashag2255]

@Bhaskar  This is really strange! Can you publish the app and check if there is any error that occurs in the Play mode. Also, try using different browsers to confirm the behavior.

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 i am checking in Incognito window.

[yashag2255 · Accepted solution]

@Bhaskar  I replicated the whole scenario on my machine and issue is occurring because of the way it is saved in the collection. Instead of saving the values for all columns in one row, it is creating new rows for each column. Due to this, blank value is getting passed, which is not a valid value.

Can you try to update the expressions as:

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."))

Highlighted row is the corrected one.

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!

[yashag2255 · Accepted solution]

@Bhaskar  Did the suggestions provided worked in your case? If there are still issues, let us know and 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]

@yashag2255 Your Suggestion worked finally for Runtime error, But Data is not saving in the table 

For Ex : If i provide Name and Email id and hit save button it is not reflecting in Blue Table , But when i click Sync button the Data is reflected in my Onedrive for business --Excel List.

Can you please help me to see the data in Blue table when i hit Save Button and when i click sync button the data should reflect in Green Table and as well as ODFB -->Excel sheet.

[Bhaskar]

@yashag2255 

Also can you help me in connection status button, i mean is there anyway to turn the button automatically when the internet is on(Button should be on).. If there is no internet then button should be off.