Unanswered

Update ComboBox and clean record on RadioButton exchange

(0) Share

Report

Posted on by Deivid

188

I have a RadioButton (Risk Type) and a ComboBox (Risk). For each item of the RadioButton selected, a different content is brought into the ComboBox, always aligned with what was selected. For example, if the RadioButton selected is Physical Risk, the ComboBox will show several items searching in the Physical Risk column.

Content in Dataverse. All are Choices

Tipo Risco Card

RadioTipoRisco

CardRisco

ChoiceRisco

How can I clear the ComboBox when changing the item on the RadioButton?
How to save the ComboBox item since in Update it says that it waits for an OptionSetValue?

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

WiZey 3,023 Moderator on at

Like (1)

Report

Hello @Deivid ,

1. You can clear the ComboBox with "Reset()" in the "OnSelect" of your Radiobutton.

2. Could you explain a bit more on this point? Are you using "Update()" to update the record? Why not use "SubmitForm()" since you're using a Form?

Was this reply helpful? Yes No
Deivid 188 on at

Like (0)

Report
Hi @WiZey,

It worked, thank you.
The Update is to update the Risk card, where the ComboBox is. The SubmitForm I'm using for the form.

Update

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report

I'm not certain of the cause, so let's try different solutions.

1. Try « ComboBox.Selected.Value » or « ComboBox.Selected.Result » in your "Update"

2. Try « {Value: ComboBox.Selected.Value} » in your "Update"

Be sure to reference your ComboBox in "Update", I'm not certain if referencing the DataCard is enough for PowerApps to retreive the selected item.

Was this reply helpful? Yes No
Deivid 188 on at

Like (0)

Report
Hi @WiZey,

I'm still not able to save in the ComboBox. Here are the tests on Update:

DataCardValue156.Selected.Result
The name is not valid. The 'Result' is not recognized.
DataCardValue156.Selected.Value
The name is not valid. The 'Value' is not recognized.
{Value: DataCardValue156.Selected.Value}
Expected OptionSetValue value.
Invalid use of '.'.
Value: DataCardValue156.Selected.Value
The name is not valid. The 'Value' is not recognized.

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report

If neither "Value" or "Result" are recognized, then could you check what is the name of the column in the "Selected" that stores the value?

Was this reply helpful? Yes No
Deivid 188 on at

Like (0)

Report

Following are Dataverse columns that may be in the ComboBox:

Table

As the content that will be in the ComboBox can come from 5 different columns of the Dataverse (as the user selects in the RadioButton), I did the following test:

Update

The error appears in the colon (:), the error says:

Unexpected characters. The formula contains 'Colon', where 'ParenClose' is expected. Unexpected characters. Characters are used in the formula unexpectedly.

Hope I answered what I needed to check.

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (1)

Report

The formula is wrong, you can't fill in "Update" based on a "If()".

When you tried to give it "Selected.Value" and it told you that "Value is not recognized", it meant the "Selected"'s column was neither named "Value" or "Result" but something else.

Could you check what is the column's name inside your "Selected" please?

Was this reply helpful? Yes No
Deivid 188 on at

Like (0)

Report

Good to know about If() in Update, thanks.

I hope the image below answers what you need, if not, how can I get that answer?

Expected OptionSetValue value

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report

Close!

What I want to check is what are the columns of "Selected".

For example, my ComboBox has "Selected" property, and "Selected" has "Value" column.

In your app, it didn't recognize "Value" and "Result", so I wanted to check what is the name of the column "Selected" returns.

Was this reply helpful? Yes No
Deivid 188 on at

Like (0)

Report

Understood.

Note: I changed the ComboBox name from DataCardValue156 to cb_risco to make it easier.

Columns of cb_risco

Unexpected characters. The formula contains 'Eof', where 'Ident' is expected. The name is not valid. '_' is not recognized.

Was this reply helpful? Yes No