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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,497)