web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Submit Choice to Datav...

Power Apps

Suggested Answer

Submit Choice to Dataverse

(0) Share

Report

Report

Posted on by Caleb62881177

789

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
Caleb62881177 789 on at

Like
a
(0)

Report
Copy link

Link copied!

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)'

)

Was this reply helpful? Yes No

Join the conversation