SharePointForm1 always shows first item in editor

[steve_hendy]

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)

[RandyHayes · Accepted solution]

@steve_hendy 

Change your Item formula to the following:

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

I hope this is helpful for you.

[steve_hendy]

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

[steve_hendy]

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

[steve_hendy]

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

[RandyHayes]

@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.

[steve_hendy]

Its ID=1 

[RandyHayes]

@steve_hendy 

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

[steve_hendy]

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

[RandyHayes]

@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?