cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jenright
New Member

Flow issue Regular expression result false

Hi guys,

 

Im hoping you can help me with something... im creating a flow for some SP lists - and essentially when the date in my column called "Review Date" meets "todays date" - i want it to send an email advising this.

 

The weird thing is the below was working up till this week - but now ihave gone to test the flows and they are all saying "successful" but when you go into the details im geting the result of False under the expressions section. 

 

Please help!! This is uber important as its part of our intranet...

 

 flow.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Flow issue Regular expression result false

Hi @jenright,

 

Could you please share a full screenshot of the configuration of your flow?

Could you please share more details about your sharepoint list?

What is the type of the Review Date column in your sharepoint?Does the Review Date column is a date and time type and don't include time?

 

If the Review Date column is a date and time type and don't include time, your expression in the flow is correct with no issue, please check if you have multiple items in the sharepoint list, and the Apply to each have multipl loop, and maybe some items don't meet the condition, so the result of the certain loop is false.

 

If the Review Date column is a date and time type and include time, you should modify the expression in the condition as below:

@equals(formatDateTime(items('Apply_to_each')?['Review_x0020_Date'], 'yyyy-MM-dd'), formatDateTime(utcNow(), 'yyyy-MM-dd'))

 

Best regrads,

Alice

View solution in original post

2 REPLIES 2
jenright
New Member

Re: Flow issue Regular expression result false

In case the expression isnt clear enough - this is what im using:

 

@equals(items('Apply_to_each')?['Review_x0020_Date'], formatDateTime(utcNow(), 'yyyy-MM-dd'))

Community Support
Community Support

Re: Flow issue Regular expression result false

Hi @jenright,

 

Could you please share a full screenshot of the configuration of your flow?

Could you please share more details about your sharepoint list?

What is the type of the Review Date column in your sharepoint?Does the Review Date column is a date and time type and don't include time?

 

If the Review Date column is a date and time type and don't include time, your expression in the flow is correct with no issue, please check if you have multiple items in the sharepoint list, and the Apply to each have multipl loop, and maybe some items don't meet the condition, so the result of the certain loop is false.

 

If the Review Date column is a date and time type and include time, you should modify the expression in the condition as below:

@equals(formatDateTime(items('Apply_to_each')?['Review_x0020_Date'], 'yyyy-MM-dd'), formatDateTime(utcNow(), 'yyyy-MM-dd'))

 

Best regrads,

Alice

View solution in original post

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,116)