cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jswanson1
Level: Powered On

Email flow will not pick up list items to trigger

I'm trying to build a flow that will trigger based on a date from a list in SharePoint. We're trying to automate expiration reminders. I have a several dummy dates to trigger for testing, but every time the date comparison comes back false. I've used this template for other flows that work. The formatdatetime piece I have tried "MM-dd-yyyy", "yyyy-MM-dd", etc. The requested column is calculated, but I've had other flows based on calculated fields. tg flow list.PNG

 

TG Flow 1.PNGTG flow 2.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Email flow will not pick up list items to trigger

 

Hi @Jswanson1 ,

 

From your screenshot, the value of the calculated column output contains the time, so you also need to use the formatDateTime() function to convert its format, like:

98.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
Super User
Super User

Re: Email flow will not pick up list items to trigger

@Jswanson1 

Please see my example below.  The expression used in the condition can be seen in the comments area.

I added to the condition in order to filter out folders.

Also, a better way to approach this might be to use a filer query which will simplify your Flow and eliminate the condition.  The issue is that you can't use calculated columns in a filter query - you would need to do the calculation in an expression inside of the filter query as well as filter out the folders.

 

CalcColFilter.jpg

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

Scott
Jswanson1
Level: Powered On

Re: Email flow will not pick up list items to trigger

I'm not sure how to do it differently than having calculated fields in the list itself. I was trying to use conditions rather than having all the calculated columns, but it wasn't triggering that way. For example, an item expires on 6/14/2019. I have that column, then I have calculated columns based on that date for 14 days prior to expirations, then 30 days prior to expiration for reminder email alerts. 

 

I know only enough about flows to be dangerous and frustrated.

flow list 2.PNG

Super User
Super User

Re: Email flow will not pick up list items to trigger

@Jswanson1 

Try using expressions in your condition per my example - I believe it will address your issue.

 

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

Scott
Jswanson1
Level: Powered On

Re: Email flow will not pick up list items to trigger

Yes but I don't understand what to do with what you've provided. I don't understand why you're using get files, rather than items, and I don't understand why you've included a folder condition. 

Super User
Super User

Re: Email flow will not pick up list items to trigger

@Jswanson1 

My error - somehow I got the impression that this was a library.  Just replace my Get files action with a Get items action.  If you don't have folders in your list then ignore the folder condition.

 

The date column you are using is a calculated column.  Can you tell me the calculation? I'll provide a better way of approaching this issue using a filter query.

 

The expressions that I used allow for the dates to be formatted in the same why allowing you to do the comparison in your condition.

 

 

 

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

Scott
Jswanson1
Level: Powered On

Re: Email flow will not pick up list items to trigger

flow test 1.PNG

Jswanson1
Level: Powered On

Re: Email flow will not pick up list items to trigger

false output.PNG

Super User
Super User

Re: Email flow will not pick up list items to trigger

@Jswanson1 

Reference the output of the compose action in you condition rather than the co7

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

Scott
Community Support Team
Community Support Team

Re: Email flow will not pick up list items to trigger

 

Hi @Jswanson1 ,

 

From your screenshot, the value of the calculated column output contains the time, so you also need to use the formatDateTime() function to convert its format, like:

98.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Jswanson1
Level: Powered On

Re: Email flow will not pick up list items to trigger

I have been using formatedatetime for yyyy-MM-dd and it still comes back as false, even if they actually match.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,653)