I have a SharePoint List (Around 4.6k records and growing) and two of the columns are Expiration Date (Date type) and Expired (Single Line of Text)
Now I want to schedule a daily Flow to go through all the List and check if Expiration Date < Today and change the Expired to Yes from No.
Is the Flow best to achieve this?
I think I saw somewhere that there is a limit of only 500 rows that Flow can retrieve at a time is that correct?
That might not be a big issue, as I could just filter my list to check only rows that are currently Expire = No (currently around only 300 rows have Expired = No). However, what happens if at some point in future there are more than 500 rows with Expired = No?
I was playing around in Flow and here is what I have:



Issues:
1. What function should I write to compare date to todays date? What I have right now is
@less(items('Apply_to_each')?['ValidUntilDate'], @today)But I don’t think @today is valid in Flow
2. When I do the Update Item action, do I need to fill out each field or it will take current value that the field has if I leave it blank?