Forum Discussion

Avih's avatar
Avih
Frequent Visitor
1 year ago
Solved

Query string on embed code in Power Apps

Hi All,

 

How can I use contain here instead of eq? no matter how I try it, it's not working.

The eq is working, but no matter how I try it with "contains", it's not working, it's just showing me all of the rows, instead of the filtered rows according to the Textsearchbox.

 

The embeded code that is working with eq:

 

Thanks!

Need Help

7 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    I don't think the Power BI implementation of OData supports "contains"  but you can try it

     

    Consider contains: $filter=contains(CompanyName,'Alfreds')

    In your case that would be  

     

    &filter=contains(table/column,'lookupvalue')

     

    Note that your table name has characters that need to be escaped.

    • Avih's avatar
      Avih
      Frequent Visitor
      1 year ago

      Unfortuantly it's still not working.
      Is there maybe any other way to overcome this?

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Avih ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you lbendlin for the prompt response. 

     

    Power BI implementation of OData might not support the "contains" function directly in the query string. However, you can try using the following format:

    &filter=contains(FACT_Tasks/TaskName, '" & Textsearchbox.Text & "')
    If this approach still doesn't work, you might need to  handle the filtering logic within Power Apps itself before passing the filtered data to Power BI.
     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    Regards,

    Rama U.

     

     

     

     

     

     

     

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Avih ,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

    Regards,

    Rama U.

     

    • Avih's avatar
      Avih
      Frequent Visitor
      1 year ago

      It didn't work unfortuantly.

  • v-venuppu's avatar
    v-venuppu
    Community Support
    1 year ago

    Hi Avih ,

    May I ask were you able to post this question over in the Power Apps community.If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.