Unanswered

Collecting Yes/No Data from Gallery

(0) Share

Report

Posted on by CU19111310-1

Hi all,

Apologies as I am fairly new to PowerApps and may either be missing something really easy or asking PowerApps to do something that isn't possible. I am building a app which collects compliance of a few categories of questions which are organised into cards. I have a field called 'CardCollection' which I generate OnStart of the app which has the card title and the list of yes/no questions I want answered.

I use a gallery to display the card titles and then have it set up so on selecting this gallery the questions related to this card appear in another gallery, as shown. I have added a toggle to the top line of the gallery, which I am hoping to be able to collect into a SharePoint list as one row per card. I just want the yes/no status of any toggles in the gallery - but the number of questions on each card and questions changes, I don't know how I can do this.

Can I have it so I have a maximum of say 5 yes/no columns in the SharePoint and then 'spare' boxes are kept null or as a default? Is it possible to collect toggle data like this one row per entry? I have attached a snip of the layout of my app.

Thanks so much in advance.

Categories:

Building Power Apps

Screenshot 2024-1...

I have the same question (0)

All responses (3)

Answers (0)

ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (0)

Report

Why are you using a collection? This creates inflexibilities into your app.

You can create the gallery from the SharePoint list.

Provide some more details of the data structure showing the relationship of the questions to the cards.

Even if you use a collection don't you know how many questions there are so that you would only create the required number of records?

Was this reply helpful? Yes No
Mark Nanneman 991 Super User 2025 Season 2 on at

Like (0)

Report

A smarter way to do this might be to setup a relational database (that is, separate tables with lookups to link).

Something like:

A SharePoint list for "CardType"
A SharePoint list for "Locations" (Lookup field to CardType)
A SharePoint list for "Tasks" (Lookup field to CardType and/or Location)

In your app you just use the selected Card Type or Location to display which tasks need to be be addressed.

Was this reply helpful? Yes No
CU19111310-1 2 on at

Like (0)

Report

Hi both, thanks for your replies. I will try using a SharePoint list and see how I get on.

@ronaldwalcott Yes I will know the number of questions for each card, but some cards will only have 2 questions while others will have around 5.

@Mark Nanneman I will try using lookup columns. How would I store the result of each question? Would I have to have a specific 'task' box to allow the gallery to pull in the task, and then a less specific 'Task 1 Yes/No' field for writing of data when people submit their answers, irrespective of the task?

Was this reply helpful? Yes No