Thank you for your help, I've tried your suggestion and I saw I'm only getting 1 list out of 8. Apparently it only works when the list type is 'Group', when the type of the list is 'List' then it won't collect the content
So if we choose to use a 'List Update' in a workflow and selecting 'Create or use a list with its own table' then the list is automatically created with type 'List'.
Try to use a query and change the filtering and targeting dimension to List and then form a query like :
But the problem is this will only give you lists inside that folder and not the contents of all those lists.
Another way , I can think of doing this is through read-list activity by using the "name computed by a script" option. Here you get the option of selecting a folder and select lists present in the folder via the template.