Update multilanguage choice field to sharepoint list in original language

(0) Share

Report

Posted on by Anon3218

Hi community,

I have this multi-language app with a simple Yes/No choice. I was able to translate the choices using a collection.

In App.Onstart:

ClearCollect(
 colYesNo,
 {
 language: "en",
 text: "Yes",
 value: "Oui"
 },
 {
 language: "en",
 text: "No",
 value: "Non"
 },
 {
 language: "fr",
 text: "Oui",
 value: "Oui"
 },
 {
 language: "fr",
 text: "Non",
 value: "Non"
 }
);

I added a form component and have chosen the field I want to update. The field in sharepoint is a choice column with "Oui/Non" answer.

In PowerApps, I changed the dropdown list to a radio button control. I'm using the collection to show to the user the Yes/No option in their language.

Radio.OnChange:

UpdateContext({currentAnswer: Self.Selected.value})

Radio.Default:

LookUp(colYesNo,value=currentAnswer && language=varUserLanguage).text

Radio.Items:

Filter(colYesNo,language=varUserLanguage)

(Value: text)

In the Radio.Datacard.Update, I use:

Radio4_1.Selected

Now each time I submit the form, Sharepoint does not save the value of the radio button.

I tried to change the Radio.Datacard.Update to

Radio4_1.Selected.value

but i get an error "Expected record".

What did I miss?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
Hi @Anon3218 ,

On the Update try

{Value: Radio4_1.Selected.Value}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Anon3218

Change the value to Value in your table.

Choice columns expect a record with a Value column. Yours is a value column, which will not be the same and not work.

I hope this is helpful for you.

Was this reply helpful? Yes No
Anon3218 on at

Like (0)

Report
Not quite @RandyHayes.

The answer above by @WarrenBelz almost did the trick!
{Value: Radio4_1.Selected.value} (lowercase v)
Because in my collection, the value (lowercase v) is what populates my choice column in SharePoint

Thank you very much for pointing the correct syntax.

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

Like (0)

Report

@Anon3218

Yes, but if your value was Value, then the record would be correct for SharePoint!

When you update a Choice column, it only cares about the Value column of any record provided. So, as long as it exists, it works fine.

It's just extra work to put in the redundant record definition when your Radio control already has the record as needed! Works fine in every app I've ever made!

Was this reply helpful? Yes No
Anon3218 on at

Like (0)

Report

I just did the switch and it doesn't quite work. I get an error 'Expected record value' even when I renamed my table column to Value instead of value.
It only works when I do the Update with : {Value: Radio4_1.Selected.Value}

Was this reply helpful? Yes No