sCondition in Flow SharePoint list

[NguyenHuu]

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.

[ScottShearer · Accepted solution]

@NguyenHuu 

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]

@NguyenHuu 

If my solution works for you, accept is as the solution.  That will help others with a similar issue find help.

[NguyenHuu]

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]

@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.