Unanswered

Autopopulate a field based on a checkbox selection

(0) Share

Report

Posted on by Timm1

301

Hello! I’m fairly new to PowerApps. I’m building a Sharepoint form from a list. I was able to convert a combobox to checkboxes and was able to keep multiple checkbox entries by using a Gallery. Works great. The checked items come from a column named Servers in a Sharepoint list which has another column called Programs. How do I create a field that will autofill the Programs that are associated to what was picked in the Checkboxes.

Below is the code I used for the Checkbox Gallery.

Gallery1 Checkbox-

Oncheck- Collect(colCheckedArea, {Title:ThisItem.Value})

OnUncheck- RemoveIf(colCheckedArea, Title=ThisItem.Value)

In the combobox item named DDServer – DefaultSelectedItems - RenameColumns(colCheckedArea, "Title", "Value")

Attached is the idea of what I need.

Any suggestions will be awesome and please let me know if you need more info.

Thank you very much!

Tim

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Timm1 ,

Do you want to fill the Programs Combo box with programs corresponding to those selected servers?

If so, you will only need to use a Filter to get corresponding programs of selected servers:
Distinct(Filter(SPlist, Servers in colCheckedArea.Value), Programs).Result
Distinct function is for distinguishing filtered program values if there would be. This formula should be put in the DefaultSelectedItems.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Timm1 301 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much. I'm not getting the results but will play around with it and will let you know if I get it to work.

Was this reply helpful? Yes No
Timm1 301 on at

Like (0)

Report
Copy link

Link copied!

Hi there. With me not understanding code, I might not be inputting the correct code. I have a combo box with the code, Distinct(Filter('Server Names',Servers in colCheckedArea.value), Programs).Result in the DefaultSelectedItems. I have tried different combinations but nothing works. sorry - I'm confused on how this all works. But I'm learning.. 🙂
Thank you

Was this reply helpful? Yes No