Can someone guide me,
I've two galleries one primary and one secondary nested gallery.
Gallery one pulls data from one sharepoint list1 and nested gallery brings in data from 2nd sharepoint list2 .
Looking at the screenshot, for this Gallery 1 we have set filter with date range dropdown controls and searchboxes to isolate the right records. sharepoint list 1 is related to via column name "master Id" in 2nd sharepoint. I need to export the data of gallery 1 and related gallery 2 items to excel. I was thinking of using collection but i'm not sure how to go about. Am i supposed to have two separate collection for each collection and then merge into one collection for the export. I was looking at reza dorrani video's on excel export but i got stuck with the collection part. Can someone help?
Solved! Go to Solution.
Hi @chand72 ,
According to your description, I did a simple test for you.
1\ This is my ‘ParentList’. ‘Test’ is a Single line of text column.
2\ This is my ‘ChildList’.
3\ Add a gallery control and set its Items property to:
4\ Insert a gallery control into first gallery control and set its Items property to:
6\ Add a button control and set its onselect property to:
ClearCollect(ColCollection_1,ShowColumns(Gallery1.AllItems,"Title","Test","ID")); ClearCollect(ColCollection_2,ShowColumns(ChildList,"Title","MasterID")); ClearCollect(ColCollection_3,AddColumns(ColCollection_1,"ChildTitle",Filter(ColCollection_2,MasterID=ID).Title))
7\ The result is as follows:
If you want to expand the collection, please try to add another button control and set its onselect property to:
If my post helps, then please consider Accept it as the solution to help others. Thanks.
I was not able to create the third collection, pasted error here. Invalid argument. MasterID column my 2nd sharepoint list is a ordinary number column but used as lookup for the 1st sharepoint list.
Ok i managed to fix this by adding ID Into the collection 1 like this so error gone but looking at the collection data data is missing from the first collection , and third collection. I dont see the complete list. Collection 3 is totally wrong data displayed.
Managed to figure out by comparing my two sharepoint lists, collection 1 first 5 records didn't have data in balance column which is correct and collection 2 didn't have data for the first five records under those highlighted columns from the screenshot. However I can't figure out why collection 3 is not showing the right data for the 5 records, it keeps repeating the collection 2 header names. Can someone help me?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.