Solved! Go to Solution.
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.
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.
Stay tuned - I will provide an example in a few hours....
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.
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:
Ignore that the names dont mach, pictures where taken during my testing so i changed things around.
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.
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?
@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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!