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 / Email Output from Shar...
Power Automate
Answered

Email Output from SharePoint from choice column

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I am trying to do somthing simular to this post I had previously with a a toggle, but now I have a drop down of three options of Yes, No, and Not Applicable using the following code of many variations but I keep getting an error.

 <td style="width: 228px;">@{if(equals(triggerBody()?['OData__x0044_S1']?['Value'],'Yes','No'),'Yes','No','Maybe'
)}</td>

I think once I get this working I can apply the inline style like I did before. 

 

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I managed to get this working if I don't have spaces or special charaters like this.

    @{if(equals(triggerBody()?['OData__x0050_AC6']?['Value'],'ABC'),'Yes','No')}

     

    If I do it like this it will not work

    @{if(equals(triggerBody()?['OData__x0050_AC6']?['Value'],'ABC - 123'),'Yes','No')}

     

    I tried encoding it, but that did not work either.

    @{if(equals(triggerBody()?['OData__x0050_AC6']?['Value'],'ABC%20-%20123'),'Yes','No')}

     

    If we get this working will I have the same issues if I put a space or special character for the output?

  • Verified answer
    v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

     

    It seems that when there is a space or special character for the output, the code you are using will return an error.

     

    I have made a simple test with the following code, though there is a space for the output, it still works fine. The code is:

    if(equals(triggerBody()?['Choice']?['Value'],'Yes'),'Yes',if(equals(triggerBody()?['Choice']?['Value'],'Not Applicable'),'Maybe','No'))

    1.PNG2.PNG

     

    Please take it for a reference and try again with it.

     

    Best regards,

    Mabel Mao

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I see what you did there nice! I had to do the following to get this to work in an email for anyone else that reads post.

     

    @{if(equals(triggerBody()?['OData__x0044_S3']?['Value'],'Yes'),'Yes',if(equals(triggerBody()?['OData__x0044_S3']?['Value'],'No'),'No',if(equals(triggerBody()?['OData__x0044_S3']?['Value'],'Not Applicable'),'Not Applicable','Not Applicable')))}

     

     

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
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard