Let’s consider the formula for filtering the above two using a multi-select combo box.
※When nothing is selected, all items are displayed.
To check if delegation is effective, set the data row limit to 3.
If delegation is working→Items ‘ddd’ and ‘eee’ will still be displayed after filtering.
For more about delegation and data row limits, visit here:
The simplest formula would look like the image below, but unfortunately, when using a SharePoint list as the data source, it falls under the limitations of delegation.
To filter with multiple values while respecting delegation, it seems we must resort to a formula like the one in the following image. It’s important to note, as a caution, that filtering is possible only for the first N selections.
※In the example below, filtering is possible for the first three selections.
※Note that the formula below does not work for the gallery.
This is probably because when SelectedItems is zero or similar, accessing the item with the Index function causes an internal error.
Case for Dataverse
In the case of Dataverse, the simple formula shown in the image below works perfectly with the delegation function.
Filter(SampleTable,
IsBlank(ComboBox1_1.SelectedItems) || IsEmpty(ComboBox1_1.SelectedItems) ||
Name in ComboBox1_1.SelectedItems.タイトル
)
Dataverse is indeed very convenient.
Bonus: When ComboBox Choices Reference a Master Table
When defining choices as a master, like in the image below,
The formula for the SharePoint list gallery becomes as follows,
コメント