Hello Team,
I have a dropdown and whatever value user selects, I want to do the datatable (source is SQL) fileting based on contains logic.
Meaing, If the user selects "ABC" in dropdown, I want the datatable to display all the records where SQL column CONTAINS "ABC".
I'm thinking to use IsMatch function something like IsMatch(Dropdown.SelectedText.Value,SQLColumn,Contains)) but It's not working. It says systex issue.
Also Once I got the contains values, I want to AND those results with another SQL table.
Please suggest. Thank you.
Solved! Go to Solution.
Team - Nerver mind. I got the solution. Here is below that did the trick.
Filter(SQLTable,Column1="YES" && Dropdown.SelectedText.Value in column2)
Thanks.
Team - Nerver mind. I got the solution. Here is below that did the trick.
Filter(SQLTable,Column1="YES" && Dropdown.SelectedText.Value in column2)
Thanks.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
200 | |
171 | |
62 | |
32 | |
31 |
User | Count |
---|---|
339 | |
269 | |
105 | |
71 | |
56 |