cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Embed Excel Online

I have a very complicated excel sheet with a ready built dashboard.

I tried embedding the buttons/outputs to Power Bi, then into Power Apps but realised that:

1. It is extremely ugly

2. The Power BI tile is no longer functional within Power Apps (drop down menus etc.)

 

Is there any way of embedding editable excel online html code into Power Apps?

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Embed Excel Online

Hi @Mer88399,

Could you please share a bit more about your scenario?

Could you please show more details about the Excel online HTML code that you mentioned?

Do you mean that there is already a dashboard built within your Excel sheet?

If you want to display a HTML code within an app, I think the HTML text control could achieve your needs. More details about HTML text control, please check the following article:

HTML text control

Note: Please replace all the double quotes (") within your HTML Code with single quote (').

 

In addition, you could also consider take a try to create a report based on your Excel sheet data using Power BI, then pin the report to a new dashboard as a Tile. After that, you could embed your report within your app through the Power BI tile control.

 

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.
Regular Visitor

Re: Embed Excel Online

Good afternoon Kris,

 

Thank you for your reply.

We are creating a macroeconomic model for our clients, of which the source data needs to be extremely confidential.

Currently we have the behemoth of an excel sheet, which has a dashboard displaying output, which we print in pdf. and send off to the client.

I am tasked with creating an app/web service which enables the client to control the dashboard, using drop downs to alter their data (based on location factors etc.)

I have tried using the html text editor to embed only the parts of the excel sheet that I require (utilising Excel Online), however this does have a few draw backs (I haven't managed to get it to work within Power Apps, and externally there is a large black 'iframe' bar, which ruins the look/feel of the app.)

Any suggestions? Replicating the model within Power Bi would be extremely labour intensive, as we currently have a few hundred models.

 

Helpful resources

Announcements
secondImage

New Return to Workplace

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

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (4,728)