web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Updating SP List Choic...
Power Automate
Suggested Answer

Updating SP List Choice (Multiple Choices Allowed) Column

(0) ShareShare
ReportReport
Posted on by 5,331 Moderator
I am having trouble with the Update action in my flow.

I am using the default SP list form to collect data. One of the 'required' fields is the Expense Account.

The Expense Account field is a Choice column that allows multiple choices.

My flow is an approval flow with multiple iterations (more the $2500, less than $2500, etc.) in two Scopes.

I am having problems getting consistent behavior out of the Update actions output.

In the image you can see the top and bottom lines of the Expense Account column both have two accounts chosen. 
however, they both present differently. 

How do I get the output to look like line one.

I can't figure out why one Update action provides the output shown in item one (preferred), and another Update action
like line four.

I have a Compose action.
 
I have an Update Action - Expense Account (field).




SP list Expense Account column



The trigger is SP list 'When and item is created'.

Compose -
coalesce(triggerBody()?['Expense_Account'],createArray())


Update Action
outputs('Compose_-_UpdateExpenseAccount')
Categories:
I have the same question (0)
  • Suggested answer
    stanleyyddcc Profile Picture
    4 on at
     

    Power Automate flow

    SharePoint List A

    SharePoint List B

     

    1. Trigger as you need, in my case I put instant trigger for testing

    2. Retrieve the items from SharePoint list A

    3. Use Select to map out the output. From the Choice column and map with the Choice Value.

    4. Create the item in SharePoint list B with the Select Output

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard