Auto Increment - In my Canvas PowerApp with SPO List, how to auto Increment Question Number?

I Have a Canvas App with the screen shown as an attachment.

Currently, user submits his/her response for the selected Question Number from the dropdown and the description of the question underneath changes based on the selected Question Number. The response input gets submitted to a SPO list titled "Responses" against the selected question No.

There are total of Ten (10) Questions.

I have attached the screen shots of my screen and the Submit button code.

ISSUES:

The goal is to automate the process.

I do not want User to select the question Number. At each submit click the question number and the description should move to the next one. How do I auto increment the Question Number in a Text Box or in a Label Box, where User cannot change the question No. and then submit the his response for that question number via a Submit button?
This way User has to respond all the questions in order to be considered "Complete" for his/her review..
If User logs off in the middle of the Review Process, how can I assure that he/she continues from where the process is left off? (Is this done automatically by PowerApps?)

Any suggestion is appreciated.

Thank you,
SueA.

Hi @SueA ,

First of all, I think users will select a Bill from a Gallery. So, you can create a variable to save or initialize the question No. depending on the latest question No. If there is no question No. for that Bill, give it the original No: 1. Then on submit, you can use the UpdateContext function to add 1 for the variable, and the Text property of Question No Label should set to this variable.

Gallery OnSelect:

Navigate(QusetionScreen, ScreenTransition.None, {varQuestionNo: If(IsBlank(LookUp(Responses, BillsID = galTitlesHome.Selected.ID && ReviewerID = varReviewerID.ID, QuestionNo)),1,LookUp(Responses, BillsID = galTitlesHome.Selected.ID && ReviewerID = varReviewerID.ID, QuestionNo)+1)})

OnSelect of submit button:

UpdateContext({varQuestionNo:varQuestionNo+1});If(varQuestionNo >10, YourOriginalCodes;Navigate(CompletedScreen), YourOriginalCodes)

Best regards,

Community site session details

Auto Increment - In my Canvas PowerApp with SPO List, how to auto Increment Question Number?

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Apps - Building Power Apps

Featured topics

Product updates

Community site session details

Auto Increment - In my Canvas PowerApp with SPO List, how to auto Increment Question Number?

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Apps - Building Power Apps

Featured topics

Product updates