cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bansay
Level: Powered On

PowerApps and graph Power Bi

Hello;

 

I have a PowerApps application and I would like to make a Power Bi graph in this application.

In my application I have a SharePoint list containing homeworking requests by user.

In my application, the user can only see his requests because I have a condition that test on the name of the user and the account with which he is connected. ==> Property Visible => [IF Requester.Email = User().Email;]


I would like to have graph by user that when he clicks a button he obtains this graph : 

A graph wih on one axis the number of "homeworking days"/month and on the other axis (the months of the year) ?

The Status for the request must be approved to add day on graph (chart bars)

 

For exemple : Result for Person "XYZ" => 4 days on April, 3 days on September,... 

 

1) How is it possible to make this graph ? Send list information with Power Flows to Power Bi ?

2) How with the information is it possible to realize this graph ?

 

The List SharePoint  : 

Capture1.PNG

Thanks for your help ! 🙂

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: PowerApps and graph Power Bi

Hi @bansay ,

Could you please share a bit more about your scenario?

Do you want to embed a Power BI report into your app?

 

If you want to embed a Power BI report into your app, you need to create a report within your Power BI based on your SP List data source firstly, then pin the Report to a specific dashboard.

After that, within your app, add a Power BI tile control, then specify the workspace, dashboard and Tile from your Power BI, then the report would be displayed in your app.

Please check the following article for more details:

https://powerapps.microsoft.com/en-us/blog/power-bi-tile-in-powerapps/

https://www.inogic.com/blog/2019/09/integrating-powerapps-and-power-bi-to-build-multifaceted-apps/

 

In addition, I think it is not necessary to embed a Power BI report into your PowerApps app, instead, I think the Chart Graph controls (e.g. Column Chart, Line Chart, Pie Chart) within PowerApps could achieve your needs.

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

Add a Column chart control within your app, set the Items property of the Column chart to following:

AddColumns(
GroupBy(
AddColumns(
Filter('Home Working Test', Requester.Email = User().Email && Status_Request.Value = "Approved"), /* <-- I think the Status_Request is a Choice column in your SP list */
"MonthOfYear",
Text(Date_For_Home_Working_Test, "mmmm")
),
"MonthOfYear",
"GroupData"
),
"Homeworking Days",
CountRows(GroupData)
)

Then set the Labels property within the Column chart to following:

MonthOfYear

set the Series property within the Column chart to following:

'Homeworking Days'

2.JPG

 

In addition, if you want to control above Column chart control visible through a Button, please consider take a try with the following workaround:

Add a button control, set the OnSelect property to following:

UpdateContext({ShowChart: !ShowChart})

set the Visible property of the CompositeColumnChart1 (which is a Group control, contains the Column chart control) to following:

ShowChart

Please consider take a try with above solution, 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

1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: PowerApps and graph Power Bi

Hi @bansay ,

Could you please share a bit more about your scenario?

Do you want to embed a Power BI report into your app?

 

If you want to embed a Power BI report into your app, you need to create a report within your Power BI based on your SP List data source firstly, then pin the Report to a specific dashboard.

After that, within your app, add a Power BI tile control, then specify the workspace, dashboard and Tile from your Power BI, then the report would be displayed in your app.

Please check the following article for more details:

https://powerapps.microsoft.com/en-us/blog/power-bi-tile-in-powerapps/

https://www.inogic.com/blog/2019/09/integrating-powerapps-and-power-bi-to-build-multifaceted-apps/

 

In addition, I think it is not necessary to embed a Power BI report into your PowerApps app, instead, I think the Chart Graph controls (e.g. Column Chart, Line Chart, Pie Chart) within PowerApps could achieve your needs.

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

Add a Column chart control within your app, set the Items property of the Column chart to following:

AddColumns(
GroupBy(
AddColumns(
Filter('Home Working Test', Requester.Email = User().Email && Status_Request.Value = "Approved"), /* <-- I think the Status_Request is a Choice column in your SP list */
"MonthOfYear",
Text(Date_For_Home_Working_Test, "mmmm")
),
"MonthOfYear",
"GroupData"
),
"Homeworking Days",
CountRows(GroupData)
)

Then set the Labels property within the Column chart to following:

MonthOfYear

set the Series property within the Column chart to following:

'Homeworking Days'

2.JPG

 

In addition, if you want to control above Column chart control visible through a Button, please consider take a try with the following workaround:

Add a button control, set the OnSelect property to following:

UpdateContext({ShowChart: !ShowChart})

set the Visible property of the CompositeColumnChart1 (which is a Group control, contains the Column chart control) to following:

ShowChart

Please consider take a try with above solution, 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

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 316 members 5,696 guests
Please welcome our newest community members: