You’re offline. This is a read only version of the page.
58
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
@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
Your column value is null, if you want to receive the email notification, you should replace the condition with
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
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
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.
Dear @v-mingkz-msft
I use your flow, my field in Sharepoint List "RootCause" but it cant detected. Could you share another formula/expression?
Share
Report
All responses (
Answers (
length(triggerOutputs()?['body/Title'])Title is my field in SharePoint list.
Best Regards,
Kyrie
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?
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
