Share
Report
244I'm going to start by saying I know very little in Power Automate other than working on single SharePoint lists. Been doing a lot in Power Apps, but Power Automate is confusing the heck out of me. I apologize if what I'm asking is so basic a toddler could do it.
I'm trying to build a flow that will check a set of lists in a single SharePoint site collection that will all begin with the word "Local" in their display names (but NOT their internal names). The flow will run quarterly (i.e. start on 4/15 and run every 3 months). It will then check each item in each list for its last modified date. If that date is over 80 days old, it will change a yes/no field called QRC to false if it is true. Once this is complete, the flow will then check each item in each list for false QRC values and send an email notification to each item's owner (stored in a people picker) asking them to come review their item and update it if necessary. It will repeat the email notification weekly until the owner updates the QRC to true.
The furthest I've been able to get is using Get Lists and Filter Array to get only the lists that begin with "Local". I'm then lost as to how to check each item in each list for the required values (more than 80 days with no modifications and QRC = true) and then to check them again for all the QRC = false. It seems that it will probably be easier to do two separate flows, one to set the QRC for all items over 80 days old to false and a separate one to send an email notification to all owners where QRC is false. I just have no idea where to go from here.
Any help is appreciated, including any guidance for good free tutorials on the more complicated features like this. As mentioned before, I've done flows with specific lists, but never a site wide flow checking and acting on multiple lists simultaneously.
All responses (
Answers (
