Here's the updated code but it's still not working..
Filter('Task List',Title in ClientCB.SelectedItems.Title, Preparation_Status in StatusCB.SelectedItems.Preparation_Status),
Filter('Task List',(Title in ClientCB.SelectedItems)||(Preparation_Status in StatusCB.SelectedItems)))
@yashag2255 - it's now working perfectly! many thanks! May I ask for another thing please, how can i have the combobox filter showing only the unique values? When i tried using Distinct in the comboxbox (Distinct('Task List',Preparation_Status).Result), the formula will not work
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand