cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Philip2
New Member

Button to jump to the next Sharepoint List entry

Hi,

 

I have started using Powerapps a few hours ago. The purspose of the app is to connect to a Sharepoint list (customer data with attributes), which should be displayed to our sales collegues. They should go through the list and validate or add the data.

 

I have used the standard template, which gives me the phone layout. This has some limitations, I'm missing the possibility to "swipe" through the list in the edit mode. Currently there is only an option to go into the edit mode, and leave it with the "ok" button. This brings me back to the "Browse Screen". My idea is to insert a button in the edit mode, which saves the entries and automatically moves to the next entry.


Has anyone an idea if this is possible and understandable for a beginner?


Thanks a lot

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @Philip2 ,

Do you mean that you want to add a button to move to next record when you are in the edit form screen?

I've made a similar test for your reference:

1)insert 3 buttons in the edit form screen.

2)one for reset

set the reset button's OnSelect:

ResetForm(Form1)

3)one for save

set the save button's OnSelect:

SubmitForm(Form1);Navigate(Screen2);Set(var1,false)

4)one for jumping to nest record

set the next button's OnSelect:

SubmitForm(Form1);Set(var1,true)   //use variable to justify whether you click the next button

5)set the edit form's Item:

If(var1,LookUp(tablename,ID=Gallery1.Selected.ID+1),Gallery1.Selected)  
//if you haven't clicked the next button, the item display the selected item
if you clicked the next button, save the current item and then jump to next item.

10142.PNG

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yutliu-msft
Community Support
Community Support

Hi @Philip2 ,

Do you mean that you want to add a button to move to next record when you are in the edit form screen?

I've made a similar test for your reference:

1)insert 3 buttons in the edit form screen.

2)one for reset

set the reset button's OnSelect:

ResetForm(Form1)

3)one for save

set the save button's OnSelect:

SubmitForm(Form1);Navigate(Screen2);Set(var1,false)

4)one for jumping to nest record

set the next button's OnSelect:

SubmitForm(Form1);Set(var1,true)   //use variable to justify whether you click the next button

5)set the edit form's Item:

If(var1,LookUp(tablename,ID=Gallery1.Selected.ID+1),Gallery1.Selected)  
//if you haven't clicked the next button, the item display the selected item
if you clicked the next button, save the current item and then jump to next item.

10142.PNG

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

jvanrossum
Advocate IV
Advocate IV

Here is some code to go to the next item from the gallery which can be used for either a next button or a save-and-goto-next-row button:
PowerAppsNext00.png

Hi @v-yutliu-msft 

Could you please clarify what is the "table" on the Lookup function?

where does the last bit of code/formula go? 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,164)