13
Hi
I have a sharepoint list as below
Name Rep_Area Report
abcd PowerBI abcd
efgh Sales efgh
hijk Finance hijk
Here i want to show all Report where Rep_Area = PowerBI in a combo box.
I use the below but it should all Report not just where Rep_Area = PowerBI
Filter(Distinct('listname', Report), "PowerBI" in 'listname'.Rep_Area)
Any help?
Your formula should first filter and then apply distinct to get unique Reports
Try this
Share
Report
All responses (
Answers (
Distinct(Filter('listname', Rep_Area = "PowerBI"), Report)
