Answered

Filter & Search with Dataverse Table References

(0) Share

Report

Posted on by PAQA

Hello,

I am having difficulty combining the Search & Filter syntax. I have a table set up in the Dataverse that is titled "Job Details", and I originally set it up as searchable. Now I want to add an additional dropdown to help filter those records by day of the week. The formula looks like this;

Search(Filter([@'Job Details'], "crf63_dayofweek" = Dropdown2.Selected.Value || Dropdown2.Selected.Value = Blank()), SearchInput1.Text, "crf63_jobnumber","crf63_jobdescription","crf63_jobname")

When input, I don't have any delegation warnings or errors. However, when I select the day of the week with the dropdown, no records are returned. The search function is working properly and allowing me to search for the specified records.

Any help would be appreciated. I did manage to get this working for another gallery but the data source in that gallery was a SharePoint list instead.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Hi @PAQA,

In a Filter() you will not need the double quotes. Please try the code below, shou the dayofweek column give an error, try typing ThisRecord. and see what Power Apps recommends after the dot:

Search( Filter( 'Job Details', Dropdown2.Selected.Value = Blank() || ThisRecord.dayofweek = Dropdown2.Selected.Value ), SearchInput1.Text, //Make sure jobnumber is a text field for search to be delegable "crf63_jobnumber", "crf63_jobdescription", "crf63_jobname" )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
PAQA 5 on at

Like (0)

Report

Hello @LaurensM ,

Thank you for your quick response.

I input the snippet of code the way you worded things and I got the same results except this time I received a delegation warning. The records were still searchable but the dropdown caused everything to go blank.

The way that I got around it was to change the DayofWeek column within the table to a text input rather than a choice column. This combined with the wording you provided allowed both search and filter to be used in tandem. Sorry, I should have mentioned that Day of Week was a choice in the first place and you might have given the same result.

I appreciate the help!

Was this reply helpful? Yes No