Daily flow to send a predefined email if a column in an excel table contains a date older than 6 months?

[emiled]

Hi all!

I am fairly new to this awsome technology and have tried do dog into threads around dates and how to set that up but i cannot get it to work with my requirements so I am hoping you guys can help :-)....

I want to create and shcedule a weekly flow to send a predefined "remember to" email if a column like "profile updated" for example in an excel table contains a date older than 6 months?

how do i achieve this? 

My Excel table date columns looks as follows and are formatted as "dates" in the format 2012-03-14:

I would greatly apprecciate your help

[manuelstgomes · Accepted solution]

Hi @emiled 

You can do the following:

1. Create a schedule trigger with the schedule in mind.
2. Fetch the values from Excel.
3. Do a "For Each" for each row
4. (Tricky part) The dates will come in number format. Here's how to convert them to dates https://manueltgomes.com/microsoft/powerautomate/convert-excel-number-to-date/
5. Now that you've converted it you can compare them with a simple if. Here's how to add days in the left comparison https://manueltgomes.com/reference/powerautomate-function-reference/flow-adddays-function/

addDays(utcNow(), (30*6) ,'yyyy-MM-ddTHH:mm:ssZ'))

 I know that 30*6 is not 6 months, but there are no addMonths functions

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

Can you please check if and let me know if you have any questions?

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

Cheers
Manuel

[emiled]

Hi @manuelstgomes and thank you for your answer.

I am unfortunately not really grasping how to incorporate the date conversion into my flow could you please give an example how that would look for my situation?

I am experiencing issue when trying to handle dates to update my list from a new list (export from another system) as well.

I have tried to get around this by creating the master in SharePoint list instead but that does not work either.

I really apprecciate the help!

thank you. 

see this for example for my update flow

I was trying to reference my input date and convert it at the same time in this flow but that did not work. 

This is the formula I tried to no avail:

formatDateTime(variables('Profile_x0020_Created'),'yyyy-MM-dd')

[manuelstgomes · Accepted solution]

Hi @emiled 

The issue is with the variable variables('Profile_x0020_Created').

You need, at the beginning of your Power Automate, to have a new variable created. You can create with a simple name like "Profile_Created" and using it like variables('Profile_Created')

The error message is indicating that you're using a variable without initializing it first.

Can you please check if and let me know if you have any questions?

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

Cheers
Manuel