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érequis

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

Procédure

  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).
      Remarque : 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.
Remarque : La sortie est récupérée sous la forme d\'une liste de type Dictionary. Pour lire un enregistrement individuel (ligne) dans cette liste, vous devez parcourir tous les éléments du dictionnaire à l\'aide de l\'action Loop et lire ou extraire les enregistrements (lignes) individuellement. Par exemple, si la liste est stockée dans la variable list_FolderDetails et qu\'elle contient cinq enregistrements, chaque enregistrement est transmis à l\'action Boucle pour être traité un par un. La boucle lit le nom, l\'URL, l\'heure de la dernière modification et l\'ID unique de chaque dossier.Action Obtenir des dossiers SharePoint