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)

Sort by

abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(1)

Report
Copy link

Link copied!

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,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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