Sharepoint list offline

(0) Share

Report

Posted on by dominikgr

Hi,

I am trying to create a basic app with a sharepoint list as datasource.

It should be possible to run offline.

I created an auto generated sharepoint list app, which means I have 3 forms: a BrowseScreen, a DetailScreen and an EditScreen.

With the saveData function I managed to run the app offline.

But now I have 2 problems:

1. Editing a record in offline mode, the lookup to another table won't work. (The orders Table has a relation to the customer table) Is there a way to make this work.

2. After editing a record, it is saved to another collection. Online again, the sharepoint list should be updated.

I tried following code patch(Orders, LocalOrders) but that didn't work. Can somebody help me with these matters?

Thanks

Regards Dominik

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi dominik1,

About question1, I am afraid that SharePoint Lookup column type is currently not supported in an Offline app.

Please consider to submit a request at PowerApps Ideas Forum:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

About your question2, please configure the code to something likes below:
ForAll(LocalData,Patch(ListName,Defaults(ListName),{Title:LocalDataColumn1,number:Value(LocalDataColumn2)}))

Hope this could be a reference for you.

Best regards,
Mabel Mao
dominikgr 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

finally I had time to test your solution for posting. That worked perfectly fine.

About the lookup: is there some work around. For example I have two sharepoint lists saved in collections.
A form shows the records of a list, one value has a relation to the other table. Is there a way to manualy build the lookup when offline?

Thanks a lot

Regards Dominik
Delid4ve 795 on at

Like
a
(0)

Report
Copy link

Link copied!

Not tried this but..

Can you collect the lookup values into a signle column collection, then use this??
Failing that..
I hate lookups in sharepoint, old school way, another table with the values and store the ID of the value in your main table (normalised data, seems to have gone out the window with sharepoint, yet nothing seems to work with lookup columns)