Hi there
This is the first time posting in the forum but a long time user of the forum. What I am trying to do, is to get a flow to trigger an sending an email when the date of a required audit approaches. The audit due dates are listed in a SharePoint list and you would think that this would be a simple thing to do. However, no matter how much I tinker and how much I see what others have done, I cannot get this to work.
This is what I have done:
@equals(item()?['Nextauditdue'], adddays(utcnow(),'mm-dd-yyyy')+14)
So basically I want this to send me an email when it is 14 days to the audit due date.
If anyone can shed light on this, I would be most grateful.
Solved! Go to Solution.
ok, I will try that solution. thank you
I can not see the formula used in the Apply to each step
@SmokeEater1996 , the apply to each step has been modernized since this thread was created.
What are you trying to accomplish? Which part are you stuck at?
To replicate something similar to the original post, I have in my apply to each step the following:
formatDateTime(item()?['Due_x0020_Next'], 'MM/dd/yyyy')
is equal to
formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy')
The above is checking my "Due Next" column, which is filled with dates, are 30 days away from today's date.
I'm trying to do something very similar to what you have here, I will try that formula thanks.
@SmokeEater1996 I think you got several things happening here that I can already see:
What errors are you getting, if any?
So I'm not to sure this will help out or not,I have 0 experience with microsoft or coding/programming...
I've managed to upgrade my Android platform from 9 to 12+without documentation work adding microsoft. Downloaded flow today and learning about flow and buttons/push notifications and decided to share it with Edge and it said solved in green highlight to your link. So there you have it. Maybe you could return the favor...
Hi all,
I am new here on the forum, thanks for all your posts, really enriching.
I discover PowerAutomate, and my english level isn't good at all, sorry 😉
I read all contents of the post but i didn't find THE key to solve my problem...
I'm trying to create an
- automatic flow, launched every day
- for all documents in a doclib
- which have a date "CreateTask" (calculated column in SharePoint) equals Today
- in order to create a task in Planner.
Here's what i've done but it doesn't work.
I tested in the condition
- Left : formatDateTime(item()['DateCreationTache'],'yyyy-MM-dd')
- Right : formatDateTime(utcNow(),'yyyy-MM-dd')
but in results, false appears for all of them 😭
In advanced thanks for your help,
Regards
After your Flow has ran, you should be able to look at the details, so where it says false, there should be outputs of what was compared to what. Your formatting may be right but it may be that the utcNow() is returning the wrong day (depending on where you are located) so you may have to do a time conversion.
You can see from my previous posts that the code that ended up working for me was:
@equals(formatDateTime(item()?['Insurance_x0020_Expiry_x0020_Dat'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy'))
This compares date column Insurance Expiry Date to see if that date is 30 days from now. Hope that helps or write back and we can troubleshoot more.
@kristof805
Hello,
I'm trying to create a flow that does something similar to this except my data is in the data verse, and not in SharePoint.
Is there anyway you may have a method of doing basically the same thing but with the data verse?
Hey @LoneWolfe47 ,
I haven't created a flow with Microsoft's Dataverse actions but there should be a similar action to "Get Items" from a SharePoint list. Check out this article for functionality:
https://docs.microsoft.com/en-us/power-automate/dataverse/overview
After that, you should be able to copy my flow / logic after replacing my column name with a Dataverse column name. The syntax may be slightly different but you should be able to get an example from the output of your flow.
@kristof805 Thank you for getting back to me. I actually already figured it out before i found this reply, but i thank you so much for looking into it for me.
User | Count |
---|---|
85 | |
37 | |
25 | |
13 | |
12 |
User | Count |
---|---|
116 | |
55 | |
36 | |
23 | |
21 |