Answered

Form Next record button

(0) Share

Report

Posted on by ksmith23

I have a display form that I want to add a button to take the user to the next record from the list. I am new to powerapps and not sure how to accomplish this.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

Adrian_Celis 1,652 Moderator on at

Like (0)

Report
Hi @ksmith23
Here's a start. You can have your selected record as a variable (for this example let's call it varRecord). Then in your Next button you can add a function to go over the next record.

UpdateContext({varRecord:LookUp(YourDataSource,ID=varRecord.ID + 1)})

Was this reply helpful? Yes No
ksmith23 24 on at

Like (0)

Report

How do I set the variable for the form on the Items? I am not sure of the formula I need to use.

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like (0)

Report
Hi @ksmith23

For example, if you have a gallery for your data source in the same screen, you can have a button in a gallery and on its OnSelect property, you can set a variable named varRecord like:
UpdateContext({varRecord:ThisItem})

Was this reply helpful? Yes No
TimothyTrimble 14 on at

Like (1)

Report

Is there any other action needed? I added two icons to the top of my details form and added the functions. Nothing happens when selected.

Was this reply helpful? Yes No
Blarue 76 on at

Like (0)

Report

Same here, what step is missing?

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like (0)

Report

Hi @TimothyTrimble @Blarue
Late reply. But did you put varRecord in the Items property of your form?

Was this reply helpful? Yes No
Blarue 76 on at

Like (0)

Report

@TimothyTrimble I found another way to achieve this same effect. its a bit more work but it may be due to the fact that my gallery is filtered, not sure but here it is.
My Gallery has a button/Icon with OnSelect property set to Select(Parent) and navigate to the screen with the edit form.
The Edit form's screen has it's On Visible property set to Set(varRecord, MyGallery.Selected.ID)
On my next button/icon I have on the OnSelect property
Set(varRecord,Min(Filter(MyGallery.AllItems,ID > varRecord),ID))
and on the my back button/icon' OnSelect property Set(varRecord,Max(Filter(MyGallery.AllItems,ID < varRecord),ID))
And lastly, my item property on my form is set to LookUp(MyDataSorce ID = varRecord)

2 people found this reply helpful.

Was this reply helpful? Yes No
RobinHan 4 on at

Like (1)

Report

Hi, thanks. but how about if the data source record were deleted, so the record ID will not be continue.
then this way via the ID +1 or -1 should be not work perfectly. any other better solution?

Was this reply helpful? Yes No
KI-13090739-0 12 on at

Like (0)

Report

you are absolutely right. That was also my first thought

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like (1)

Report
Hi @RobinHan
Good point.

Approach 1:
You can do this approach, but this has a delegation limit
Previous button

UpdateContext({varRecord:First(Filter(Sort(MyDataSource,ID,SortOrder.Descending),ID < varRecord.ID))})

Next Button

UpdateContext({varRecord:First(Filter(MyDataSource,ID > varRecord.ID))})

Approach 2:
Get the next/previous item by Created date. This will not work if your items are created in bulk at the same time
Previous Button

UpdateContext({varRecord:First(Filter(Sort(MyDataSource,ID,SortOrder.Descending),Created < varRecord.Created))})

Next Button

UpdateContext({varRecord:First(Filter(MyDataSource,Created > varRecord.Created))})

Approach 3:
You can have a helper column that is a number type. Everytime you patch, you patch a sequential number in that column. This will not have the delegation warning. Let say we call our helper column Sequence.
Previous Button

UpdateContext({varRecord:First(Filter(Sort(MyDataSource,ID,SortOrder.Descending),Sequence < varRecord.Sequence))})

Next Button

UpdateContext({varRecord:First(Filter(MyDataSource,Sequence > varRecord.Sequence))})

Was this reply helpful? Yes No