cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ogh_sabyasachi
Helper III
Helper III

How can we filter PowerBIIntegration data?

 

 

I have shared two columns of a table with powerapps as follows.

 

Name Course Name
ABCD
BABCD
AEFGH
AJKLM
BEFGH

 

I have the name here (First([@PowerBIIntegration].Data).Name).  Can we filter the course names in anyway so that we can get the table in the app as follows.

 

Suppose the table for A should look as follows:

 

ABCD
EFGH
JKLM

 

It has to be embed in an html text to be sent via mail.

 

Please help... Thanks.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @ogh_sabyasachi ,

Do you want to filter your table records in your embedded canvas app based on the passed PowerBIIntegration data?

 

I have made a test on my side, please consider take a try with the following workaround:

Firstly, you need to add your Power BI report dataset as data source in your embedded canvas app.

Add a Gallery in your embedded app, set the Items property to following:

Filter(
       Table,
       Name = First([@PowerBIIntegration].Data).Name
)

If you want to select multiple selections in your Power BI report, and want to filter your table records based on the passed multiple records in your embedded app, please modify above formula as below:

Filter(
       Table,
       Name in [@PowerBIIntegration].Data.Name
)

 

Add a Label inside the Gallery, set the Text property to following:

ThisItem.'Course Name'

 

 

For your second question, if you want to embed above filtered table result in a HTML text and send it via email, please check and see if the following blog would help in your scenario:

https://powerapps.microsoft.com/en-us/blog/html-email-reporting-with-tabular-data/

On your side, please try the following HTML text in your embedded canvas app:

"<strong> Items: </strong>" &
"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
     "<tr style='background-color:#efefef' >
         <td> Name </td> <td> Course Name </td>
     </tr>
     " &
         Concat(
                Filter(Table,Name in [@PowerBIIntegration].Data.Name),
                "<tr><td>" & Name & " </td>
                <td>" & 'Course Name' & " </td></tr>") &"
</table>"

 

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xida-msft
Community Support
Community Support

Hi @ogh_sabyasachi ,

Do you want to filter your table records in your embedded canvas app based on the passed PowerBIIntegration data?

 

I have made a test on my side, please consider take a try with the following workaround:

Firstly, you need to add your Power BI report dataset as data source in your embedded canvas app.

Add a Gallery in your embedded app, set the Items property to following:

Filter(
       Table,
       Name = First([@PowerBIIntegration].Data).Name
)

If you want to select multiple selections in your Power BI report, and want to filter your table records based on the passed multiple records in your embedded app, please modify above formula as below:

Filter(
       Table,
       Name in [@PowerBIIntegration].Data.Name
)

 

Add a Label inside the Gallery, set the Text property to following:

ThisItem.'Course Name'

 

 

For your second question, if you want to embed above filtered table result in a HTML text and send it via email, please check and see if the following blog would help in your scenario:

https://powerapps.microsoft.com/en-us/blog/html-email-reporting-with-tabular-data/

On your side, please try the following HTML text in your embedded canvas app:

"<strong> Items: </strong>" &
"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
     "<tr style='background-color:#efefef' >
         <td> Name </td> <td> Course Name </td>
     </tr>
     " &
         Concat(
                Filter(Table,Name in [@PowerBIIntegration].Data.Name),
                "<tr><td>" & Name & " </td>
                <td>" & 'Course Name' & " </td></tr>") &"
</table>"

 

Please consider take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much.  @v-xida-msft 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,447)