Re: Is it possible to reference a document library in a list so i can use the data in a flow?
Hi
You can implement sucha a Power Automate Flow with a document library also, assuming the Date you want to evaluate is stored in a metadata column, just the same as if it was a List item
So you need:
-A daily recurrence trigger
-A SP 'Get files' action block.
In order to filter the contents of the list, there are different techniques:
-An 'Apply to each' with a Condition action block inside, taking 'Get items' output as 'Apply to Each' input
-A 'Filter Array' action block, then an Apply to Each taking Filter Array output as 'Apply to Each' input
-Filter ODATA query in the Get Items action block, then an Apply to Each taking 'Get items' output as 'Apply to Each' input
Assuming you are using 'Created' column that is a standard in a SP list, and you want to identify items with 'Created value' older than 7 days from todaya possible approach is the following Filter Array expression:
@less(item()?['Created'], addDays(utcnow(), -7))
IN the following screenshot you will see the secuence of actions after trigger Recurrence, please not the expression of Filter Array is more complex in my example than the one you need, but the steps should be the same for you
Inside your Apply to each, just invoke whatever logic you need, the loop will iterate through all items matching your Filter Array condition
Hope this helps
