Hello all,
I have a flow that I need to update list items based on the date that is set on the 'Start Date' and 'End Date' columns I have set up. I have previously posted about this (linked below), and while the original post did lead me on the right track, something is still not working correctly. Through some experimentation and looking through other posts for guidance, I have set up a flow that is running successfully on the outside, but it's not actually finding the items in my list that I need it to.
Basically, my list is tracking events in my organization. So, I need the flow to cycle through the items every day to find any that have the 'Start Date' column equal to [Today], and if so, update that item to the status "Occurring". Then again for the 'End Date', and update to "Completed".
I originally had it set up as the solution from my first post suggested, but for some reason the filter query in the Get Items wasn't registering my column name. So not sure if I was putting it in wrong, but I tried several things and still nothing. So for this flow, I tried just using a condition to update the item if the date in the column was equal to the variable I set up for today's date.
Hopefully that all makes sense. Also, I am still not super well versed in building flows so some of the steps I took may be pointless or way off base. Any help is appreciated.
Solved: Re: Time Expression for Current Date - Power Platform Community (microsoft.com)
