cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NguyenHuu
Helper IV
Helper IV

sCondition in Flow SharePoint list

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: 

NguyenHuu_1-1632924577980.png

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

 

NguyenHuu_2-1632924808914.png

So Do you have any solution to fix it?

 

there is the columnS:

NguyenHuu_0-1632924089591.png

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

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

image.png

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

4 REPLIES 4
ScottShearer
Super User
Super User

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

image.png

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
ScottShearer
Super User
Super User

@NguyenHuu 

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

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

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:

NguyenHuu_0-1632927871268.png

So how can i fix it?

 

Thank you.

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

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,131)