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

bringing a table from powerBI to powerApp html text

 

I have two table visuals in one report as follows.

 

TableVisual1:

Name of the courses

XYZ

MNO

 

Here, we are using NameOfCourses from DataTable - 3.

 

TableVisual2:

ID

MemberName

11

John Doe

22

Jane Doe

 

Here, we are using ID and member name from from the DataTable - 1.

 

Whenever I select one ID in TableVisual2, it shows me the name of courses completed in TableVisual1 with regard to that particular ID.

 

 

DataTable - 1

ID    NAME

 

1         X

2         Y

3         Z

 

DataTable - 2

ID         COURSE_ID

 

1            M                   

2            N                   

3            O                   

1            N                   

2            M                 

 

DataTable - 3

COURSE_ID     COURSE NAME

M                       EFGH

N                        JKLM

0                        OPQR

 

 

 

The relationships are as follows:

TABLE 2 -> many to one -> TABLE 1

TABLE 2 -> many to one -> TABLE 3

 

 

Can we share these columns of various DataTables and create a table similar TableVisual1 in a html text that can be used with the Office365Outlook.SendEmail() and sent via mail?

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: bringing a table from powerBI to powerApp html text

Hello,

 

I am not aware if you can call the data tables from PowerBI, but how does your data table gets populated in powerBI ? May be you can try calling the data source in Power App directly and then add the logic accordingly.

 

 

Highlighted
Helper II
Helper II

Re: bringing a table from powerBI to powerApp html text

Yes.   This was helpful.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,881)