Answered

Edit form always shows the first record in SharePoint

(0) Share

Report

Posted on by beysinguzel

Hello, I have an issue that am trying to solve for days but still couldnt fix. When I click the edit selected query, it always show the first record. I have checked everywhere and I couldnt find how can I fix the issue. I am sharing screenshot of the issue.

Thank you for the assistance in advance,

Screenshot 2023-08-16 122242.png

Screenshot 2023-08-16 122315.png

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 155,957 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @beysinguzel ,

What is the Item of the form ? You can try

With( {_ID: SharePointIntegration.SelectedListItemID}, If( _ID > 1, LookUp( YourSPList, ID = _ID ), First(YourSPList) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
beysinguzel 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz
Where can I try this code. Below is my form

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,957 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@beysinguzel ,

As noted - the Item of the Form. You also have a Gallery there - I assume this is not part of the problem.

Was this reply helpful? Yes No
YYZR 3 on at

Like
a
(0)

Report
Copy link

Link copied!

This issue is due to a change in the data source of your form (i.e. if you rename the SharePoint list, it will cause this problem).

Here are some steps you can take to resolve this issue:
Recreate the Form: One way to fix the issue is by deleting the custom form and recreating it.
Export and Modify the App: You can export your Power App, unzip the export, and then locate the .msapp file (which is the actual Power App). Make a backup copy and change the .msapp file extension to .zip. 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 data source on the form, you will find that when you export the Power App, one of the references does not get updated. You can manually update this reference, re-zip the subfolder and rename the zip back to .msapp, re-zip the entire Power App zip package and import it back.
Use Browser Console: You can also try to fix the issue using the browser development console (F12). Go to the form where you got the SharePointIntegration.SelectedHidden error in the Power Apps editor and type in the instructions in the console. Change all the references to data sources in your app that use the .ID column to .'Id (ID)'.

If you don't want to try any of the steps above, you can try to edit the SharePointForm1.Item property as follows:

If(IsBlank(SharePointIntegration.SelectedListItemID),First([@'TheNameOfYourListGoesHere']),LookUp([@'TheNameOfYourListGoesHere'],ID=SharePointIntegration.SelectedListItemID))

Was this reply helpful? Yes No