04-29-2021 11:14 AM
There are times when it would be great to have a List of all the Flows deployed on a SharePoint List/Library. It's not pretty straight forward, but it's definitely possible.
I am creating a Flow with manual trigger here which will get you a list of all the Flows deployed on a SharePoint List with the 'when an item is created' trigger.
**We need this step to get the Definition of the flow which contains detailed information about trigger and actions used in the Flow
** We need this step to populate the Array with all the Flow Definitions for further processing
** We need this step to filter Flows with "When an Item is created" trigger
** I am passing the GUID manually here but you can add another action to get the GUID of the List/Library by sending a rest query to SharePoint
There you go, you now have a list of all the Flows created by you and deployed on a SharePoint List/Library!
Hope this was helpful!
The operation "Get Flow" is not listed in the Choose an Operation list.
Up to that point it works great!
I know this is older but do you know of a way to go the other way? I have a list of all workflows through the CoE but I'm struggling with the logic to get all the SharePoint lists/libraries that are affected by the workflows.
Hello. This is a very interesting and potentially VERY useful flow. However, the filter 3 step failed for me. Not sure if the response body changed after you published this, but here is my error:
The execution of template action 'Filter_array_3' failed: The evaluation of 'query' action 'where' expression '@equals(item()['Definition']['triggers']['When_an_item_is_created']['inputs']['parameters']['dataset'], variables('GUID'))' failed: 'The template language expression 'equals(item()['Definition']['triggers']['When_an_item_is_created']['inputs']['parameters']['dataset'], variables('GUID'))' cannot be evaluated because property 'parameters' doesn't exist, available properties are 'host, method, path, authentication'. Please see https://aka.ms/logicexpressions for usage details.'.
If you can provide any clues as to what happened and how to correct this, I would greatly appreciate it.
Thanks,
Howard