Answered

Get all dates in an interval (start and end)

(0) Share

Report

Posted on by Oskarkuus

1,095

Hi

I need help to figure out how i can collect dates in a effective way.

I ask my user to enter from what start date to end date when the user are on vacation (for example).

I use flow to send out a reminder to other users when start date matches todays date. But now to my problem. If a user enters a start date and an end date that in total contains 10 days. I want to send out a reminder every day during that time, so one reminder each day during the 10 days. Not as i have it now, only a reminder on the start date and nothing on day 2-10.

How can i get each date between these dates so a flow triggers each day?

Im thinking that i can force the user to create a report only for one day at a time, but that is not very nice to ask of them.

I am thinking that i want to calculate the amount of days between start and end date. Then tell my flow to post the info 10 times (one time per day).

Or can i make an calculation and extract each date and store them in a list and let the flow trigger on those?

But i dont know how.
Or is there other ways to create this.

All responses (10)

Answers (1)

MattPMoS 11 on at

Like (0)

Report

Re: Get all dates in an interval (start and end)

@ScottShearer, thanks for this detailed writeup--I was having the same issue and am a complete noob at this (and am not granted a great deal of time to improve my skills). I'm making most of my progress by finding and copying other's solutions. There's a lot of subtleties to setting these up; using the filter query as an example, I'm still unclear when you enter some info in the Query field and when you add some via the Dynamic Content/Expression Box. And I was stalled for so long simply because I'd had the addDays output configured incorrectly (wrong date format, and mm instead of MM). Painstaking comparing my setup to your example is what cut the Gordian Knot.

If you have the time to toss a weary Museum educator another bone, I've finally gotten the "Get Items" output I was looking for, but would like to sort by date as well. Any easy solutions? I wouldn't even know at what point in the flow it is better to do this, right at the beginning or after I've filtered out the data I want to keep.
Oskarkuus 1,095 on at

Like (0)

Report

Re: Get all dates in an interval (start and end)

ok thanks i think im getting closer.
I belive i get the result im after now... need to test a bit.

However, how can i change the way the date looks like.
Now it looks like this. Can i remove the time numbers?
2019-04-10T18:00:00Z till 2019-04-17T19:00:00Z
Verified answer

ScottShearer 25,228 Most Valuable Professional on at

Like (1)

Report

Re: Get all dates in an interval (start and end)

@Oskarkuus
My example will retrieve items from a list where the start date is today or in the past and the end date is today or in the future. I believe that is what you have asked for. You can set your variable and take action inside if the loop.
Oskarkuus 1,095 on at

Like (0)

Report

Re: Get all dates in an interval (start and end)

I think i explained poorly. This is not what i am looking for.

I have a list in sharepoint.
Column 1 = name
Column 2 = startD
Column 3 = endD

This is my flow; screenshots:
http://prntscr.com/nbgaol
http://prntscr.com/nbgd7n
http://prntscr.com/nbgdd8
http://prntscr.com/nbgbh5
Ignore that the names dont mach, pictures where taken during my testing so i changed things around.
http://prntscr.com/nbgbzg

My stringvariable is empty. Nothing except the static text is posted in my team.
I want my string variable to contain the startdate and enddate and title IF the enddate have not yet occured.
All i can get is a post when todays date checks to either startdate or end date, but if the intervall is 5 days between start and end, there are no info posted (variable) during day 2-5.
ScottShearer 25,228 Most Valuable Professional on at

Like (0)

Report

Re: Get all dates in an interval (start and end)

@Oskarkuus :

Below is a screen shot of a Flow that I believe will meet your requirements.

I used an OData filter so that you only retrieve the items that are in your date range.

Please note the single quotes around the expressions.

The second expression is documented in the comments for the Get Items action.

Please let me know if this works for you.
ScottShearer 25,228 Most Valuable Professional on at

Like (0)

Report

Re: Get all dates in an interval (start and end)

@Oskarkuus

Stay tuned - I will provide an example in a few hours....
Oskarkuus 1,095 on at

Like (0)

Report

Re: Get all dates in an interval (start and end)

I have now fixed so all data is stored in a sharepoint list.
One column is called StartD and another is EndD (start date and end date)
ScottShearer 25,228 Most Valuable Professional on at

Like (0)

Report

Re: Get all dates in an interval (start and end)

@Oskarkuus :

You'll need to store the data somewhere other than in Forms in order to meet your requirement. Let me know where you end up saving the data and I'll try to assist. SharePoint would likely be one of your best choices.
Oskarkuus 1,095 on at

Like (0)

Report

Re: Get all dates in an interval (start and end)

Well i store my data wherever it needs to be stored tbh.

Currently i collect the dates with an Microsoft forms. but it is easy to transfeer the collected data from forms to a sharepoint list.

I have now a flow that start with an recurrence trigger, runs every day. It posts a message in a team conversation. It pulls the start dates and if the startdate is todays date, then it posts that date in the message in teams.

But i can not get it to also post if the end date have not occured.... So i need an formula to post untill the end date?
ScottShearer 25,228 Most Valuable Professional on at

Like (0)

Report

Re: Get all dates in an interval (start and end)

@Oskarkuus

The answer depends on where you are storing your data. Is it in SharePoint?

You'll want to start with a recurrence trigger that runs once a day. The next step depends on where you store your data.