Getting list of List types in SharePoint site

Help Studio
, , , , ,
1

Is there a way to get a list of all List types within a SharePoint site?

SharePoint
SharePoint696Ă—954 62.3 KB

2

Hi @margie.vicentillo

I don’t think there is any direct way to retrieve the same, below are the only activities available in UiPath package for lists as of now. However, you may be able to retrieve the same using SharePoint rest api call and then use the list names one by one to iterate through all those lists.

If you don’t want to use rest api call, then you can simply keep your list names in an asset(json) in orchestrator, loop through those list names one by one to further iterate through the items available in same.

The image displays a section of the UiPath documentation detailing different activities related to handling SharePoint lists, including descriptions of their functions. (Captioned by AI)
The image displays a section of the UiPath documentation detailing different activities related to handling SharePoint lists, including descriptions of their functions. (Captioned by AI)1320Ă—2194 121 KB

Hope this helps.

Regards
Sonali

3

@margie.vicentillo

From classic activities of o365 you have for each list activity which takes the site url and gives all list that are present in a loop

please try the same. Hope this helps

cheers

4

Hi @margie.vicentillo

If you’re using UiPath Integration Service and connected SharePoint through it:

Steps you try :

  1. Add the Microsoft 365 Scope
  2. Use “Get List Info” or “Find List Items” activity
  3. It requires setting the Site URL or Site ID
  4. You can retrieve:
    List name
    List type
    List ID
    Fields inside the list. Hope this works for you
5

This worked! I also used a filter List.Template = genericList to get all List types.
Thank you!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.