cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

SharePoint List name from variable

I'm trying to create an item in a SP list using Flow. I want to select the List name from a variable or field from another SP list. There is the Custom Value option in the List name dropdown, but it doesn't seem to accept anything other than the actual list selected from the dropdown or the lists's GUID.

Googling around I can only see one possibility, and that's a HTTP call. Seems a bit long winded.

Can anyone suggest another way?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: SharePoint List name from variable

Hi @Ric835 

 

create item is different since it needs the context of the list at design time

Your only option in this case would be to use http sharepoint action and use rest api to post/create item

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

3 REPLIES 3
Highlighted
Dual Super User
Dual Super User

Re: SharePoint List name from variable

Hi @Ric835 

 

Capture.PNG

 

This should work

 

You can also query any other list to get the list name and put it in variable and use it directly

 

Note: when adding variable make sure to select enter custom value in the List Name dropdown

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

 

Highlighted
Frequent Visitor

Re: SharePoint List name from variable

That works for Get items as you've shown, but I'm trying to do Create item.

If I paste the variable in, I get the error "Cannot evaluate the parameter 'path.$.table' at design-time; it is empty or has a runtime expression."

Highlighted
Dual Super User
Dual Super User

Re: SharePoint List name from variable

Hi @Ric835 

 

create item is different since it needs the context of the list at design time

Your only option in this case would be to use http sharepoint action and use rest api to post/create item

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,484)