SharePoint Get Items problem with Site address in Variable

[SzymonBochniak]

Hello,

I'm using SharePoint Get Items action to retrieve data from another SharePoint list using ODATA Filtering.

Action works perfectly well in the case of the manual setup of Site Address and List name.

In case I will use Variable - String - containing the same site address I receive the error:

There's a problem

Cannot evaluate the parameter 'path.$.dataset' at design-time; it is empty or has a runtime expression.

Maybe you can advise if this is a bug, or I need to use a different format of the data.

[ArchitectMadhan]

Hi @SzymonBochniak ,

I have created a variable that has the SharePoint List name in it and its assigned to the SharePoint Get Items action properties, its working fine for me. In the variable the formula used is : string('Task Tracker').

Here is the Flow history showing successful execution.

If you find my solution helpful for resolving the issue, then please consider giving thumbs up and Accept it as the solution to help the other members find it more quickly.

[SzymonBochniak]

@ArchitectMadhan In your case, you did choose a site from the dropdown. I'm trying also to set the site using Variable. I checked your solution it does not work. Same error.

In my scenario, both parameters Site Address and List Name should be set by Variable.

[ArchitectMadhan]

Hi @SzymonBochniak ,

Could you show how you are setting the SharePoint url in the variable as value .

[SzymonBochniak]

The address is to OneDrive space: https://COMPANY.sharepoint.com/personal/sbochniak_COMPANY

This format works perfectly well for the actions:

• HTTP request to SharePoint
• SharePoint Delete item

[ArchitectMadhan]

Hi @SzymonBochniak,

I think you are missing the string function while Initializing the variable. Its working for me with the variable used for storing the SharePoint URL also. Please use

string('https://COMPANY.sharepoint.com/personal/sbochniak_COMPANY') while initializing the variable.

If you find my solution helpful for resolving the issue, then please consider giving thumbs up and Accept it as the solution to help the other members find it more quickly.

[ArchitectMadhan]

If you find my solution helpful for resolving the issue, then please consider giving thumbs up and Accept it as the solution to help the other members find it more quickly.

[SzymonBochniak]

Nope. Adding the string function to the initialization of the variable does not change anything in my case.

But I'm testing it a different way. I'm setting the site address and try to retrieve the available lists and then I'm getting the error.

[ArchitectMadhan]

Hi @SzymonBochniak ,

You are doing it in wrong way. Please use the expression builder and provide the url within the string function. Don't type the formula directly in the set variable value textbox. If you use the expression builder you will see the pink field with fx....

If you find my solution helpful for resolving the issue, then please consider giving thumbs up and Accept it as the solution to help the other members find it more quickly.

[SzymonBochniak]

@ArchitectMadhan thank for your support, but still the same error 😉

[ArchitectMadhan]

Hi @SzymonBochniak ,

I think you are trying to assign the Site URL variable in the place of SharePoint Site and tried to click the List name drop down, expecting to show the SharePoint Lists from that Site. If this is your expectation, it will not work because, During the design time with the Site URL variable it can not get the Site Context. So the solution is https://powerusers.microsoft.com/t5/General-Power-Automate/SharePoint-Get-Items-problem-with-Site-ad...

If you find my solution helpful for resolving the issue, then please consider giving thumbs up and Accept it as the solution to help the other members find it more quickly.