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

All responses (4)

Answers (0)

TomasKCSL 8 on at

Like (0)

Report

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

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
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

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

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
TomasKCSL 8 on at

Like (1)

Report

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

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.'.
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

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

Hi @TomasKCSL

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

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

Thanks