Answered

PowerApps opening wrong list item from SharePoint

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

When I am selecting from a SharePoint list to edit an item, Powerapps will always open the top item of the SharePoint list.

Any way to fix this?

Craig

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Did you generate the PowerApp from the SPList to get started or are you creating from a blank PowerApp and adding the SPList to the app? I ask because the PowerApps generated SPList app wires everything up for you and I have never experience an issue with the selected item not working as expected.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Jeff,

I generated it from the SP list itself. I've done it this way a couple of times myself with no issue.
I've had a read online and there is not much to go by apart from perhaps the 'Item' field picking up the wrong field?

Thanks

Craig

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Can anyone advise what my settings should look like perhaps on the SharePoint Integration page to cater for this?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@audrieg @v-micsh-msft @v-monli-msft @Meneghino Can any of you advise on how to link PowerApps to a selected SharePoint list field please? My app is currently only every loading the very first SharePoint list item.

Thanks

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous, it would seem that the issue is with the Item property of whatever is opening when you select an item. Could you please share the OnSelect property of the gallery/item selector and then also the closest thing to the item property of the object that should display your item?

Was this reply helpful? Yes No
Verified answer

navPowerApps 11 on at

Like (2)

Report
Copy link

Link copied!

Hi,
I had faced similar kinda issue in my powerapps. I have tried aplying the below Rule as workaround,

If(IsBlank(SharePointIntegration.SelectedListItemID) || IsEmpty(SharePointIntegration.SelectedListItemID),First('[DataSource]'),First(Filter('[DataSource]',ID=SharePointIntegration.SelectedListItemID)))

After applying the Rule it started working for me.

Was this reply helpful? Yes No
SriHariBabu 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the fix. After applying condition in form >> advanced properties, it worked for me.

Was this reply helpful? Yes No
jb007 49 on at

Like (0)

Report
Copy link

Link copied!

This issue has just arisen for me as well. Can you advise where you loaded the condition

Was this reply helpful? Yes No
Bestebreurtje 37 on at

Like (0)

Report
Copy link

Link copied!

Did you get any response where to set this condition ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you @SriHariBabu @navPowerApps @Jeff_Thorpe !
I had the same issue - it works fine in PowerApps, but if someone clicks to edit an item from the SharePoint List, it just opens the last item clicked on in the power app.
Example of the powerapp form screen that is pulled up when I select an item:

As you can see, it is not the item I have selected in the SharePoint list itself.
However, if I click edit from the PowerApps pane that opens, it brings me to the correct item:

Was this reply helpful? Yes No