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
Solved! Go to Solution.
Hi @emiled
You can do the following:
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
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
Hi @emiled
You can do the following:
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
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:
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
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
80 | |
55 | |
55 | |
43 | |
39 |
User | Count |
---|---|
83 | |
81 | |
76 | |
64 | |
42 |