Unanswered

Setting a required field when clicking on checkbox item (from multi choice data)

(0) Share

Report

Posted on by AndyB1308

Hi,

I'm trying to set a Text field on my form control as NOT required if a specific item is clicked in a checkbox which is a control for a multi choice column in a sharepoint list.

I would like the field PT/OTM Number to become NOT required if the 'New Train' box is clicked - currently I've had to set the whole field as NOT required at all.

Any help on this would be appriciated

Andy

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Cat Schneider 488 Most Valuable Professional on at

Like (0)

Report
It sort of depends on how you have the Change Type control set up... Is it all a bunch of individual checkboxes? Is it a gallery with a table of values for the items property, and there's a checkbox to display the text of ThisItem.Value?

How does the 'New Train' checkbox come to exist? You should be able to use:
Checkbox.Value <> true
in the required property for the field you want to update.

Let me know if it's a gallery with a checkbox in it, and I can help you get the value to use instead; or if you have this set up some entirely different way.

Was this reply helpful? Yes No
AndyB1308 12 on at

Like (0)

Report

Hi, it’s setup as a gallery with a table not individual checkboxes. The source is a multi choice column in a sharepoint list.

Was this reply helpful? Yes No
Cat Schneider 488 Most Valuable Professional on at

Like (0)

Report
Use the following in the Required Property of your field to set the value based on the Checkbox being selected:
First( Filter( //Replace GalleryName (below) with the name of your gallery control GalleryName.AllItems, //Replace Fieldname (below) with the name of the Field being used to populate the text of the checkbox Fieldname = "New Train" ) //Replace Checkboxname (below) with the name of the Checkbox control being used in your gallery ).Checkboxname.Value <> true

This should work to get the value of the specific checkbox you want to access.

Was this reply helpful? Yes No
AndyB1308 12 on at

Like (0)

Report

Thanks,

This is what I have, but it's showing an error as the data types aren't the same? Sorry I'm still learning.

First(
Filter(
//
Gallery1.AllItems,
//
ChangeType_DataCard3 = "New Train"
)
//
).Checkbox1.Value <> true

Was this reply helpful? Yes No
Verified answer

Cat Schneider 488 Most Valuable Professional on at

Like (1)

Report
So, you are getting an error because you are trying to call the DataCard as a Fieldname for the Gallery Items. You need to use the name of the field that contains the values "New Train", "Add Loco", "PAP/PDP", etc.

Easiest was to figure out what that field name is would be to select Checkbox1, and check the "Text" Property value. It most likely says something like:
ThisItem.Value
If so, replace ChangeType_DataCard3 in what you have above with the whole bit that comes after:
ThisItem.
Meaning if the Text property of Checkbox1 is indeed
ThisItem.Value
then you should have the use the following for the Required Property:
First( Filter( Gallery1.AllItems, Value = "New Train" ) ).Checkbox1.Value <> true

If it is not 'Value', and you are still having some trouble, would you post a screenshot showing what you have entered in for the Items property of Gallery1?

Was this reply helpful? Yes No
AndyB1308 12 on at

Like (0)

Report

Hi?

That worked great. Thanks for your help 👍🏻

Was this reply helpful? Yes No