Data type Yes/No in SharePoint - change the values to Pass or Fail instead True / False in Email

(1) Share

Report

Posted on by TomasKCSL

Hi,

No matter how much I try any options it still not working for me, so I decided to ask you for help.

I create a simple power app using SharePoint list with column Type Yes/No, and using power Automate to send emails with the information that was sent by the power app.

So, my problem is when I use Automate flow 'Send an email' information back as True / False but I wanted to change that information back with Pass / Fail.

Already try use:

if(equals(triggerBody()?['InternalColumnName'],True),'Pass','Fail')

But then information always back with Fail only

App:

Flow:

Back to email Fail but it had to back Pass

Can someone help me, I'm completely new to this, but I'm try learning. Thanks

Regards

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @TomasKCSL

This could be the data type issue from the trigger. Try the following:

if(equals(bool(triggerBody()?['InternalColumnName']),true),'Pass','Fail')

Thanks

Was this reply helpful? Yes No
TomasKCSL 8 on at

Like (1)

Report

First of all, I would like to thank you for the quick reply.

Unfortunately, now I get error after using
if(equals(bool(triggerBody()?['InternalColumnName']),true),'Pass','Fail')

Error Detail:
Unable to process template language expressions in action 'Send_an_email_(V2)' inputs at line '0' and column '0': 'The template language function 'bool' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @TomasKCSL

Check the run history and find out the value of triggerBody()?['InternalColumnName']

if its string then try

if(equals(triggerBody()?['InternalColumnName'],'true'),'Pass','Fail')

or

if(equals(triggerBody()?['InternalColumnName'],'True'),'Pass','Fail')

Thanks

Was this reply helpful? Yes No
TomasKCSL 8 on at

Like (0)

Report

Hi,

No matter what I did, it always backs Fail

Already try
if(equals(triggerBody()?['OData__x0051_1'],'true'),'Pass','Fail')
if(equals(triggerBody()?['Q1'],'true'),'Pass','Fail')

but it always back as Fail even if in app I chose Pass

Was this reply helpful? Yes No