fix an error in SharePointIntegration.SelectedHidden property

[paddlesnap]

Hi, Is there any way to access the "SelectedHidden" property of SharePointIntegration? I am trying to debug a few PowerApps errors (see screen clip attached).

These errors came up after I renamed the SP list that feeds the powerapps form, then added the new datasource (the new list name) and changed all references to the old one.

Thanks

[paddlesnap · Accepted solution]

Update: I was able to correct the integration problem by deleting the custom form and re-creating it.

[FacundoGorla]

Hi, I´m having the exact same problem and the form has a lot of customization. Did you Deleted and start all over again from scratch or there's any way to delete and then recovery it and have the problem solved?

[Anonymous · Accepted solution]

1. Export your PowerApp and Unzip the export.

2. Inside the export (a few folders deep), there will be a file with a .msapp extension (this is the actual PowerApp).

3. Make a backup copy and change the .msapp file extension to .zip

4. Extract the zip and you will see a few folders with a bunch of json files in it. One of those files has the logic that defines the SharePointIntegration Object. If you have ever renamed your DataSource on the Form, you will find that when you export the PowerApp, one of the references does not get updated. For my PowerApp, I looked through the json files and in a file named "1.json", I found that it was setting SharePointIntegration.Selected to LookUp(<old DataSource Name>, .....) and that is the error that is being thrown in PowerApps

5. Upon updating it, re-zipping the subfolder and renaming the zip back to .msapp, re-zipping the ENTIRE PowerApp zip package and importing, everything worked!

Code snippet from 1.json:

"Children": [
{
"Type": "ControlInfo",
"Name": "SharePointIntegration",
"Template": {
"Id": "http://microsoft.com/appmagic/hostcontrol",
"Version": "1.4.1",
"Name": "hostControl",
"FirstParty": true,
"IsCustomGroupControlTemplate": false,
"CustomGroupControlTemplateName": "",
"HostType": "SharepointForms",
"OverridableProperties": {}
},
"Index": 0,
"PublishOrderIndex": 0,
"VariantName": "SharePointHostControlVariant",
"LayoutName": "",
"MetaDataIDKey": "",
"PersistMetaDataIDKey": false,
"IsFromScreenLayout": false,
"StyleName": "",
"Parent": "App",
"IsDataControl": true,
"IsGroupControl": false,
"IsAutoGenerated": false,
"Rules": [
{
"Property": "DataSource",
"Category": "Data",
"InvariantScript": "'<New Data Source>'"
},
{
"Property": "SelectedHidden",
"Category": "Data",
"InvariantScript": "LookUp('<Old Data Source Name was Here Throwing Errors>', ID = SharePointIntegration.SelectedListItemID)"
},

Extract the 

[Runner55552]

You were correct.  I found a single reference to my old list in the json code (1.json).  I will give this a try.  A little nervous about importing, but we'll see what happens. 

[Lam01007]

Hi @Anonymous ,

How did you rezip the msapp file? use Windows compression tool or 7zip or others?

I just extract the msapp file, and didn't change any file, then zip the file, but the file size is different from the original msapp file

And I follow the steps to import the PowerApps, success import it, but fail to open to edit the PowerApps and got the "There was error opening the file."

Thanks for advice.

Lam

[Runner55552]

Following the instructions worked for me. But I noticed you said you did not change any files. The point is to find the references to the old list and change it to the new list where you want to import the app.

But, I just used regular Windows compression, and it worked for me.  You have to be careful, because there are multiple folders, and make sure when you zip it back up, everything is the same as in the original folder structure.

[Lam01007]

Hi @Runner55552 ,

Thanks for your advise, I was tried to use Regular Windows Compression, and also follow the original folder structure, but still not work.

Finally, I use the "7-zip file manager" to directly open the msapp, and extract the 1.json only, then drag & drop back the updated 1.json to the msapp, such that, it can avoid the issue

[Anonymous]

Exact problem in my case.  "There was error opening the file."

And it's only happening when i edit files inside .msapp.

Other edits are OK. 

[PatrickMtl]

I had the same problem when trying to export, unzip, update and re-zip. I would end up with the same error message: "There was error opening the file."

Then I tried editing the files without unzipping it, using 7zip, like @Lam01007 suggested. Import worked this time but the App was incomplete and the main screen was missing !

At the end of the day, the error came from the fact that I had renamed the list so I temporarily renamed my list to the original name (not necessarily the internal name but the display name that was there when I created the PowerApps form) and imported the zip.

Worked perfectly.

Finally, I changed the list name to the one I wanted.