Power Platform Community Forum Thread Details

Hi I am working on creating a checklist app where I need suggestions with best approach to follow,

App Context - the app has 2 roles Approver and Reviewer. First a set of questions would be assigned to Approver where he'll fill his responses and then it'll be moved to Reviewer where Reviewer can see Approvers response and add remarks and then answer his questions.

Problem : Question are nested, so suppose Question A has responses as Yes and No, if No is selected a follow-up questions would be made visible. I am trying to use a nested gallery for it but the problem is what if the nested question also has a follow-up question?

Please help me how should I proceed in designing the application? Is there a way to achieve this dynamically just by using one or two galleries?

Categories:

General Questions

Hi SH3R,

Thank you for choosing Microsoft Community.

Creating a dynamic checklist app with nested questions can be a bit tricky, but it's definitely doable.

Here's a suggested approach to design your application using Power Apps:

Data Structure:

Create a data source (e.g., SharePoint list, SQL database) to store your questions and responses. Each question should have a unique ID, a parent question ID (to handle nesting), the question text, and the type of response (e.g., Yes/No, text input).

Main Gallery:

Use a main gallery to display the primary set of questions. This gallery will show the questions assigned to the Approver.

Nested Gallery:

Inside the main gallery, add a nested gallery to display follow-up questions. The nested gallery should be filtered based on the selected response of the parent question.

Dynamic Visibility:

Use conditional visibility to show or hide follow-up questions based on the responses. For example, if a question's response is "No," set the visibility of the follow-up question to true.

Handling Multiple Levels of Nesting:

For deeper levels of nesting, you can use additional nested galleries within the nested gallery. Each level of nesting will have its own gallery, filtered based on the parent question's response.

Formulas and Logic:

Use formulas to manage the visibility and data flow between the galleries. For example, you can use the Visible property of the nested gallery to check the response of the parent question.

Here's a simplified example of how you might set up the galleries:

MainGallery.Items = Filter(Questions, IsBlank(ParentQuestionID))
NestedGallery.Items = Filter(Questions, ParentQuestionID = ThisItem.QuestionID && ParentResponse = "No")

User Roles:

Implement role-based access to ensure that Approvers and Reviewers can only see and interact with the questions assigned to them. You can use the User() function to determine the current user's role and adjust the visibility and editability of the questions accordingly.

By using this approach, you can create a dynamic and flexible checklist app that handles nested questions effectively. If you need more detailed steps or run into any issues, feel free to ask!

If this Post helped you, please click "Does this answer your question" and like this post to help others in the community find the answer too!

Happy to help

Robu 1