Unanswered

The column in the data source you are updating expects an option set value

(0) Share

Report

Posted on by Esox76

Hi i have a CDS table which i store options for a radio control as follows and i populate a collection with these values and filter them via the field name column when setting the items of each radio control as follows. Filter(colChoicesConfig, 'Field Name' in "Gender") . I'm having a issue when trying to store the selected values in another collection which is derived from another CDS table. The columns are choice columns and i get the following error The column in the data source you are updating expects an option set value and you are using type text. How do i convert the selected value or otherwise have the correct format in the first place

UpdateIf(
colApplication,
true,
{'Gender': Radio1.SelectedText.Choice}

)

Field Name Choice

Gender Male

Gender Female

Gender Other

Region UK

Region EU

Thanks in advance Esox76

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi@Esox76,
Based on the issue that you mentioned, do you want to update the Choice column based on the Radio selected?
Could you please share a bit more about the scenario:
how you create this collection "colChoicesConfig"?
why you don't update the Table directly?
To update the Choices column within Dataverse, you should follow a format like:

'OptionSetName (TableName)'.Option1

On your side, please try to modify your formula as below:

UpdateIf( colApplication, true, { Gender: 'Gender(TableName)'.Choice1 } )

Hope it could help.
If the above formula could not help you, please do tell me how you create the colChoicesConfig and colApplication?
Regards,
Qi
Esox76 87 on at

Like
a
(0)

Report
Copy link

Link copied!

The colChoicesConfig collection is created from a Dataverse table as below

Field Name Choice
Gender Male
Gender Female
Gender Other
Region UK
Region EU

I use this collection to provide options for a generic combo box control which works as expected. Because my canvas app stores it's information locally i use a collection to store the data and then patch Dataverse. Its when i try to store the data in the local collection that i get the issue of The column in the data source you are updating expects an option set value and you are using type text. I'm updating the local collection on the OnChange of the Combo. The local collection has been created for another table in dataverse which i then patch.

Hope this helps
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi@Esox76,
No, I mean a formula how you create your collection, post your formula for the collection!
Post the formula how you create the colChoicesConfig and colApplication
Do you have a Table containing 2 Choices columns named 'Gender' and 'Region'
How you set the Items property of the Combo Box?
I must that I could not guess all the details that could solve your problem, so please provide more key details.
Besides, the colChoicesConfig to populate the Combo Box is not a good choice, I think you could directly set the Items as the Choices column.

Choices(TestUpdateChoices.'Region')

Regards,
Qi
Esox76 87 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is how i create the collection from dataverse table as outlined above . I contains two fields Field Name and Choice

ClearCollect(
colChoicesConfig,
'Choice Configurations'
)

The problem is that Combo i am populating is a generic one displayed in a gallery so in row one of the gallery the combo is Gender in row two the combo is region so I have logic to populate the combo based on the the row in the gallery .

How i populate the combo

Switch(
ThisItem.'Associated Field ',
"Gender",
Filter(colChoicesConfig, 'Field Name' in "Gender"),
"Region",
Filter(colChoicesConfig, 'Field Name' in "Region"),
)
Hop this helps. I can't use your solution above since the generic single select combo does not like multiple data sources.

Thanks Esox