Power Platform Community Forum Thread Details

Hello! I'd really appreciate your expertise in figuring out this delegation issue around the And() function. I am trying to create this collection based on a set of 3 choice combo boxes (Measure1,2,3) that the user chooses and this additional Measure (5) that is already populated. Measure4 is just the name column. My data is coming from the dataverse and I have changed the row limit to 2000. The formula works well and we should not have more than 2000 entries but I am hoping to fix the delegation issue in case we do end up having more entries.

Thank you so much in advance!

ClearCollect(
 colGalleryUpdates,
 ForAll(
 Filter(
 'Table A',
 And(
 Or(
 
 Measure1 in 'Measure 1 Cb_1'.SelectedItems
 ),
 (Or(
 
 Measure2 in 'Measure 2 Cb_1'.SelectedItems
 )),
 (Or(
 'Measure3'in'Measure 3 Cb_1'.SelectedItems,
 Text('Table B'.'Measure5') = "Always Left",
 Text('Table B'.'Measure5') = "Always Right"
 ))
 )
 ),
 {
 Measure1: ThisRecord.Measure1,
 'Measure3': ThisRecord.'Measure3',
 'Measure4': ThisRecord.'Measure4'
 }
 )
);