Concurrent User of Gallery

(0) Share

Report

Posted on by CHQLDHealth

HI,

Looking for assistance with A Power APP used as an Audit tool.

I have an App with multiple SharePoint Data sources, 1 is Questions and the Other is Answers. In the App I have a Gallery of Questions from List 1 "Questions" and for each question selected a response page appears where the user can submit an answer to List 2 "Answers". once a question has been answered for that User, I would like to shade the Gallery Item Question Green indicating the question has been answered, but I need this not to affect other users who may be accessing the App at different times of progress through the questions, i.e. they need their own session. All answers will be individual of course based on dropdowns for site, location, etc. How can I apply a reset Questionnaire button that resets the questionnaire for that user once they have finished and remove the green shading from the completed questions. i have not yet explored using a collection at this stage. Any suggestions and code would be greatly appreciated. Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report
Hey, you have Several way show you could do it.

You will probably have the name of the user somewhere in the 2. list so you can track the answer back to a user.

Maybe you could also add some sort of staging to the second list. I mean by that a Column called status.

When the user starts answering the questions just add in this coluln the value "Started" or "In progress" and when he finished and moves away from the screen patch it to "Finished"

Then in the questions you could check if in list 2 there is an answer to this question that belongs to the current user and where the status is started then green else Black:
If( IsBlank( LookUp( Filter( List2, User=User().Email ), Status="Started" ).QuestionColumn ), Color.Black, Color.Green )

If this answer solved your problem, please marke it as solution, so others can find it as well.
If it helped you in any other way Consider liking it, so we can keep supporting each other.

Was this reply helpful? Yes No
Verified answer

Nandit 1,568 Moderator on at

Like (1)

Report
Hi CHQLDHealth,

For resetting the questionnaire, you can include a Reset button at the bottom of the screen with the following code:

Set(varReset, true)

OnVisible property of the screen:

Set(varReset, false)

Fill property of your Questions Gallery item would be:

If(varReset, Color.White, IsBlank( LookUp( Filter( Answers, User=User().Email && QuestionID = ThisItem.ID ).Answer ), Color.White, Color.Green ))

For this to work, you will need a QuestionID column in the Answers list and a column to capture user's email address.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No