SharePoint get list item action

Use the Get list item action to retrieve the list item details from a list in your SharePoint site.

Pré-requisitos

Ensure that you are authenticated before initiating any SharePoint action. For more details, see action autenticar do SharePoint.

Procedimento

  1. From the Actions pane, select SharePoint > List and list items > Get list item and place it in the canvas.

    SharePoint get list item
  2. In the Site field, select one of the following options:
    • Default site: The site name used during authentication is considered the default site.
    • Other site: If you want to choose a different site, specify the different site name.
  3. In the List name field, specify the list name.
  4. In the Filter field, choose one of the following options:
    • All list items: Retrieve details of all the list items in the SharePoint list.
    • List item ID: Specify the list item ID to retrieve details of this specific list item.
    • List item title: Specify a list item title to retrieve details of this specific list item that contains the title.
    • Folders: Specify a folder path to retrieve all items within, including files and subfolders (and their contents).
      Nota: To enable the option to create folders within lists in SharePoint, see Create a folder in a list.
  5. In the Download file item(s) field, select one of the following options:
    • No: Select this option if you do not want to download the file items.
    • Yes: Select this option and specify a destination folder path to download the file items within the folder path.
  6. In the Download image column(s) field, select one of the following options:
    • No: Select this option if you do not want to download the image attached to the list item.
    • Yes: Select this option and specify a destination folder path to download the image attached to the list item.
  7. In the Session field, select one of the following options:
    • Session name: The name you provided for the session during authentication.
    • Variable: Select a variable which contains the session name.
  8. In the Matched records field, select a variable to store the list item details.
The specified list item details are retrieved and stored in the variable.
Nota: A saída é recuperada como uma lista do tipo Dictionary. Para ler um registro individual (linha) nessa lista, é necessário percorrer todos os itens do dicionário usando a ação Loop e ler ou extrair os registros (linhas) individualmente. Por exemplo, se a lista estiver armazenada na variável list_FolderDetails e tiver cinco registros, então, cada gravação passa pela ação de Loop para ser processada. O loop lê o Nome, URL, hora da última modificação e ID exclusivo de cada pasta.Ação getFolder do SharePoint