SharePoint Get items action -- Is not allowing to pass the ListName Dynamically. But there is an option to use Variable under ListName.

[pvarma8]

I am trying to use Get Items action in Power Automate Desktop, but My requirement is to pass the list name dynamically based on the value received in input variable. My action is not allowing be to save and sometimes I can it, but the action getting failed.

The error message is _-Dynamic output schema couldn't be retrieved.

[pvarma8]

I am facing issue with the Update item as well. Somehow, I managed to work with Get Items by passing id retrieved from Get lists action. I am unable to make Update Item action dynamic. The error is Dynamic input schema couldn;t be retrieved. Please help.

[Kaif_Siddique]

Hi @pvarma8 ,

Provide full site address.

Example: https://contoso.sharepoint.com/sites/sitename

Hope this will help you.

Regards

Kaif

[VishnuReddy1997]

Hi @pvarma8 ,

Based on my understanding, if your site address and list name are dynamic, I don't believe the current version of PAD supports pulling the list item as input in dynamic mode.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards

Vishnu Reddy

[Agnius]

You cannot really do this via the user interface, but you can modify the code behind the action in a text editor. First, set up the action by using direct (non-dynamic) inputs, and save it. Then copy the action and paste it to a text editor. Then edit the site address and / or list name fields to contain variables, and then paste the code back to the designer. 

This works, and I have tested this several times. I have, for example, done the same thing in my PAD Framework, where I have the Logger utility flow that logs to a dynamic SharePoint lists. See here: https://github.com/AgniusBartninkas/power-automate-desktop-framework

The code could look somewhat like this when you set it up normally:

@@dataset: 'Agnius - https://{sanitized}.sharepoint.com/sites/Agnius'
@@table: 'Log Messages'
@@view: ''
@@'InputSchema:item': '903008207'
@@'OutputSchema:PostItemResponse': '-1550202392'
@@connectionDisplayName: 'PADFramework_SharePoint'
External.InvokeCloudConnector Connection: '{sanitized}' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_sharepointonline' OperationId: 'PostItem' @dataset: $'''https://{sanitized}.sharepoint.com/sites/Agnius''' @table: $'''3022b5be-1478-47bd-baa8-d7e37b70e7cb''' @'item/Title': Log_Level @'item/Timestamp': Log_Timestamp @'item/Machine': Log_MachineName @'item/Project': Input_ProjectName @'item/Flow': Input_FlowName @'item/Subflow': Log_SubflowName @'item/Message': Log_Message @PostItemResponse=> PostItemResponse

# [ControlRepository][PowerAutomateDesktop]

{
  "ControlRepositorySymbols": [],
  "ImageRepositorySymbol": {
    "Repository": "{\r\n  \"Folders\": [],\r\n  \"Images\": [],\r\n  \"Version\": 1\r\n}",
    "ImportMetadata": {},
    "Name": "imgrepo"
  },
  "ConnectionReferences": [
    {
      "ConnectorId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
      "DisplayName": "PADFramework_SharePoint",
      "InternalId": "{sanitized}",
      "IsDisabled": false,
      "LogicalName": "def_PADFramework_SharePoint",
      "IsEmbedded": false,
      "ConnectionName": "{sanitized}",
      "ConnectionDisplayName": "{sanitized}"
    }
  ]
}

But then you can replace the values for dataset and table with variables, and it would look somewhat like this:

@@dataset: '%Input_LogAddress%'
@@table: '%Input_LogAddress%'
@@view: ''
@@'InputSchema:item': '903008207'
@@'OutputSchema:PostItemResponse': '-1550202392'
@@connectionDisplayName: 'PADFramework_SharePoint'
External.InvokeCloudConnector Connection: '{sanitized}' ConnectorId: '/providers/Microsoft.PowerApps/apis/shared_sharepointonline' OperationId: 'PostItem' @dataset: Input_LogAddress @table: Input_LogPath @'item/Title': Log_Level @'item/Timestamp': Log_Timestamp @'item/Machine': Log_MachineName @'item/Project': Input_ProjectName @'item/Flow': Input_FlowName @'item/Subflow': Log_SubflowName @'item/Message': Log_Message @'item/FlowRunURL': $'''%''%''' @PostItemResponse=> PostItemResponse

# [ControlRepository][PowerAutomateDesktop]

{
  "ControlRepositorySymbols": [],
  "ImageRepositorySymbol": {
    "Repository": "{\r\n  \"Folders\": [],\r\n  \"Images\": [],\r\n  \"Version\": 1\r\n}",
    "ImportMetadata": {},
    "Name": "imgrepo"
  },
  "ConnectionReferences": [
    {
      "ConnectorId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
      "DisplayName": "PADFramework_SharePoint",
      "InternalId": "{sanitized}",
      "IsDisabled": false,
      "LogicalName": "def_PADFramework_SharePoint",
      "IsEmbedded": false,
      "ConnectionName": "{sanitized}",
      "ConnectionDisplayName": "{sanitized}"
    }
  ]
}

This works when you paste it back into the designer, as long as you don't open the action there (or if you do open it, do not save changes, as that will clear the dynamic fields, and you'll need to go through the process again).