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?

All responses (5)

Answers (2)

Anon3218 on at

Like (0)

Report

Re: Update multilanguage choice field to sharepoint list in original language

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}
RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report

Re: Update multilanguage choice field to sharepoint list in original language

@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!
Anon3218 on at

Like (0)

Report
Re: Update multilanguage choice field to sharepoint list in original language

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.
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (1)

Report

Re: Update multilanguage choice field to sharepoint list in original language

@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.
Verified answer

WarrenBelz 146,679 Most Valuable Professional on at

Like (1)

Report
Re: Update multilanguage choice field to sharepoint list in original language

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