Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Hello,
Can anyone plase help on above query?
Thanks
Avian
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |