Answered

Filter columns by user input canvas form

(0) Share

Report

Posted on by knowlec

hi,

is it possible to have a number columns where the user puts in a number and based on the number, that how many next questions show up?

e.g

question is "how many workshops" and use puts in "4" for example.

then there are 4 sets of questions. first set is "Workshop 1 Objective", "Workshop 1 Date",

then "Workshop 2 Objective", "Workshop 2 Date" etc until workshop 4.

is this possible using canavs form via a SharePoint list?

thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Sickle-Cell 600 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @knowlec,

There are two ways that I can think you can handle this, depending on whether you have a defined upper limit of workshops. If four was the max, the easiest way would just be to set text label visible definition as false unless the number contained within the dropdown is =>1,=>2, etc.

If you don't, then you could instead have a series of text inputs (workshop name, objective, date) and a button. Underneath the button you can have a gallery, and on button click you can submit the workshop details into a gallery which you can then view the details in.

If either of these sound suitable and you need more information, let me know.

Was this reply helpful? Yes No
knowlec 16 on at

Like (0)

Report
Copy link

Link copied!

hi @Sickle-Cell
thanks for that.
the max amount of workshops would be 10.

so would I be able to limit the number in my "How many workshops" column so that it wont accept it if they user puts in a number >10?
so then all I do is create 10 sets of workshop questions and only make visible if workshop number =>1,=>2, etc ?

Was this reply helpful? Yes No
Verified answer

Sickle-Cell 600 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @knowlec,

Yes, that's entirely possible. If I were you, i'd maybe still use the gallery solution using a button as I believe it would be better from a visual perspective, but ultimately that depends on your layout. So you'd be looking to create 10 workshop input sections, and then you can have them only display based on the number selected.

If you need help with the specific code, let me know but it would be something like If(DropdownName.Selected.Value >= 1, true, false) and just incrementing the number for each new section

Was this reply helpful? Yes No
knowlec 16 on at

Like (0)

Report
Copy link

Link copied!

thanks @Sickle-Cell
how would the expression code work for the visible workshop data cards? i tried your example but it doesn't work.
this code does work:
"If( "2" in Dropdown1.Selected.Value, true, false)"
but that would mean i would need to put in a bunch of or expressions in each data card.

is there a more efficient code to get this done?

Was this reply helpful? Yes No
knowlec 16 on at

Like (0)

Report
Copy link

Link copied!

the issue was the valeus were coming in via text so they needed to be changed by entering in ClearCollect(
NumericChoices,
[
{TextValue: "1", NumericValue: 1},
{TextValue: "2", NumericValue: 2},
{TextValue: "3", NumericValue: 3},
{TextValue: "4", NumericValue: 4},
{TextValue: "5", NumericValue: 5},
{TextValue: "6", NumericValue: 6},
{TextValue: "7", NumericValue: 7},
{TextValue: "8", NumericValue: 8},
{TextValue: "9", NumericValue: 9},
{TextValue: "10", NumericValue: 10}
]
) onstart and referencing this in the visible code

Was this reply helpful? Yes No