Forum Discussion

DJTentman's avatar
DJTentman
Frequent Visitor
3 years ago

Use URL filter to search multiple fields

I'm creating a web page that pops up when there is an incoming call to show customer records based on the caller ID. However, I need to search multiple phone number fields. I have several ideas, but I've not been able to make any of them work:

 

  1. Concatenate all phone numbers into one field and use CONTAINS. However, URL filters don't have a CONTAINS function
  2. Use OR. "Phone 1" eq 'xxx-xxx-xxxx' OR "Phone 2" eq 'xxx-xxx-xxxx'. However URL filters don't support OR

How could I accomplish something like this?

Need Help

2 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    Hi DJTentman ,

     

    You can use URL Filters to provide different report views. For example, the URL below filters the report to show data for the Energy industry.

    Using the combination of pageName and URL Filters can be powerful. You can build experiences using basic HTML and JavaScript.

     

    For more information, please refer to: Embed a report in a secure portal or website - Power BI | Microsoft Learn

     

    Best regards,

    Yadong Fang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • DJTentman's avatar
    DJTentman
    Frequent Visitor
    3 years ago

    Thanks for the links. However, I did already read those, and they did not help with the issue I described.