Choice Field - SharePoint Form

(0) Share

Report

Posted on by PowerSuiteUser

Hello,

I have 2 SharePoint lists below with columns.

List A:

Name - Text Field

Country - Choice Field

City - Choice Field

List B:

Country - Text field

City - Text Field

On the SharePoint Form, I am doing a distinct and displaying Country and City values as cascading dropdown fields from List B.

Now, on submit I need to save the Country/City's selected items to List A's Country/City choice fields. Is this possible? If so, how? If not, what are the other options?

Thanks in advance.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerSuiteUser ,

It should be in {Value:"Text"} format if you want to update text to Choice column.

Here is a formula for your reference.

Patch(Datasource,Defaults(Datasource),{Title:"",ChoiceColumn:{Value:Dropdown.Selected.Value}})

Best regards,

Rimmon
PowerSuiteUser on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your quick response.

Should I put this formula in the OnSave event of the form or OnChange of the dropdown? Please provide more info if possible.
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerSuiteUser ,

The formula just an example. You should use {Value:"Text"} where you update the Choice column.

If you are using Form to update Choice column, you should put below formula on Update of Choice column data card.

{Value:DropDown.Selected.Value}

If you are using Patch function, it should be after Choice column field.

Best regards,

Rimmon