Share
Report
88This message board has greatly assisted me with achieving what I need! I of course have more questions...mostly as a followup to my prior inquiries. I accepted this solution as it was working great when multiple items from a list are selected, but when I came across 1 item being selected from a multi select list, the formula doesn't identify the single value. I assume it's because the concat formula adds a comma, and therefore searches for Value, ; which the comma isn't assigned in the actual list. How would I edit the below formula to not apply a comma when a single value is identified in the list?
Filter('Business Reviewers', Concat('Line(s) of Business', Value & ", ") in Concat(DataCardValue2.SelectedItems, Value & ", ") && Concat('Product(s)', Value & ", ") in Concat(DataCardValue3.SelectedItems, Value & ", "))
Business Reviewers = Source list
Line(s) of Business = category 1 within said source list, multi select lookup value (DataCardValue2)
Product(s) = category 2 within said source list, multi select lookup value (DataCardValue3)
All responses (
Answers (
