cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
paddlesnap
Level: Powered On

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
paddlesnap
Level: Powered On

Re: fix an error in SharePointIntegration.SelectedHidden property

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

View solution in original post

4 REPLIES 4
paddlesnap
Level: Powered On

Re: fix an error in SharePointIntegration.SelectedHidden property

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

View solution in original post

FacundoGorla
Level: Powered On

Re: fix an error in SharePointIntegration.SelectedHidden property

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?

harea
Level: Powered On

Re: fix an error in SharePointIntegration.SelectedHidden property

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
Level: Powered On

Re: fix an error in SharePointIntegration.SelectedHidden property

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. 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 113 members 5,141 guests
Recent signins:
Please welcome our newest community members: