Forum Discussion

johnjohn-Peter's avatar
johnjohn-Peter
Iron Contributor
Aug 23, 2024

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. 
 
Microsoft Flow
sharepoint

3 Replies

  • Rob_Elliott's avatar
    Rob_Elliott
    Silver Contributor
    Aug 24, 2024

    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)

    • johnjohn-Peter's avatar
      johnjohn-Peter
      Iron Contributor
      Aug 24, 2024

      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?

      • Rob_Elliott's avatar
        Rob_Elliott
        Silver Contributor
        Aug 24, 2024

        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)

Resources