Unanswered

Update Choice Field in Form Based Upon Multi-select Field in Same Form

(0) Share

Report

Posted on by zachary_stern21

I have a form that contains a Multi-select Choice field called "Harris County Precinct". There are four precincts the user can choose and can select multiple precincts. For reasons, I need to be able to take to populate another field "Primary Precinct" with the first Precinct selected in the "Harris County Precinct" field.

I've tried the following code on the OnSuccess property of the form:

Patch('HCFCD Projects', Self.LastSubmit, {'Primary Precinct': Index(Choices([@'HCFCD Projects'].'Harris County Precinct'),1)})

However, the "Primary Precinct" field keeps defaulting to Precinct 1.

Any help would be much appreciated.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

EddieE 4,641 Moderator on at

Like (1)

Report
Copy link

Link copied!
@zachary_stern21

Try using

First( yourComboBoxName.SelectedItems).Value

If 'Value' doesn't work, remove it and re-add the '.' and let Intellisense guide you as to what you can select.

Was this reply helpful? Yes No
zachary_stern21 12 on at

Like (0)

Report
Copy link

Link copied!

I'm not using a Combobox on this screen. This is just a form and I want one field to be equal to another field, except in the case where one field has multiple choice selections, I just want the second field to be equal to the first selection of the first field

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@zachary_stern21

If you are not using a ComboBox then what type of field is holding your multiple choices? What data type is this field - eg type Text - and if so, how is it separated into choices? I'm a little confused.

Was this reply helpful? Yes No
zachary_stern21 12 on at

Like (0)

Report
Copy link

Link copied!

It is a field in a Form (HC Primary Precinct). It is a Choice Field that allows for multi-select options

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@zachary_stern21

That looks a lot like a ComboBox to me, try the code I posted above to check.

Also, if you just added an Edit Form to a screen from say, a SharePoint list with a Choice field, PowerApps automatically adds a ComboBox for you into the form.

Was this reply helpful? Yes No