I am trying to get (1 or more) selected check box value to fill a box in a form.
"If selected, then fill the value here" type deal. (see image) But I have no idea how to formulate that. Is it even possible?
Solved! Go to Solution.
Use Concatenate...similar to this:
Concatenate(
If(Checkbox1.Value=true, "Option 1, "),
If(Checkbox2.Value=true,"Option 2, "),
If(Checkbox3.Value=true,"Option 3")
)
Make sure if using check boxes that wherever you want to reset those (probably the screens OnVisible) that you put =UpdateContext({ResetCk:!ResetCk}) and then on each of your check boxes you make the Reset be =ResetCk
A lot of people think that just making the Reset be true will reset them but it doesn't work like that.
May not get you 100% there but you could do the following. This will add a comma after each item though.
If(Checkbox1.Value=true,
Checkbox1.Text & ", ")
&
If(Checkbox1_1.Value=true,
Checkbox1_1.Text & ", ")
&
If(Checkbox1_2.Value=true,
Checkbox1_2.Text & ", ")
Use Concatenate...similar to this:
Concatenate(
If(Checkbox1.Value=true, "Option 1, "),
If(Checkbox2.Value=true,"Option 2, "),
If(Checkbox3.Value=true,"Option 3")
)
Make sure if using check boxes that wherever you want to reset those (probably the screens OnVisible) that you put =UpdateContext({ResetCk:!ResetCk}) and then on each of your check boxes you make the Reset be =ResetCk
A lot of people think that just making the Reset be true will reset them but it doesn't work like that.
I did have to change my Sharepoint column to Multi line instead of choices but then it worked like a charm. Thanks!
User | Count |
---|---|
227 | |
98 | |
95 | |
56 | |
33 |
User | Count |
---|---|
279 | |
108 | |
107 | |
64 | |
62 |