Unanswered

how to make flow automate to send email notification based on 3 column different page in powerapps

(0) Share

Report

Posted on by cacaw99

How to make flow automate to send email notification with condition 3 column in different page must have completed. The 3 column has "Text" type in Sharepoint List. I have this flow :

but the flow is error, I haven't filled in any of the 3 columns but the email has arrived. Can anyone help me? Thx

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (0)

v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cacaw99,
Do you want to send email if three columns are not null?
Could you please show some screenshots about run result?
You can try to use the length() function and compare with 0.

Best Regards,
Kyrie

Was this reply helpful? Yes No
cacaw99 58 on at

Like (0)

Report
Copy link

Link copied!

Dear @v-mingkz-msft
Yes, so I want these 3 columns if they are fulfilled, then a notification email will be sent if the column has type "text" in the sharepoint list, and is on a different page in Power Apps. But, the flow is run but the first time I fill out and submit the form, without filling in the fields in these conditions. The email has been entered, whereas I want that if the three fields are required to be filled in, there will be an email notification.

can you show the expression in more detail if you use the expression length if you want to detect the desired column?

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@cacaw99,
length(triggerOutputs()?['body/Title'])
Title is my field in SharePoint list.

Best Regards,
Kyrie

Was this reply helpful? Yes No
cacaw99 58 on at

Like (0)

Report
Copy link

Link copied!

Dear @v-mingkz-msft
I use your flow, my field in Sharepoint List "RootCause" but it cant detected. Could you share another formula/expression?
length(triggerOutputs()?['body/Root'])

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@cacaw99
You can first enter the length function in expression box
And choose your column in Dynamic content.

Note that the Dynamic content must be between parentheses.

Was this reply helpful? Yes No
cacaw99 58 on at

Like (0)

Report
Copy link

Link copied!

Dear @v-mingkz-msft
I already use your formula but it's still error. I already change the number "0" to be null but it doesnt work too. Please help, thank you

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@cacaw99
Please try this expression.
Note that null should be written in expression box.

Was this reply helpful? Yes No
cacaw99 58 on at

Like (0)

Report
Copy link

Link copied!

Dear @v-mingkz-msft It looks like this formula is the same as my formula at the beginning and it doesn't work. I cant get the email notification.
and if I use "not equal to", if the first column I fullfiled, it will send an email notification. What I want is if 2 column are fullfiled it will send an email notification

Was this reply helpful? Yes No
v-mingkz-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@cacaw99
Your column value is null, if you want to receive the email notification, you should replace the condition with

Was this reply helpful? Yes No
cacaw99 58 on at

Like (0)

Report
Copy link

Link copied!

@v-mingkz-msft is it like this? If yes, it doesnt work:(. It's weird, if I use this formula, when I fullfiled 1 column in PowerApps, it will send email notification. What I want is 2 column are fullfiled, it will send email notification

Was this reply helpful? Yes No