web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Creating a dynamic tab...

Power Apps

Answered

Creating a dynamic table/view/grid

(0) Share

Report

Report

Posted on by nikviz

242

I have around 50 categories and Each category has anywhere between 1 to 15 questions and user is asked to answer these questions and answers could be free text/options/dates.

Is there something like value set where i can create this structure or do I need to create all questions as a table column (this would mean I may have to create roughly 50 categories * questions per category) (This link shows https://powerusers.microsoft.com/t5/Building-Power-Apps/Building-a-Survey-where-the-responses-have-a-yes-or-no-selection/td-p/1604049 how to do this, but this would mean creating 500 columns in my case)

Once I create this structure, I want the questions to dynamically appear in a Form, based on the category user has picked up as shown below, is this possible?

Any help/link would be helpful.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
hi @nikviz

Here is an idea but I would not use a form control but rather a gallery.

consider the following:

The questions can be a static excel table you import or a collection, i will use a collection to illustrate a solution.

//type 0 = choice, 1 = textinput ClearCollect(colQuestions, {category: "Cat A", question: "Age above 18?", options: "Yes/No", type: 0}, {category: "Cat A", question: "UK citizen?", options: "Yes/No", type: 0}, {category: "Cat B", question: "Age above 18?", options: "Yes/No", type: 0}, {category: "Cat B", question: "Length of residency?", options: "", type: 1}, {category: "Cat B", question: "Employment Duration?", options: "0-2 yrs/2-5 yrs/5+ yrs", type: 0} )

Now add a Combobox to allow the user to select the category

Items = Distinct(colQuestions, category).Result

Add three labels

label 1, Text = "Username: " & User().FullName

label 2, Text = "Category: " & yourComboBox.Selected.Result

label 3, Text = "Questions: "

Add a gallery

In the gallery add

Items = Filter(colQuestions, category = yourComboBox.Selected.Result)

label, Text = ThisItem.question

set label and textinput X position the same

ComboBox,

Items = Split(ThisItem.options, "/").Result

Visible = ThisItem.type = 0

Texinput, Visible = ThisItem.type = 1

Result

Hope it helps

R

Was this reply helpful? Yes No
nikviz 242 on at

Like
a
(1)

Report
Copy link

Link copied!

@rubin_boer
Thank you. Yes, this helps.

Was this reply helpful? Yes No

Join the conversation