Answered

sCondition in Flow SharePoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I have two columns "Person or Group", how can i put Condition for Initial person column like: if i put email address to that column, the flow will go to "Yes", if i leave it blank it will go to "NO"

i tried to put like this:

But when i don't fill email on that column" Initial person" it will be fail:

So Do you have any solution to fix it?

there is the columnS:

Thanks.

Categories:

General topics

All responses (4)

Answers (1)

Sort by

Verified answer

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

My apologies but I am not understanding what you need to do.

Are you trying to check if a person or group column is empty?

If so, just check for a null value. In my example below, my person or group column is called Employee.
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@NguyenHuu

If my solution works for you, accept is as the solution. That will help others with a similar issue find help.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank so much @ScottShearer ,
Your example exceed my expect :).
I have more issue need you help: i have three column: Start Time, End Time and Total time. My expect is Total time= End Time - Start Time= hour, for example: 9/29/2021 6:00 - 9/29/2021 10:30 = 4.5 hour.
The calculate i put at Total time: =MINUTE([End Time]-[Start Time])
But the result not match as i expected:
So how can i fix it?

Thank you.
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@NguyenHuu

Here is a link to a blog post that I wrote showing how to find the difference between two dates.

The blog post show how to calculate days - you'll need to use the mod() expression to get the remainder and do some additional calculations in order to get the fractional part of the day.