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

Dynamic choice of which Sharepoint list

Hi, hope you can help a chap pretty new to Flows.

 

I'm trying to create a flow that adds data from Forms to several Sharepoint lists - up to 14 rows across 7 lists.  Which list it will go to depends upon a choice in the Forms input.  When I use the Create Item action with a Concat expression in the List Name it of course can only bring up the standard Item column for the List.  Is there a way to interrogate the appropriate List to get all the columns and bring that information into Create Item?  Or - as I already know their structure - to send the data to the list in another way?

flow.png

Thank you for reading my query. I look forward to hearing your advice.

1 ACCEPTED SOLUTION

Accepted Solutions
v-chengfen-msft
Microsoft
Microsoft

Hi @IanH ,

 

Do you mean create a Item with a dynamic list/site?
Therefore, instead of [Create item] , you should create an HTTP request.
I've made a test for your reference:

Add [Get Response details]

 

vchengfenmsft_0-1663839771985.png

Here is a link for your reference:

https://tomriha.com/http-request-to-create-sp-item-in-dynamic-list-site-with-power-automate/

 

Best Regards

Cheng Feng

View solution in original post

2 REPLIES 2
v-chengfen-msft
Microsoft
Microsoft

Hi @IanH ,

 

Do you mean create a Item with a dynamic list/site?
Therefore, instead of [Create item] , you should create an HTTP request.
I've made a test for your reference:

Add [Get Response details]

 

vchengfenmsft_0-1663839771985.png

Here is a link for your reference:

https://tomriha.com/http-request-to-create-sp-item-in-dynamic-list-site-with-power-automate/

 

Best Regards

Cheng Feng

IanH
Frequent Visitor

Many thanks, Cheng Feng, that looks like exactly what I need 🙂 I shall add that in now 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,215)