Forum Discussion
Gallery/collection not visible when record is initially selected/viewed in customized form (X-post)
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
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.
Anyone?