I have a flow that grabs data from a list of repairs that our warehouse technicians perform daily and reads the serial number of an item and other criteria to see if the renewal date of that item is coming up. If the renewal date is 30 days or less from today's date an email will be sent to the appropriate manager notifying them. When that renewal date approaches and the technician replaces the filter on an item, for example, they will re-enter that same item to the list. So now the list will have two items with the same serial number but different renewal dates. I'm stumped and want to know if there is a way to keep both entries, but have the flow read off the most recent entry's renewal date and not the older entry.
Hi @pure96 ,
I’ve made a test for your reference:
1\My SP list:
3\You can get the record of the latest expiration of each serial in the compose in each loop
I tried and got this error message at the first "Filter Array" action:
The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@and (less(item()?['Renewal_x0200_Date'], addDays(utcNow(), 30)),greaterOrEquals(item()?['Renewal_x0200_Date'], utcNow()) )' failed: 'The template language function 'less' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.
I also need this to work for two other renewal dates, PAP renewal date and Concentrator renewal date. Is that possible?
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!