How read the sharepoint url and combine and then select a common list

[Avian]

Hello,

I have one sharepoint table where we have all the site collection url. CUrrently there are 5 collections and future more site collection can be add in the table.

I want to read all the SharePoint URL from the table and then combine all the site collectiions and then select a particular list for example Invoice, which is exist in each site collection and structure are same.

How can this can be achieve using the query? If anyone can provide the sample solution , it would be really helpful?

Regards

Avian

[v-xinruzhu-msft]

Hi @Avian 

You can connect to one url first by using web connector, then change the code to a funciton.

e.g 

(a as text)=>
let
    ....
in
    ....

Then use the function in table by adding invoke custom function.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Avian]

Hello 

Thanks for response, is it possible to share some sample where after pulling the sites from table as you mentioned above how can we connect to those sites ?

Regards

Avi