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?
Thank you for reading my query. I look forward to hearing your advice.
Solved! Go to Solution.
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]
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
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]
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
Many thanks, Cheng Feng, that looks like exactly what I need 🙂 I shall add that in now
User | Count |
---|---|
89 | |
40 | |
22 | |
20 | |
16 |
User | Count |
---|---|
136 | |
55 | |
47 | |
36 | |
25 |