Answered

Problem with save data from combobox

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I have a question because I'm setting a value in combobox based on datacardvalue19.text. And I do this by writing to the combobox defalutselecteditems property of this function:

If(StartsWith(DataCardValue19.Text,"V") || DataCardValue19.Text = "NA" || DataCardValue19.Text = "NF",{Value: "Ves"},IsMatch(DataCardValue19.Text, "Sub", Contains) || IsMatch(DataCardValue19.Text, "sub", Contains) || IsMatch(DataCardValue19.Text, "SUB", Contains),{Value: "Submi"}, StartsWith(DataCardValue19.Text,"IM") || DataCardValue19.Text = "M",{Value: "Mag"},DataCardValue19.Text<>Blank(), {Value: "Sem" })

value changes to combox but does not write to the dataverse, when i click on SubmitForm.

Please help @RandyHayes

Categories:

Building Power Apps

I have the same question (0)

All responses (21)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

What kind of column is the underlying column in your datasource?

Also, what is the Update property of the datacard for that field?

And, what is the Items property of your combobox?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Column data type is choice, Update in combobox: DataCardValue5.Selected.Value
and Items in combobox is: Choices(CFT)

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Change your Update property to: DataCardValue5.Selected

You are currently pushing a Value (simple text) to the underlying choice column. Choice columns are records that are made of a record with a single column called Value. Since you are using Choices in the Items property, it will already have records for each choice. So, specifying the .Selected in the Update will provide the underlying choice column with the record it needs.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I get error: expected optionsetvalue value.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

What is your datasource?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

datasource for app is table in dataverse

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

So for Dataverse, you are going to need to supply the option set to the Items property of the combobox and your DefaultSelectedItems is going to also need to supply a valid optionset. Right now, your Choices and Value records are like SharePoint choices - those are different in Dataverse.

What is CFT in your Choices function?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

CFT is a column in dataverse with choice data type, and i have inside values from function which i type in post.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

What is the name of the datasource (dataverse table/entity)?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Shortages

Was this reply helpful? Yes No