SharePointForm1 always shows first item in editor

(0) Share

Report

Posted on by steve_hendy

385

Why is the editor still showing me the first item in the list when I have a lookup in item?

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),LookUp([@'Training Certificates'],ID=305),SharePointIntegration.Selected)

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@steve_hendy

Change your Item formula to the following:

Coalesce(SharePointIntegration.Selected, LookUp('Training Certificates', ID=305))

I hope this is helpful for you.

Was this reply helpful? Yes No
steve_hendy 385 on at

Like (0)

Report

What a very clever chap you are. Thanks for the quick reply works perfectly. I did try googling it 😀

Was this reply helpful? Yes No
steve_hendy 385 on at

Like (0)

Report

Its stopped working now. Its reverted back to the first item. ☹️

Was this reply helpful? Yes No
steve_hendy 385 on at

Like (0)

Report

Maybe there is a setting interfering with it under app settings.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@steve_hendy

Based on that formula, you would have either the item selected in your list when you do a New/Edit of the item, or the record with ID 305. It is impossible to have record 1. So, your Selected in the list must be record 1.

The way Coalesce works is it returns the first non-blank parameter. So if your SharePointIntegration.Selected has a record, that will be the one shown. If there is no record selected (pretty much would never happen), then it would show record with ID 305. If for some very rare reason, both are blank, then your form would show "getting data" and never display.

SO...your Selected is record 1 or there is something else going on in your app.

Was this reply helpful? Yes No
steve_hendy 385 on at

Like (0)

Report

Its ID=1

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@steve_hendy

Right...so then your SharePointIntegrated.Selected item is 1

Was this reply helpful? Yes No
steve_hendy 385 on at

Like (0)

Report

So how do I make it id=305 like the picture above? Its the same issue in edit or view mode.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@steve_hendy

Well, I'm not really understanding your purpose then... Is the purpose of your app to always display and edit record 305? Or is your purpose to display and edit the record selected from your list?

Was this reply helpful? Yes No
steve_hendy 385 on at

Like (0)

Report

Only when I'm in the editor for all modes. Not when I'm in SharePoint.

Was this reply helpful? Yes No