Answered

Get data from multiple checkboxes

(0) Share

Report

Posted on by atn2019

I have 5 checkboxes with custom data and a text input. I am looking for a way the text input will display whichever day that is selected on the checkbox. For example, when a user clicks on Tues checkbox, it will display Tues on the text input, and if Wed is checked, then it will add tuesday on top of wed like Tues & Wed. Likewise, when the checkbox is unselected, the text also needs to be gone from the text input.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@atn2019 - if we assume that the name of each Checkbox is CheckboxMonday, CheckboxTuesday etc, apply the below to the Default property of your Text Input Control:

Concat( Filter( Table( { SelectedDay: If( CheckboxMonday, "Monday" ) }, { SelectedDay: If( CheckboxTuesday, "Tuesday" ) }, { SelectedDay: If( CheckboxWednesday, "Wednesday" ) }, { SelectedDay: If( CheckboxThursday, "Thursday" ) }, { SelectedDay: If( CheckboxFriday, "Friday" ) } ), SelectedDay <> Blank() ), SelectedDay, " & " )

Was this reply helpful? Yes No
atn2019 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the formulas. They work. What if the input text already contains data (e.g., Tuesday & Wednesday), and I want the text input to display the parent.default data? In other words, when the text input has data from SharePoint, it will display that data. However, when a user clicks on either of the checkboxes, the original data will need to disappear, and the checkbox data will be displayed.

I tried the following formulas, but is not working

If(Checkbox.Value=false || Checkbox2.Value=false || Checkbox3.Value=false || Checkbox4.Value=false || Checkbox5.Value=false,Parent.Default,Concat(Filter(Table({SelectedDay:If(Checkbox,"Mon")},{SelectedDay:If(Checkbox2,"Tue")},{SelectedDay:If(Checkbox3,"Wed")},{SelectedDay:If(Checkbox4,"Thur")},{SelectedDay:If(Checkbox5,"Fri")}),SelectedDay<>Blank()),SelectedDay," & "))

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@atn2019 - applying this functionality to a Form is a very different question and will require a number of steps. When I have a moment I will put together a blog post explaining what you need to do.

Also, please remember to accept the solution to the original question.

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @atn2019 - blog post below:

https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Populate-a-Text-Input-Box-with-selected-Checkbox-items-and-then/ba-p/2408432#M1796

Was this reply helpful? Yes No