Share
Report
7I'm working with a custom dataverse table named Items which has an OOB N:N relationship with a custom table named "Tags".
Presently I am able to filter on the the relationship, but I am wondering if I am missing a step to potentially avoid delegation.
I've worked from the basis of @WarrenBelz 's blog on N:N to filters and customised it to my needs.
ClearCollect(
colGrouped,
GroupBy(
Filter(
Ungroup(
AddColumns(
Items,
"MyTags",
ThisRecord.Tags.Tag
),
"MyTags"
),
contoso_tag in ForAll(
cboTag.SelectedItems,
Tag
)
),
"contoso_taskid",
"grp"
)
)
Everything works as intended (formatting may be wrong in the code above, but is correct in the app!)
What I can't eliminate is the blue line warning under the AddColumns on ThisRecord.Tags.Tag.
I'm partly resigned to living with this, but if I can negate it then all the better.
Any suggestions?
Categories:
All responses (
Answers (
