Good Morning all!
i am in the middle of trying to create a flow that grabs our Vacation list on our SharePoint. we have a list that gets created when a user puts in vacation time and is a list on our SharePoint what I want to do is grab that data but make it so it only grabs and shows from todays date + 5 days. i tried using utcNOW(5) but that formula did not work i am at somewhat a loss. any help would be amazing thanks for taking the time to read this !!
Cheers
Hi @Anonymous,
Just to double check with an example.
Below are four vacation items in a calendar list in my environment. If I would run the flow today (14/09), you would expect Test1 & Test2 to be retrieved because the Start Time is exactly 5 days from today (14/09 + 5).
But Test3 & Test4 are not retrieved because those haven't got a Start Time exactly 5 days from today.
If this is what you want can you configure the condition action like below.
1. Choose a value in the left Condition action field. Make sure you select the Expression tab. Paste in the expression below and press Ok.
Share
Report
All responses (
Answers (
formatDateTime(items('Apply_to_each')?['EventDate'], 'yyyy-MM-dd')
2. Select the correct operator from the dropdown list. In this case it should be is equal to.
3. Choose a value in the right Condition action field. Make sure you select the Expression tab. Paste in the expression below and press Ok.
addDays(utcNow(), 5 'yyyy-MM-dd')
Hopefully this is a bit clearer on how to configure the condition.
Morning,
i still cant get it to work i dont understand it just pulls all the data and not just the range of 5 days
Hi @Anonymous,
All the examples I showed earlier were about how you can retrieve vacation list items which have a startdate (datetime column) of 5 days or more in the future.
So, it makes sense that it is showing all the data, my bad 😅
Can you change the operator in your condition action from is greater than or equal to is equal to.
Morning I hate to keep on asking for help but it seems to only pull everything from the list not just the specific of 5 days from now. no idea what I am doing wrong. with your previous post what exactly do you mean new expression i tried using Start Time and StartTime which were two fields that popped up but didnt work i also tried EventDate but it doesnt seem to be a valid column. could it be the format the date is coming out as this is what it looks like on my sheet
Hi @Anonymous,
That new expression should still give you items which have a Start Time 5 days from now.
Thanks for the reply will that expression still do the same by giving me just 5 days of date from now. i currently have this -
Hi @Anonymous,
Thanks for checking.
If the condition action is still within the Apply to each 3 action the expression for the Start Time should be:
formatDateTime(items('Apply_to_each_3')?['EventDate'], 'yyyy-MM-dd')
ohh i think we might be getting close i think those are the real names from the look of the URL let me know what you think now with that info
Hi @Anonymous,
Sorry, I forgot to include the screenshots. Can you check again in the list settings?
1. Navigate to the Vacation list. Click on List settings in the right top menu.
2. Click on the Start Time column in the Columns section.
3. Check what the name is in the address bar. That internal name can be different from the Display Name.
4. Also check this for your End Time 🙂
i took a look at the list that does the vacation flow and found this and then took a look at the exact list on SharePoint.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
