Need some Help with this Vacation list flow i am trying to create

[Anonymous]

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  

[Expiscornovus]

Hi @Anonymous,

You can use the addDays function to calculate a date 5 days in the future. The expression would be:

addDays(UtcNow(), 5)

[Anonymous]

Thanks for the reply ill give that expression a try for sure. for some reason having bigger issues this morning i cant even get my flow to grab any data at all from the SharePoint list. 

[Expiscornovus]

Hi @Anonymous,

If you need any additional help configuring that let us know.

Btw, below is an example on how you could use that expression in a condition action.

This example shows how you can retrieve vacation list items which have a startdate (datetime column) of 5 days or more in the future.

The condition itself is:

formatDateTime(items('Apply_to_each')?['StartDate'], 'yyyy-MM-dd')

is greater than or equal to

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

[Anonymous]

thanks again for the reply. i was able to get my data to be pulled but i found what you tried to do and kept getting error msg. 

i tried this - but didn't work still pulled all data from like years ago. 

when i tried what you advised i got this error -

i feel like I'm getting close! 

[Expiscornovus]

Hi @Anonymous,

The expression I shared refers to an action called Apply to Each. In your case the first apply to each action is called Apply to Each 3.

You can change the expression to reflect the correct action name. 

formatDateTime(items('Apply_to_each_3')?['StartDate'], 'yyyy-MM-dd')

Also make sure you change the expression to use the correct column name. In my example it was called StartDate, yours is StartTime as what I can tell from the first screenshot.

[Anonymous]

thanks again for the reply i gave it a shot but got this error msg now - 

[Expiscornovus]

Hi @Anonymous,

Is your StartTime a required field? Or is it possible that in your Vacation list you have items were this column is empty?

[Anonymous]

Morning,

the three fields i am trying to pull our Name(Title) - Start Time - End Time and all three of those fields have data but for some reason its either pulling all data from years of vacation time or its not pulling any data at all with specific conditions. 

[Expiscornovus]

Hi @Anonymous,

Can you double check in the Vacation List Settings what the internal names of your Start Time and End Time are? It might be possible that those are Start_x0020_Time & End_x0020_Time.

If that is the case we need to change the expression to reflect the correct field names.

[Anonymous]

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. 

[Expiscornovus]

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 🙂

[Anonymous]

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 

[Expiscornovus]

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')

[Anonymous]

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 - 

[Expiscornovus]

Hi @Anonymous,

That new expression should still give you items which have a Start Time 5 days from now.

[Anonymous]

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

[Expiscornovus]

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.

[Anonymous]

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 

[Expiscornovus]

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.

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.