Power Apps - Building Power Apps

Submit Choice to Dataverse

(0) Share

Report

Posted on by Caleb62881177

745

Hello everyone,

I am trying to submit this DataCardvalue to a Dataverse choice column.

I am using this formula on the ComboBox:

Switch(
DataCardValue30.Selected.Name,
"Value1", ["Choice1", "Choice2", "Choice3", "Choice3", "Choice4"],
"Value2", ["Choice1", "Choice2", "Choice3"],
[]
)

I'm open to any other solutions or ideas anyone may have.

Categories:

Using Apps Using Formulas

All responses (2)

Answers (0)

Caleb62881177 745 on at

Like (0)

Report

Submit Choice to Dataverse

Hi Nandit, I am getting any error of "Table doesn't contain any column of text type" using this formula.

Switch(

DataCardValue.Selected.Name,

"Value1",

Filter(

Choices('Description (Table)'),

Text(Value) <> "Choice1" && Text(Value) <> "Choice2"

),

"Value2",

Filter(

Choices('Description (Table)'),

Text(Value) <> "Choice3" && Text(Value) <> "Choice4"

),

Choices('Description (Table)'

)
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report
Submit Choice to Dataverse

Hi Caleb62881177,

I am assuming what you have mentioned in your description is the Items property of the Combobox.

Looks like you are trying to display different items in the Combobox based on DataCardValue30.Selected.Name.

If you wish to get the Choices from the choice column in Dataverse, you can do something like this:

Switch( DataCardValue30.Selected.Name, "Value1", Choices([@DataSource].choice), "Value2", Filter( Choices([@DataSource].choice), Text(Value) <> "Choice 4" ), [] )

Use the following if you are using Classic Combobox:

Choices(DataSource[@choice])

To Patch the column, you can use the following:

Patch( DataSource, Defaults(DataSource), {choice: ComboBox.SelectedItems} )

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!