Solved: Condition

Anonymous · ‎10-10-2023

Hello, I'm trying to list/extract all the Inputs(dataSource: sharepoint list) that causes the condition to be true . Is there an efficient way to perform this ?

FLMike · ‎10-10-2023

@Anonymous

Oh I see, you want to put into the email, which or the conditions above were null and therefore put you into the Yes side.

Ok do this.

In your email and btw, I am not providing formatting, I am simply doing what I think you want.

NOTE: you will need to do this 4 times, 1 for each expression

In the body, click somewhere, when the popup window comes up, in the expression

BUT you would replace the '3mValuehere' with your dynamic property like you used in your condition

if(equals('3mValuehere',null),'The 3M value was null','')

Your email would look like this, because you put in all 4 checks, 1 for each Dynamic property in your Condition. Again its not formatted or pretty, and you can change the message however you want, its just an example

Then when it sends, it will either have a blank line, or the phrase you typed into the expression

View solution in original post

FLMike · ‎10-10-2023

@Anonymous

Hi, do you mean you are trying to Filter a SharePoint list?

You would use a Filter statement like this

Filter(MyListrName, MyFilterExpression)

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Anonymous · ‎10-10-2023

Not exactly. I have a condition set to see if the data isn't filled after certain date for multiple columns in share-point list. If the condition runs true I want to reference the headers of the columns in email notification.

FLMike · ‎10-10-2023

@Anonymous

if you have a flow, you need to share that, just using words is not a way to get help.
If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Anonymous · ‎10-10-2023

How can I list the inputs that ran true in my email?

FLMike · ‎10-10-2023

@Anonymous

Oh I see, you want to put into the email, which or the conditions above were null and therefore put you into the Yes side.

Ok do this.

In your email and btw, I am not providing formatting, I am simply doing what I think you want.

NOTE: you will need to do this 4 times, 1 for each expression

In the body, click somewhere, when the popup window comes up, in the expression

BUT you would replace the '3mValuehere' with your dynamic property like you used in your condition

if(equals('3mValuehere',null),'The 3M value was null','')

Your email would look like this, because you put in all 4 checks, 1 for each Dynamic property in your Condition. Again its not formatted or pretty, and you can change the message however you want, its just an example

Then when it sends, it will either have a blank line, or the phrase you typed into the expression