I do not have to fetch everything all at once - and the 500 item limit would hit me. But, in some circumstances I would like to dig deeper while showing a higher level.
In the example below, ComboBoxClients is a single-select combobox to choose the client_id, to show all contracts.
In the case of client_contract_cycles, each has a handful of client_contract_cycles_products, not dozens or hundreds. When showing a gallery or table of client_contract_cycles, I would like to show every product of each cycle, from client_contract_cycles_products.
This would give you a Gallery with all of the items from the contract cycles that match the cleint ID chosen with an added column of records from the cycles_products table.
Then you can put a sub Gallery in your Gallery and set its Items property to : ThisItem.CycleProducts
Since you are working with SQL tables, the delegation should not be an issue with the = operator. And, with this, you will not have the overhead of a Collection and the constant refreshing of the Collection you have to do to maintain the data accurately.
Just a suggestion to consider...I hope it fuels some thought.
_____________________________________________________________________________________ Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Could you please share a screenshot about the Delegation warning within your formula?
Further, could you please share a bit more about the client_id, client_certification_id and client_contract_cycles_id that you mentioned? Are they both int type column or text type column in your SQL Table?
Based on the formula that you provided, I think there is something wrong with it. Please modify your formula as below:
ClearCollect( client_contract_cycles_col; Filter('[dbo].[client_contract_cycles]'; client_id = ComboBoxClients.Selected.client_id) );;
ForAll( client_contract_cycles_col; /* <-- Please type client_contract_cycles_col collection here rather than client_contract_cycles_products_co that you mentioned */
Filter('[dbo].[client_contract_cycles_products]'; client_contract_cycles_id = client_contract_cycles_col[@client_certification_id])
Please take a try with above formula, then check if the issue is solved on your side.
Note: The client_certification_id represents a column in your '[dbo].[client_contract_cycles]', which relates to the client_contract_cycles_id column in your '[dbo].[client_contract_cycles_products]'.
Community Support Team _ Kris Dai If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.