Email Reminder Flow using SharePoint list

[Jeremydr48]

Hello I am trying to build a flow from a SharePoint List.  I am unable to figure out how to send an email reminder when a time date field is entered and two weeks has passed.  Any assistance thinking through this logic would be greatly appreciated.

Scenario: SharePoint Item is filled out and includes the date a laptop is assigned (for example).  I need to send a reminder two weeks from date laptop was issued to the technician who assigned the laptop.  Then if the Return date is still not filled out 2 weeks from reminder date to send another email.  So if laptop was issued on 9/23 a reminder email would be sent out on 10/3 and if another field Return date is still empty after 2 weeks send a second reminder 2 weeks later 10/21.

Any help figuring this out would be greatly appreciated. 

Thanks

[David-]

Use a query filter in the Get items action on your date field. For example, if you wanted to find everything that was created two weeks ago, you would use the following expression in the query filter:

Created eq 'addDays(utcNow(),-14,'yyyy-MM-dd')'

Note that the query filter uses the internal name of the field and not the display name. If you don't know what that is, you can get it by going to your list settings and clicking on the field name. Look at the end of the URL and it will display the internal name of the field.

You would then set up your flow as a scheduled flow and have it run every day.

[Jeremydr48]

David thank you for your reply.  The thing is the list creation date may not be the same as the date the laptop was assigned.  would I then use the internal name of the field instead of Created?

[Jeremydr48]

When I tried the Internal name of the field I get the following error under get items.

Error Details: Unable to process template language expressions in action 'Get_items' inputs at line '0' and column '0': 'The template language function 'addDays' expects a timestamp as the first parameter, the number of days to add as the second parameter, and an optional format string as the third parameter. The function was invoked with '1' parameter(s). Please see https://aka.ms/logicexpressions#adddays for usage details.'.

field_7 eq 'addDays(utcNow())'

[David-]

You would replace Created with whatever date field you are using to store this value.

[David-]

I included the correct format for this in my earlier response: 

addDays(utcNow(),-14,'yyyy-MM-dd')

Just change '-14' to however many days you want to add to the current date (negative numbers will give past dates while positive numbers will be future dates).

[Jeremydr48]

I am close to getting this working.  I have used the  field_7 le addDays(utcNow(),-14,'yyyy-MM-dd') and it does what I need it to.  the only think I need to add to this query is  field_7 le addDays(utcNow(),-14,'yyyy-MM-dd') and Returndate eq null.  basically if field_7 is older than 14 days and Returned date field is empty then send email.  Thanks again for your assistance it is much appreciated.