Navigate to specific record of a SharePoint list.

[J0nas]

I'm using powerapps to change the form (form 1) in a SharePoint list (list 1).

On the form there's a button to submit the data and go to a new screen (form 2) where I can create records in a different SharePoint list (list 2).

In list 2 there's a field which has the value of the ID of the original record of list 1, so this is the link between the 2 lists.

On form 2 I have a button to return to form 1, but I can't find how to return to the record I just created. It always returns to the first record in list 1.

[RandyHayes]

@J0nas 

What is the Item property of your first form?

[J0nas]

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected);First([@'List1']);SharePointIntegration.Selected)

I've tried changing 'First' to 'Last', but that didn't work. So far it only works if you select the record you want to edit. If it's a new record you have to create it first and then select it manually, but I want it automatically selected.

[RandyHayes · Accepted solution]

@J0nas 

Your form (with that formula on the Items) will only show the Selected record in your list or, the first one.

On the OnSuccess action of your form, add the following:

Set(glbCurrentRecord, Self.LastSubmit)

Then change your Item property to:

Coalesce(
    glbCurrentRecord;
    SharePointIntegration.Selected;
    First(List1)
)

[J0nas]

Thank you! You're brilliant.