Answered

Using Table Collection Value to set checkbox

(0) Share

Report

Posted on by ctedesco3307

574

Not sure if this is possible but ideally what I would like to do is set the checkbox to be true or false based on if a value is in a collection.

I have a collection that gets data from a SharePoint list. the field in SharePoint is a choice field that can have multiple values. Ideally I'd like the input form to be laid out like this,

and if a corresponding value is in the field set the checkbox to true. prob is the field is a table in the collection b/c and I can't drill down to a single value. Seeing if there is a way to do it. Thx in advance

collection

Categories:

Using Apps Using Formulas

All responses (4)

Answers (1)

ctedesco3307 574 on at

Like (0)

Report

Re: Using Table Collection Value to set checkbox
WarrenBelz 145,434 on at

Like (0)

Report

Re: Using Table Collection Value to set checkbox

@ctedesco3307 ,

You do not need the if/true/false - what I posted will work.
Verified answer

ctedesco3307 574 on at

Like (0)

Report

Re: Using Table Collection Value to set checkbox

@WarrenBelz worked - Thank you!

If("Personality" in galdcp.Selected.Focus_x0020_Areas, false, true)
WarrenBelz 145,434 on at

Like (0)

Report
Re: Using Table Collection Value to set checkbox

Hi @ctedesco3307 ,

Try this on the Default of the checkbox

"Personality" in coldcp.Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps