Forum Discussion
Can I get all items from multiple SharePoint lists using none-premium connector
I have a site content type named "Asset", and we are adding custom lists and add this content type to it. now using Power Automate i want to get all items from all the underlying custom lists (which have the Assets content type and was modified in the last 24 hours ago)>> check if 2 columns are equal if not to update the 2 columns to be equal. so can i do this inside scheduled flow? can i benefit from SharePoint search api to get items from multiple lists? the service account running the flow does not have premium license.
johnjohn-Peter why not just use multiple get items actions in parallel branches and use filter queries?
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)Rob_Elliott this is because we will keep adding and removing lists by site admins. and site admins do not know power automate to keep updating the flow whenever they add or remove a list.. did you get my point?
johnjohn-Peter with the get items action you can get items based on content type but only from a single list. You can't get items from all lists on a site without either using a premium connector like the encodian one or use multiple get items.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
