Gallery/collection not visible when record is initially selected/viewed in customized form (X-post)

%3CLINGO-SUB%20id%3D%22lingo-sub-1143263%22%20slang%3D%22en-US%22%3EGallery%2Fcollection%20not%20visible%20when%20record%20is%20initially%20selected%2Fviewed%20in%20customized%20form%20(X-post)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1143263%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20a%20customized%20form%20that%20uses%20two%20lists.%26nbsp%3B%20The%20primary%20list%20is%20a%20bunch%20of%20requests.%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EEach%20item%2Frequest%20in%20the%20primary%20list%20has%20cooresponding%20records%20in%20the%20secondary%20list.%26nbsp%3B%20When%20you%20view%20a%20request%20(in%20the%20primary%20list)%2C%20the%20cooresponding%20records%20from%20the%20secondary%20list%20should%20display%20in%20a%20gallery%20at%20the%20bottom%20of%20the%20customized%20form.%26nbsp%3B%20However%2C%20what's%20been%20happening%20when%20you%20click%20on%20a%20request%20is%2C%26nbsp%3B%20the%20form%20displays%2C%20but%20the%20gallery%20does%20not.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20889px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F168327iD51D9FBE38D99DFA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22SSscreenshot1.png%22%20title%3D%22SSscreenshot1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThere%20are%20actually%20two%20scenarios%20where%20the%20gallery%2Fcollection%20does%20not%20display.%26nbsp%3B%20The%20first%20is%20from%20the%20SPO%20home%20page.%26nbsp%3B%20I%20have%20a%20web%20part%20that%20displays%20the%20primary%20list.%26nbsp%3B%20If%20you%20click%20on%20a%20record%2Frequest%2C%20it%20opens%20a%20new%20webpage%20for%20the%20form%2C%20but%20the%20gallery%20isn't%20visible.%26nbsp%3B%20If%20you%20go%20back%20to%20the%20home%20page%20and%20click%20the%20same%20record%20again%2C%20the%20gallery%20still%20does%20not%20render.%26nbsp%3B%20The%20second%20occurs%20if%20you're%20in%20the%20primary%20list%2C%20and%20select%20a%20record.%26nbsp%3B%20The%20form%20opens%20from%20the%20side%20of%20the%20screen%2C%20but%20the%20gallery%20is%20not%20visible.%26nbsp%3B%20If%20you%20click%20X%20or%20click%20away%20to%20close%20the%20form%2C%20then%20click%20on%20the%20same%20record%20again%2C%20the%20gallery%20becomes%20visible.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20890px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F168328iDED93094C6FDD699%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22SSscreenshot2.png%22%20title%3D%22SSscreenshot2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3BI%20really%20don't%20understand%20this%20behavior.%26nbsp%3B%20What%20is%20different%20between%20the%20initial%20click%20versus%20the%20following%20click%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1143263%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1144071%22%20slang%3D%22en-US%22%3ERe%3A%20Gallery%2Fcollection%20not%20visible%20when%20record%20is%20initially%20selected%2Fviewed%20in%20customized%20form%20(X-po%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1144071%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437254%22%20target%3D%22_blank%22%3E%40LumberjackLurchMS%3C%2FA%3E%26nbsp%3Bwhat%20is%20the%20syntax%20of%20the%20filter%20you%20are%20using%20to%20filter%20the%20second%20list%20based%20on%20the%20selection%20in%20the%20first%20list%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1144225%22%20slang%3D%22en-US%22%3ERe%3A%20Gallery%2Fcollection%20not%20visible%20when%20record%20is%20initially%20selected%2Fviewed%20in%20customized%20form%20(X-po%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1144225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%2C%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20%3CEM%3EOnStart%3C%2FEM%3E%20property%2C%20I%20have%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EClearCollect(col_AllRequests%2C%20SortByColumns(SalesRequestsForm%2C%20%22ID%22%2C%20Descending))%3B%3C%2FP%3E%3CP%3EClearCollect(col_AllItems%2C%20SortByColumns('Sales%20Item%20List'%2C%20%22ID%22%2CDescending))%3C%2FP%3E%3CP%3E-----------------------------------------%3C%2FP%3E%3CP%3EIn%20the%20%3CEM%3EOnView%3C%2FEM%3E%20property%2C%20I%20have%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESet(var_selectedRecord%2C%20SharePointIntegration.Selected)%3B%3C%2FP%3E%3CP%3EClearCollect(col_ItemView%2C%20ShowColumns(Filter(col_AllItems%2C%20var_selectedRecord.ID%20in%20'Request%20ID')%2C%20%22ItemName%22%2C%20%22ItemDescription%22%2C%20%22ItemQuantity%22))%3C%2FP%3E%3CP%3E------------------------------------------%3C%2FP%3E%3CP%3EIn%20the%20%3CEM%3EItems%3C%2FEM%3E%20property%20of%20the%20gallery%2C%20I%20have%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecol_ItemView%3C%2FP%3E%3CP%3E------------------------------------------%3C%2FP%3E%3CP%3EFyi%2C%20the%20'Request%20ID'%20column%20is%20a%20column%20in%20the%20'Sales%20Item%20List'%20and%20is%20populated%20using%20a%20Patch%20statement%20when%20a%20record%20in%20the%20'SalesRequestForm'%20list%20is%20created.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1148780%22%20slang%3D%22en-US%22%3ERe%3A%20Gallery%2Fcollection%20not%20visible%20when%20record%20is%20initially%20selected%2Fviewed%20in%20customized%20form%20(X-po%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1148780%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a customized form that uses two lists.  The primary list is a bunch of requests.  Each item/request in the primary list has cooresponding records in the secondary list.  When you view a request (in the primary list), the cooresponding records from the secondary list should display in a gallery at the bottom of the customized form.  However, what's been happening when you click on a request is,  the form displays, but the gallery does not.

 

SSscreenshot1.png

 

There are actually two scenarios where the gallery/collection does not display.  The first is from the SPO home page.  I have a web part that displays the primary list.  If you click on a record/request, it opens a new webpage for the form, but the gallery isn't visible.  If you go back to the home page and click the same record again, the gallery still does not render.  The second occurs if you're in the primary list, and select a record.  The form opens from the side of the screen, but the gallery is not visible.  If you click X or click away to close the form, then click on the same record again, the gallery becomes visible.

 

SSscreenshot2.png

 

 I really don't understand this behavior.  What is different between the initial click versus the following click?

3 Replies

@LumberjackLurchMS what is the syntax of the filter you are using to filter the second list based on the selection in the first list?

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott

In the OnStart property, I have: 

 

ClearCollect(col_AllRequests, SortByColumns(SalesRequestsForm, "ID", Descending));

ClearCollect(col_AllItems, SortByColumns('Sales Item List', "ID",Descending))

-----------------------------------------

In the OnView property, I have:

 

Set(var_selectedRecord, SharePointIntegration.Selected);

ClearCollect(col_ItemView, ShowColumns(Filter(col_AllItems, var_selectedRecord.ID in 'Request ID'), "ItemName", "ItemDescription", "ItemQuantity"))

------------------------------------------

In the Items property of the gallery, I have:

 

col_ItemView

------------------------------------------

Fyi, the 'Request ID' column is a column in the 'Sales Item List' and is populated using a Patch statement when a record in the 'SalesRequestForm' list is created.