cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AGaudioASG
Helper II
Helper II

filling form box with check box value

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?

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
rebeccas
Community Champion
Community Champion

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. 

View solution in original post

3 REPLIES 3
kriggo15
Post Patron
Post Patron

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 & ", ")

rebeccas
Community Champion
Community Champion

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. 

View solution in original post

I did have to change my Sharepoint column to Multi line instead of choices but then it worked like  a charm. Thanks!

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,060)