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

SharePoint create item with a dynamic url

Hey all

 

I am trying to create an item in a SharePoint list with some dynamic content.

 

So when an item is created in a list (customers) with a column (store), i would like to create this item in a subsite which also has a list (ShopCustomers) but depending on the store the item will be created in a diffrent subsite.

 

I was wondering if this is possible? Because if i add dynamic content to the site url at this moment i can't select a list name which makes it impossible to publish the flow

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Hi @AlexanderRutten,

 

I don't think you can dynamically set the site url.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

11 REPLIES 11
Highlighted
Super User III
Super User III

Hi @AlexanderRutten,

 

I don't think you can dynamically set the site url.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

Highlighted

Hey @abm

 

Are you sure, because you can add dynamic content to the site url in flows. Or is it just on the 'todo' list of microsoft maybe?

Highlighted

Hi @AlexanderRutten,

 

For create item template how does it populate dynamically the column names if we specify the dynamic URL and list name? Based on that assumption I thought it is not possible. I might be wrong here.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Highlighted

hey @abm

 

In theory it should work like i worked it out in the example below. The problem is the dynamic content does not contain a value so it's not really a site url yet so you can't select a list ... maybe microsoft will work this out in the future.

 

 

2016-11-23 08_08_44-Manage your flows _ Microsoft Flow.png

Highlighted
Anonymous
Not applicable

Does anyone have an update on this?

 

It makes sense that Flow can't determine what the list columns are at design time, but it would be great if we could pass a dynamic URL and list name with static column values to create/update an item.

 

For context I'm trying to do this on publish for Project Online project sites, and would like to create a number of items in a list using data from enterprise custom fields.

Highlighted
New Member

Trying to accomplish the same thing. Any updates?

 

Highlighted
Kudo Kingpin
Kudo Kingpin

I am totally supportive to request this capability. From enterprise perspective  It should be possible to create the “Schema” based on a actual list and then export the list configuration and the flow to other sites, and be able to make the new instance work with minimal configuration changes. (We don’t want to have every user to have to reconfigure each create item or update item Step, do we?)

 

I want to define the site url and the list name / id in the beginning of the flow and then refer to these variables in subsequent steps.

 

this seems not possible today as far as I can see

Highlighted

This is not solved

Highlighted
Advocate I
Advocate I

Any workaround for this ?

 

I am creating a SharePoint list using Plumsail SP connector in MS flow which works fine. I have another flow that will try to create new item in that SharePoint list. 

 

As the list is not created at the time of setting up the MS flow, the create Item action is not populating the list column to be updated.

 

 

Highlighted

I am also interested to see where this goes. Any updates?

Highlighted

I suspect that a work around for this issue might be to directly call a SharePoint web service from within Flow and create the list items via the web service.

 

Here is a link to a blog that discusses how to update an item via a webb service - this should get you pointed in the right direction.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (7,152)