Unanswered

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

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building flows

I have the same question (0)

All responses (19)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
Hi @Anonymous,

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

addDays(UtcNow(), 5)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No