Share
Report
299Morning All,
Is it possible to filter three SharePoint lists in a single Gallery? I'm building an Invoice app and would like to display the invoice items in a single gallery and create a PDF with that data. The Invoice app has three repeating sections for the invoice items and three separate SharePoint lists for those items. I currently have three galleries that display the data from each of the repeating sections.
PrinFormRC_1 > SharePoint list = TestInventoryRectangle1; Item = varInventoryRC
HTMLRectangle gallery > Items = Filter(TestGalRectItems, MasterID = varInventoryRC.ID)
HTMLStainless gallery > Items = Filter(TestStainlessSteelItems, MasterID = varInventoryRC.ID)
HTMLMisc gallery > Items = Filter(TestMiscItems, MasterID = varInventoryRC.ID)
I'm attempting to display the invoice items in a single gallery and not succeeding. I found the solution below in a PowerUsers article, but it gives me a delegation warning.
AllItemsGallery gallery > Items = Filter(TestGalRectItems, (MasterID in TestStainlessSteelItems.MasterID), (MasterID in TestMiscItems.MasterID))
AllItemsGallery > Labels >
lblAllIDs > Text > Display MasterID for corresponding item from each SP list
lblAllCodes > Text > Display Code number for corresponding item from each SP list
lblAllFittings > Text > Display Fitting description for corresponding item from each SP list
lblAllPrices > Text > Display Price for corresponding item from each SP list
lblAllQty > Text > Display Quantity for corresponding item from each SP list
lblAllCost > Text > Display Cost for corresponding item from each SP list
I've tried an If statement, LookUp statement and Filter statement and all return errors. Any help you can offer is deeply appreciated.
PLove
All responses (
Answers (
