Power Apps - Building Power Apps

Cannot get my Edit Forms to show the correct item ID from connected SharePoint list

Like (1) Share

Report

Posted on 1 Apr 2025 14:57:54 by LS579

130

Hi,

I have a complicated App I have been working on that is connected to a very simple SharePoint list. Two weeks ago, the App was functioning properly; forms showing correct info, etc., then all of a sudden, I cannot get the forms to point to the correct item ID no matter what display mode I put the form in. Below is the Structure of the App and code used to connect the forms to the SharePoint Site:

Power Automate workflows send emails with deep links to approval screens and form upload screens. Links are dynamic and showing the correct ID, but when link is clicked, the edit form shows the first item ID in the list.

6 Screens:

- Detail Screen (New/Edit form)

- Approval Screen

- Form Upload Screen

- data entry screen for new resource info

- Additional Request Screen

- Exit Screen - Dynamic message depending on Request Status

All forms have the below code in the Item property and Default Mode is set to Edit mode:

If(
    IsBlank(SharePointIntegration.Selected),
    First('Data Source'),
    SharePointIntegration.Selected
)
 
In Edit display mode, the forms are showing the first item in the list as though it isn't recognizing.
In New display mode, the form shows no data as a new form should.
 
Please let me know if there is any other information needed to help troubleshoot this issue.
 
Thanks!

Categories:

Connectors

Using Apps Using Formulas

General Questions

Connecting to Data

All responses (3)

Answers (0)

ronaldwalcott 1,953 on 01 Apr 2025 at 18:57:52

Like (0)

Report

Cannot get my Edit Forms to show the correct item ID from connected SharePoint list

First create a new simple view and display the SharePointIntegration.Selected object to see if it is working as expected.
LS579 130 on 01 Apr 2025 at 17:03:13

Like (0)

Report

Cannot get my Edit Forms to show the correct item ID from connected SharePoint list

Thanks for your response, @Michael E. Gernaey.

I see what you are saying. For my deep links, in the OnStart property of my App, I have the below code:

Set(

varResourceItem,

LookUp(

'OB Resource Request',

ID = Value(Param("ID"))

)

);

Set(

varRequestStatus,

LookUp(

'OB Resource Request',

ID = SharePointIntegration.SelectedListItemID

)

)

However, I am not utilizing the variables because when I was, the same thing would happen.

My Deep Link in the workflow consists of the screenname param along with the ID, according to the below:

Switch(

Param("screenname"),

"Onboard",

'Resource Detail Screen',

"CFMApproval",

'CFM Approval Screen',

"Upload",

'Form Upload Screen',

"EmailSOUID",

'DAS Email & SOUID Screen',

"Offboard",

'Offboarding Request Screen'

)

This is how my deep links in the workflow email is constructed:

Current App version URL and ID "&screenname=CFMApproval&ID=@{triggerBody()?['ID']}"

and yes, that was working a couple weeks ago and then I noticed there was a new Power Apps release just 3 days after I completed everything and tested and everything was working. I was waiting for a colleague to make changes to the email verbiage in the workflows and start testing, so I had not touched the app during that time. She started testing and immediately said it wasn't showing the correct item ID information when she clicked on the link and the only thing I noticed, that could have messed with it was the release. I tried republishing the last version I had working, but it keeps switching back to the newest release.

So, for your suggested answer, where you have the "myidfromurl" should I put "ID=@{triggerBody()?['ID']}"? Or do you have an example of what should go in that place?
Suggested answer

Michael E. Gernaey 38,204 Super User 2025 Season 1 on 01 Apr 2025 at 16:08:31

Like (1)

Report

Cannot get my Edit Forms to show the correct item ID from connected SharePoint list

Hi @LS579

So to be honest I am surprised it is working before and have to assume something has changed or there are details left out.

The reason is, you said you are creating a deep link. A deep link is not going to set the integration to anything because you are passing in the ID. This means your .Selected would be, at best, the first record AND your IsBlank sets it as First record.

When passing in an ID on the Param URL you would need to do a LookUp against that ID to show the correct one from your OnStart.

So something like (and understand I do not see your app)

If(

  IsBlank(SharePointIntegration.Selected),

   If(IsBlank(Parm(myidfromurl), First('Data Source'), LookUp('Data Source', ID = value(myidfromurl))

,

  SharePointIntegration.Selected

)