cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paddlesnap
Frequent Visitor

fix an error in SharePointIntegration.SelectedHidden property

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

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
paddlesnap
Frequent Visitor

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

View solution in original post

Anonymous
Not applicable

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 

View solution in original post

15 REPLIES 15
paddlesnap
Frequent Visitor

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

View solution in original post

FacundoGorla
Resolver II
Resolver II

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
Not applicable

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 

View solution in original post

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. 

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

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.

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

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. 

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.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (52,626)