Hello
IN Hub site, I have so many site collections and one list i.e. Attendence exist in each site collection with same structure. I want to read the data from Attendence list from all sharepoint sites. currently there are 15 site collections, in future this can be incerased. So I created a list i.e. CombineSites which containing the site utl all those sites which Attendence list. So whenever new site cerated, I will add the url in this list.
Current I did hardcoded as and leter I filtered list with Attendance and expanded table. I am geting all the result.
= Table.Combine(
{
SharePoint.Tables("https://mydomain.sharepoint.com/sites/PtestSite1", [ApiVersion = 15]),
SharePoint.Tables("https://mydomain.sharepoint.com/sites/PtestSite", [ApiVersion = 15])
}
)
Hub URL is "https://mydomain.sharepoint.com/Ptest".
How can I read the url from Attendance list and combine the tables ?
Regards
Avi
How can I run thru loop
