Build Power BI Style Reporting with Just Power Apps | Create Beautiful Reports Easily

[@Joebb3Games]

I've learned SO much from you, Shane. I'm a VB programmer and Interface designer, so Powerapps is SUPER fun, but super frustrating due to now "Step in" debugger, but your tutorials help a lot!! I'm off to add this to my current app. I have the perfect place for it. Thanks brother!

[@ShanesCows]

Awesome and glad to help 😎

[@ramitkishoresaha9437]

Every time I see your videos, I learn something new. Thanks!❤

[@ShanesCows]

Appreciate that Ramit 😎

[@kuvat]

I'm in the middle of building two tables in an app but I was doing it with TONS of containers. I may leave the completed one and build the other with HTML and compare/contrast them. Thanks for the idea!!

[@ShanesCows]

Glad to help. Good luck Craig. 😎

[@spen2431]

Nice one Shane. Yes, Power BI could be better, but seeing the art of the possible is always interesting. ⭐⭐⭐⭐⭐

[@ShanesCows]

Thanks Spen. That was exactly my goal. 😎

[@oluwatobipaul6171]

Awesome use of html. Thank you Shane

[@ShanesCows]

HTML is a great Power Apps skill

[@paolovr1970]

Thanks again SHANE 🙏🙏🙏

[@ShanesCows]

Happy to help 😎

[@dougydoe]

This is brilliant, Shane. Video's like this and those from Kristine inspires me to use my Web skills more in PowerApps. I did quite a bit of Web front-end before picking up Power Platform so I need to use all the HTML's and CSS's more. Really liked it and Thanks for sharing.

[@ShanesCows]

Awesomeness! Happy to help. Have a great day. 🐶

[@cmacdhon]

This is amazing! Thank you Shane!!!!

[@ShanesCows]

Glad to help. 😀

[@PowerAppsTutorial]

ha ha ha... I will do everything to create an amazing report in my canvas apps before admitting to someone "You may want to use Power BI". We have so much in common, @shane. #bromance

[@ShanesCows]

#TRUTH 😎

[@jacksonbrumbaugh9706]

whole-heartedly 2nd the desire for dark-mode in PowerApps!!!

[@ShanesCows]

Love it! Lets do it so I can stop using 😎 when I build.

[@davidmckenzie1889]

Shane, it is even possible to make future changes easier by using $ notation (don't know if this is the correct name) for the strings - so instead of "" & varTR & varTD & "...etc" you use $"{varTR}{varTD}...etc". You would probably need to put the conditional colour IFs and the currency formatting into the WITH scope but this would also help if the customer decides to change the 95% to 90% or show the values with no cents as all the changes would be grouped together. But another great video that gives me an idea I can expand upon.

[@ShanesCows]

Thanks David - I know about that other way of concatenating it just doesn't resonate with my non-dev brain. 😐

[@davidmckenzie1889]

@@ShanesCows It didn't resonate with my brain until about a week ago! I still tend to use & for most things.

[@fnanfne]

Cool! I've got reporting in most of my apps already, but will use some of your ideas ta! What is the benefit of using this 'With' function, as opposed to just creating the required variables in a normal fashion?

[@ShanesCows]

If you only need the info in this one control then With is more efficient. If you need to reuse the data elsewhere then use a variable.

[@LONGBEACH2ARIZONA]

Hello Shane, sorry for this beginner question. In order to have dynamic updated information, would you have to create a flow to put excel files into same folder to have information update?

[@jacksonbrumbaugh9706]

in case no one else says it ... there most certainly is many ways to bold text in HTML 😎

[@ShanesCows]

I had never used Strong until I saw it in Power Apps. I grew up with BOLD. 🤩

[@kuvat]

@@ShanesCows Yep. BOLD got depreciated along with ITALICS.

[@ShanesCows]

Boo! I still love them. Guess that is what happens when you started writing HTML in the 90s 😲

[@jeanpierreragequit1726]

underline :D

[@joselin4753]

Hey, shane Is there any way we can create webpage using html and use SharePoint as backend??

[@ShanesCows]

Maybe? I am not sure. I haven't tried to do anything like that in YEARS so I don't know.

[@jeroentournier]

I would have used a Gallery instead of HTML. Any thoughts on that?

[@ShanesCows]

Because the way the data was formatted it was easier for me to write it this way. Also I needed to make it responsive. I am sure a gallery could have worked but this was the path of least resistance for me.

[@brianleewilliams]

Is it possible to pull Power BI data into the power app?

[@ShanesCows]

Brian I am not sure. I know that flow can get PBI data and then write it somewhere, not sure if POwer Apps can do the same or not.

[@hostrup001]

Nice 😊

[@ShanesCows]

Thanks 😊

[@angrybatvoice]

My first question is always “Does it come in black?” +1 for Dark Mode in Power Apps Studio.

[@ShanesCows]

You are the Dark Knight after all. 😎

[@andrianrachmat9743]

hi, i have a problem when trying your tutorial. i have created data in excel, and for the number format setting i "set as number". but when my number format is "set as number", the data does not appear in power apps. when i try to change the number format "set as general" or "text", the data appears in power apps but i cannot use if logic. when i return "set as number", the if logic works, but the numbers do not appear in power apps.

[@solota8422]

He he, .. Shane, you're clever and you know that you took just simple example where you manually type each row. Thank you for that, it's great, but... what if one needs listed all records from the gallery/table etc? There is no true loop in Powerapps. Can I somehow embed a gallery in HTML? How to solve this and get proper report listing items? Could you please make a video about it?

[@bigpix2000]

The last frontier for those who say "those trees are already dead" aka folks who want to "print" the report (which is a scroll away from a full view), how would we print that HTML report? Could we Print() and load in the HTML instead of the Screen? (anyone?)

[@ShanesCows]

In these cases I usually recommend generating a PDF and then having them print that. But there may be more creative options, not sure. Did you see this idea? kzbin.info/www/bejne/o2WppmyXm5ebZ8U

[@TheNewBoss2012]

Hi, thanks for sharing. I think it would be more correct to perform all the conditions by using assignment to variables at the screen or app level. That way it will be more convenient to maintain it.

[@ShanesCows]

If you were going to use them other places then yes. For me I only use them in this one control so this is the most efficient use of resources keeping them scoped to just the control.