You’re offline. This is a read only version of the page.
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!
Share
Report
15ClearCollect(
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'
}
)
);
Hello,
You can break down your formula into smaller steps and try to delegate as much as possible. Here's a modified version of your formula with some potential adjustments (not tested):
All responses (
Answers (ClearCollect(
colGalleryUpdates,
Filter(
'Table A',
Or(
Measure1 in 'Measure 1 Cb_1'.SelectedItems,
Measure2 in 'Measure 2 Cb_1'.SelectedItems,
'Measure3' in 'Measure 3 Cb_1'.SelectedItems,
'Measure5' = "Always Left",
'Measure5' = "Always Right"
)
)
);
Filter(
colGalleryUpdates,
And(
Or(
Measure1 in 'Measure 1 Cb_1'.SelectedItems,
Measure2 in 'Measure 2 Cb_1'.SelectedItems
),
Or(
'Measure3' in 'Measure 3 Cb_1'.SelectedItems,
'Measure5' = "Always Left",
'Measure5' = "Always Right"
)
)
)
