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 / Switch template action...
Power Automate
Answered

Switch template action error - Sharepoint choice column

(0) ShareShare
ReportReport
Posted on by 14

I have a pretty simple flow that creates an Exchange meeting invite and an approval request based on the creation of a new item in an SPO list.

 

Here's the trigger configuration and a sample output:

AbleAmazing_5-1663879766315.png

 

AbleAmazing_1-1663879473230.png

 

Here's the relevant choice column output from the trigger:

AbleAmazing_2-1663879486287.png

 

Here's the switch configuration:

AbleAmazing_6-1663879896037.png

Here's the error:

AbleAmazing_4-1663879613580.png

 

What I don't understand is that I've created flows exactly like this in the past. I have always been able to supply output from SPO choice columns as the input to both Switches and Conditions and they'd correctly extract the text string value from the JSON. But in this case, it appears to be throwing the entire JSON as the output and then failing.

 

Categories:
I have the same question (0)
  • Verified answer
    v-yujincui-msft Profile Picture
    Microsoft Employee on at

    Hi @AbleAmazing ,

     

    Please try to use Dynamic content with Value, it should be LOB App Value in your Flow.

    vyujincuimsft_0-1663911961367.png

    vyujincuimsft_1-1663911972016.png

     

     

    Best Regards,

    Charlie Choi

  • AbleAmazing Profile Picture
    14 on at

    Thanks. That was the problem. I overlooked the dynamic content that I selected.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard