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

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
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
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

Thank you very much.  @v-xida-msft 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,928)