Unanswered

One Flow to update 4-6 Sharepoint Lists depending on the Trigger.

(0) Share

Report

Posted on by localadminbcs

Hello all.

I have 6 SPLists, all of them have the same columns just data from different offices. Right now I am doing a Get Items for all 6 lists and duplicating all of the functions that are needed for the list when called on by the Trigger.

Ex. Trigger =List1. > Condition If Trigger is "List 1" run all the commands in that row, if Trigger is "List 2", run all the commands in that row but on SPLists 2.

How can I set it so I can just have 1 column of commands and have the list switch according to the Trigger? Right now as my locations keep growing I will have to recreate a new column of commands for each location, which could grow to 15-20 locations/ SPLists/Columns of commands.

Any thoughts?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

wskinnermctc 6,519 Moderator on at

Like (1)

Report

How are you getting the trigger to work on separate sharepoint lists?

Can you show a screenshot of what you have to help give a better idea of the current design of the flow.

Was this reply helpful? Yes No
localadminbcs 10 on at

Like (0)

Report

Right now, the trigger is a manual input.
User enters "List1" or "List 2" or "List"3 or etc...
Condtion; IF Trigger = "List 1", then do all the actions in column 1
Condtion; IF Trigger = "List 12", then do all the actions in column 2
etc
All of the actions in each column are the same, just done on different SP Lists.
I dont want to have to re-create another 8, 10, 15 columns do to the exact same thing on different SPLists.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report

I think what you are trying to achieve can be done by using a HTTP request. You will need to have the Site Address and the List Title.

Use the Site Address and List Title in the HTTP Request to return the list id. You can then use the id in something like Get Items.

This is a basic example of how it works. Since I don't know anything else about your flow, I'm showing this to give you an idea of how it starts.

Does this approach seem like something you could do?

Was this reply helpful? Yes No
localadminbcs 10 on at

Like (0)

Report

Awesome approach! I am going to build it today and let you know how it goes. Great work, thank you so much. I will update you all on this,

Was this reply helpful? Yes No
localadminbcs 10 on at

Like (0)

Report

Awesome!! I created this as you explained and it does do exactly what I needed. Thank you for the guidance!

Was this reply helpful? Yes No