Hi @CH4646 ,
My original reply assumed the Power App was a Canvas App and not a SharePoint Integration App.
I re-did the example as a SharePoint Integration App. This was much more difficult to do when the user has the ability to "Edit" the item.
I am going to include the full instructions here:
1) Add "Back" and "Next" icons to your form.
2) For the "Back" icon, set the OnSelect property to (replace "Your List" with your list name datasource):
If(IsBlankOrError(varCurrentItem),
Set(
varCurrentItem,
If(
IsBlank(SharePointIntegration.Selected),
First([@'Your List']),
SharePointIntegration.Selected
)
)
);
Set(
varPreviousID,
LookUp(
Sort(
'Your List',
ID,
SortOrder.Descending
),
ID < varCurrentItem.ID
).ID
);
If(
IsBlankOrError(varPreviousID),
Notify("First Record in List");
,
Set(
varCurrentItem,
LookUp(
'Your List',
ID = varPreviousID
)
);
)
3) For the "Next" icon, set the OnSelect property to:
If(IsBlankOrError(varCurrentItem),
Set(
varCurrentItem,
If(
IsBlank(SharePointIntegration.Selected),
First([@'Your List']),
SharePointIntegration.Selected
)
)
);
Set(
varNextID,
LookUp(
Sort(
'Your List',
ID,
SortOrder.Ascending
),
ID > varCurrentItem.ID
).ID
);
If(
IsBlankOrError(varNextID),
Notify("Last Record in List");
,
Set(
varCurrentItem,
LookUp(
'Your List',
ID = varNextID
)
);
)
4) In the App - OnStart property, set it to:
If(
IsBlankOrError(varCurrentItem),
Set(
varCurrentItem,
SharePointIntegration.Selected
)
)
5) For the SharePointform1 - "Item" Property, change it to:
Coalesce(varCurrentItem, SharePointIntegration.Selected,Defaults('Your List'))
Thanks to @RandyHayes for that piece of code from here:
Solved: SharePointIntegration - how to navigate to specifi... - Power Platform Community (microsoft.com)
6) For the SharePointForm1 - "OnSuccess" Property, change it to:
ResetForm(Self);
Set(
varCurrentItem,
Blank()
);
RequestHide();
7) For the FormScreen1 - "OnVisible" property, set it to:
Set(
varCurrentItem,
SharePointIntegration.Selected
)
Let me know if you run into any more issues.
Please consider giving this reply a Thumbs Up as it counts towards the ability for users to be recognized in the Community as contributing for everyone's benefit. As does marking an answer as a Solution.
-Mark
