1

I have several lists with the same fields names. I'm working on a flow that I need to re-use.

I want to be able to pass the site name and the list name dynamically to the flow.

So basically I would like to use same flow for all my lists. Is this possible?

2

3 Answers 3

2

Yes, it is possible to use the variables for SharePoint site address/URL and list names.

While using variables, you have to pass values to SharePoint connector actions using "Enter custom value" option.

Example:

Flow:

enter image description here

Action:

enter image description here

You can also consider using approaches mentioned here for using single Power automate flow for multiple SharePoint lists: Can we create a single Power Automate flow which trigger when uploading documents inside 50 document libraries

4
  • Thanks Ganesh.The question is how can I automatically pass the site address and list name from the list view when I need to trigger the flow
    – naijacoder
    Mar 21 at 7:03
  • Which trigger are you trying to use in your flow? Mar 21 at 7:19
  • Hi Ganesh, I use "when an item or a file is modified." Thanks
    – naijacoder
    Mar 22 at 3:41
  • Check link in my answer, you can create a single flow for each list where you can select site address and list name from flow editor and use child flow for reusable operations/actions. Call child flow from main flow on each list. Mar 22 at 6:07
0

Yes, it is possible. E.g. if you want to use action Get items, you have to use two variables. In the first variable you have to store site URL (in format https://tenantName.sharepoint.com/teams/siteName) and in the second you have store list GUID (from list properties). Then in the first choice of the Get items action (Site Address) select Enter custom value and insert first variable with URL. In the second choice (List Name) select Enter custom value as well and insert second variable with list GUID (really not list name, but list GUID).
Then when Flow runs it retrieves items from that list with corresponding URL and GUID. But be aware that in the next steps you cannot use columns from this action directly, because when you are creating your Flow, the designer does not know from which list you will be retrieving your data. So it cannot offer you right list schema. You have to use something like @{outputs('Get_items')?['body/value']}.

0

I have the same bug some times, you can solve it easyly. Add your url manually, "enter custom value" enter image description here then even if the message appear add the id of the list, save your flow and it will work

get the id in your list when you navigate in your list setting

SKIP %7B and %7D enter image description here

enter image description here

Save and it should be ok

The list ID should be replaced by the correct list title

enter image description here

http://fdi-sharepoint.e-monsite.com/blog/power-plateform/powerautomateweareunabletofindthesiteaddress.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.