I'm extremely grateful for your efforts, Shane - not just with this video, but with the range of PowerApps videos and support that you have published. You have saved me many, many hours. Thank you so much!
Love your Vids Shane - been playing catch-up, so slowly ploughing through all your YT playlist since Sep 2020. Haven't written an app yet coz i want to watch all your training 1st to try and get the syntax to start sticking ( i know many will say to get stuck in to learn but its just not my learning style so hey ho, ill press on and have a go when i reach the end of your playlist). This one really pulled my brain apart but really appreciate how you try to make these as accessible as poss. Sent your web site a query on subscription costs as i am passionate about this area and really want to up-skill, but need a helping hand. Thanks so much. I'll come back to this vid after a lie down and meditation :).
I learned a lot about PowerApps from you already. But this one made my day! Thanks a lot of sharing your know how! I now have a table with ChildChildChild running :-). At the end very complex and more or less not readable anymore. But creating in in "baby steps" I got it running ;-)
Awesome vid as always, last week have to use html text in a SharePoint list form made in powerapps because a multiple users column would never show as a list, so aplied just a little of html to make it, felt good =)
Hey Shane, great work as always. At 25:19 you are saying the you cannot show the borders in the html control. Yes you can but when you are using the inline style (which making things harder to read but it is working). Hope this will help.
Great video as always. I had a hard time following the last example though with the nested table, correlated ID's and Office365Users.SearchUser() thing.
Thanks Shane. This is awesome. I am Very curious about your thoughts on use cases for power apps portal. Could do a video on what your thoughts are on new power apps portal?
Hey Shane. Love your videos. Learning a lot. I've gotten to export to PDF but it's only exporting my parent data. My child data isn't showing up. I'm using a one column table layout with a nested table for the children. Any thoughts?
You are on the right track. You will need to just fight your Nested Concats. I would do it in an HTML control and focus on getting that to show before worrying about the PDF. Fail fast is the key. :)
@@ShanesCows thanks for the reply!!! Will focus on the Concat. I'm doing it in an HTML control and everything is showing the way I want it. Child data Just doesn't show up in the export pdf. I am grabbing my child data from a merged collection of the parent and child data, and the merged collection is grouped. So my Concat looks something like Concat(this.record.data, "" & data1 & ". " & Data2 & .......). I noticed in your video you Concat child data from a non grouped collection. Could that be my issue?
@@dankirchner4460 If you are getting it to show in the HTML but not in the PDF conversion then the issue is syntax. You are missing an HTML tag somewhere. The conversion process is very grumpy. Look through the HTML output very carefully. Find the little or or that you are most likely missing. :) Good luck
I love this. Before I implement, I am wondering, if instead of hard coding the styling in a header tag, have you tried linking to a custom css file or bootstrap css file in a document library or a cdn link. I am working in a canvas app on a table of reports and links (nested under categories and things like that) - so I still want my tables to look amazing and styling usually takes me a very long time and takes the fun out of it. So in my non-power app websites, I use a lot of bootstrap css. So have you tried that and has it worked?
Hi Shane thanks for your videos, so helpful! I'm trying to do something similar on CDS to use on a model-driven app- adding a view column that concats a one to many lookup field from another table, but no luck. Any suggestions?
Best of all Powerapps training at youtube ! Question about: I have a collection with different entrys, also with picture information as base64 string in, comming from powerapps camera. how did i get this into the html table to show the picture and send it also by email? Kind regards Klaus
@@ShanesCows Hi, thank you for answer. What is the failure? The data for picture is stored as field "Imagedata" but i get error message. here are the text: "OrtBeschreibungEinstufungZuständigDuedateBild
Funny seeing w3schools in 2024 heh. I was doing tables for html email. I was surprised to see your css styles working in your email. When I tried to put it in it's own style tag it wasn't working. But it did work when i put the style in each table td and th tag heh. I atleast used the With function for that. I wonder why it wasn't working. I also didn't know there was an HTML Text control.
In class I always joke I was great at HTML in the late 90s and again now. I guess some things never change. Since this video, I have also learned that Copilot/ChatGPT/etc are all great at HTML if you need a hand. Inline styles always seem to have the best chance of success with Power Platform, so I always ask for that first.
Thanks Shane for wonderful tips. I am curious if we can do the same with Power Automate i.e. Create HTML Table on the basis of filter query like current user and send the email?
Hi Shane, Sorry, for some reason, I can't get the last formatted code block (your version with the border etc) to work. I can get hard coded versions to work, but as soon as I plug in the non-html text it fails. I can't seem to figure out why!! Are you able to post the whole html text block please? Thanks...
Hi Shane, thank you very much to help us learn this wonderful tool. Basically, everything I know about it I learned from you. Congratulations! I have one doubt here, to get details of the expenses you build a second table where you are getting "Title" when I believe it should be "ExpenseItem" but it is working in your application, why? Part of your code where I have doubt: ... & "&Concat(Filter(ExpenseDetails, MasterID = MID), "" & Title & ... Thank you. Regards, Moacir Radiuk - Brazil
This is a sweet solution; however, in my second Concat the ID I get the error "Invalid argument type" and "Name is invalid" for the renamed column. All IDs are numbers (I am using a SharePoint list). The first ID is the SP row ID, and the second is a foreign key in the second list. Any suggestions?
Hi Shane, after I learned to do this a few weeks back I wanted to take the HTML to another level without having to write out all the HTML so I took for example a table I build in Excel pasted it in an email and then sent it. Then I went to the “view code” in the email and copied the HTML code and pasted it in PowerApps HTML Label and it worked with some tweaking. Based on that I bi-passed all the writing of the code. I am curious to know if you think something like this or a way to generate the html code is a good way to get some complex HTML results. Any thoughts on that or an easier way to do it. Or am HTML version/style to use for PowerApps or Flow? Thanks for the video.
Hi Shane. Have you considered the license strategy changes that MS has announced? Reading about this move from Microsoft, I'm truly saddened. Being a long term promoter of Microsofts solutions, I have been driving and implementing Microsoft technologies for more than a decade. Specifically, we just completed a major project to move a number of on-prem SQL servers into Azure, with the specific goal to avoid using premium connectors, the price of which would undermine our IT strategy. Now, Microsoft decides to completely change the guiding points we have used to decide on PowerApps and Flow for our business applications. Not only are they reclassifying the Azure SQL connector to "Premium", but they are also increasing prices at rates, I have never seen before from any serious IT solutions provider - in our case, specifically, we are using a number of Office 365 Business Essentials and Business Premium licenses for our users. My calculations show we will experience price increases of more than 500% !!. I ask myself: How can I ever trust Microsoft again, when this can happen - with this, you are directly undermining my personal credibility as an advisor, promoting Microsoft solutions. Customers have invested in migrating to Azure and the Powerplatform under completely wrong assumptions and based on Microsoft being a trustworthy partner in the long run. All gone now. It makes me sad. One of the big arguments for migrating to the cloud in general, is less hassle with operations. This just moves the hassle from the IT operations to the strategic level - constantly forcing management in companies to get involved to re-consider their IT strategy, because Microsoft decides to change the economical foundation decisions were based on. I just kindly ask MS to deliver on their promises - make it a worry free experience to migrate to the cloud without constantly rocking (tipping over) the boat. The least they could do is to provide existing users an option for nothing to change and then only change the price structure for new/added or changed featuresets instead of causing all this agony that is slowly undermining your position as a trustworthy and reliable partner for companies and cloud first strategies in general. How about a special on this, which I believe is confusing to a lot of us.
Could anyone show me what I am missing with this? I have everything working except the filter for the second table doesn't recognize the renamed column. Also doesn't work if I do a ClearCollect with a rename. Also doesn't work just using ID. If I remove the filter it works perfectly. ""& Concat(Sort(RenameColumns(CameraInfo,"ID","MID"),CameraName,SortOrder.Ascending), CameraName,""&"" & ""& Concat(Filter(CameraTestLog,CameraInfoLockIn=MID)," "&DateTested&" "&NotesShort&"")&"" &"" )&"" Thank you Shane and everyone here!
Thanks Shane. As you stated, needing HTML experience is something that coincides with developing quality email outputs. Something I have been stuck on for months came down to putting a in my HTML. :( Appreciate the community service you do with these short videos. Great work.
WOW - that MVP sign in the back should be made of pure gold!!!
Thanks Frank 🤓
One of the best Power App instructors. Really appreciate your work.
I appreciate that! Hope you have a great day!
I'm extremely grateful for your efforts, Shane - not just with this video, but with the range of PowerApps videos and support that you have published. You have saved me many, many hours. Thank you so much!
Glad to help Paul . 😀
Love your Vids Shane - been playing catch-up, so slowly ploughing through all your YT playlist since Sep 2020. Haven't written an app yet coz i want to watch all your training 1st to try and get the syntax to start sticking ( i know many will say to get stuck in to learn but its just not my learning style so hey ho, ill press on and have a go when i reach the end of your playlist). This one really pulled my brain apart but really appreciate how you try to make these as accessible as poss. Sent your web site a query on subscription costs as i am passionate about this area and really want to up-skill, but need a helping hand. Thanks so much. I'll come back to this vid after a lie down and meditation :).
Steven keep learning 😀 you know your style best. 😀
@10:25 the best moment.
Used concat in a label but it seems that HTML is way better and easier for formatting.
Thank you Shane
😎
I learned a lot about PowerApps from you already. But this one made my day! Thanks a lot of sharing your know how!
I now have a table with ChildChildChild running :-). At the end very complex and more or less not readable anymore. But creating in in "baby steps" I got it running ;-)
I LOVE THIS!!! 😻😍🥰
Shane! In the words of the great Randy Jackson..."Dude! You rocked it again Dawg!" Thanks man.
Thanks 😻
Thanks a lot @shane god bless you and your mom for helping us out ....
Thanks. I will pass along the good vibes to her. 😊
OMGEEEE! Shane you are the best! Your video made my app do EXACTLY what I wanted it to do! I cannot thank you enough! :-)
Glad I could help!
you absolutely beautiful man! This is exactly what I needed! Don't know what I would have done without finding this!!! Thank you!
You're very welcome!
As always a jaw-dropping brilliant presentation not to mention great practical examples.
😀
Thanks Shane, this really helped me.
You are welcome.
You have helped me very much in understanding PowerApps. thanks.
Glad to help. 😀
Great Video again. Thank you.... please make more of these. Greetings from germany
😻
Awesome vid as always, last week have to use html text in a SharePoint list form made in powerapps because a multiple users column would never show as a list, so aplied just a little of html to make it, felt good =)
You are my hero. 😎
Wow you blew my mind. Thanks a lot Shane!!!
Glad you liked it
Thanks mate, that was what i needed; no developer experience so not good with HTML so a video on HTML basics would defs be good
Thanks Brett. Noted. In the meantime be sure to check out www.w3schools.com/html/default.asp. They do a great job with basics.
Great as you always do! Congrats!
Thanks
Nice work Shane
Thanks
Thank you for the tutorial @ShaneCows. Works great.
Awesome
You are awesome, Always!!
Thanks 🐶🐶
Great! Thank you Shane.
Happy to help
Yes, you are a guru.
Thanks Richard. 😀
Thanks Shane, really helpful that video.
Glad to help. 😀
Hey Shane, great work as always. At 25:19 you are saying the you cannot show the borders in the html control. Yes you can but when you are using the inline style (which making things harder to read but it is working). Hope this will help.
Good to know. 🙏
좋은 강좌 감사합니다
감사합니다! (Hopefully I got that right)
Great video as always. I had a hard time following the last example though with the nested table, correlated ID's and Office365Users.SearchUser() thing.
It was a bit crazy. Sorry
Thanks Shane, while putting single separation ( ,)in label it comes like (,,)
I just done like you but 2 comas are comming why that's happen can you support me
I don’t know. I have never seen that
Thanks Shane. This is awesome. I am Very curious about your thoughts on use cases for power apps portal. Could do a video on what your thoughts are on new power apps portal?
It is on the list. 😀
Is there a way to configure a cell background based off of a cell value. The value is associated within the 'concate'd' collection? Thank You
You will need to use If fucntion for setting the color property in HTML. Not impossible but adds a few moving pieces for sure.
Hey Shane, please how to add attachment in this nested table ? Attachments from the first gallery
Not sure what you are trying to do?
@@ShanesCows i am trying to create a pdf with images...
Images are in attachments, so i wanted to create a nested table to display images
Hey great video , have can we apply Css or branding to the html in powerapp ?
I don’t think you can
Hey Shane. Love your videos. Learning a lot. I've gotten to export to PDF but it's only exporting my parent data. My child data isn't showing up. I'm using a one column table layout with a nested table for the children. Any thoughts?
You are on the right track. You will need to just fight your Nested Concats. I would do it in an HTML control and focus on getting that to show before worrying about the PDF. Fail fast is the key. :)
@@ShanesCows thanks for the reply!!! Will focus on the Concat. I'm doing it in an HTML control and everything is showing the way I want it. Child data Just doesn't show up in the export pdf. I am grabbing my child data from a merged collection of the parent and child data, and the merged collection is grouped. So my Concat looks something like Concat(this.record.data, "" & data1 & ". " & Data2 & .......). I noticed in your video you Concat child data from a non grouped collection. Could that be my issue?
@@dankirchner4460 If you are getting it to show in the HTML but not in the PDF conversion then the issue is syntax. You are missing an HTML tag somewhere. The conversion process is very grumpy. Look through the HTML output very carefully. Find the little or or that you are most likely missing. :) Good luck
@@ShanesCows agreed. I'm playing with my HTML tags and formatting now. The term grumpy is an understatement 🤣
@@ShanesCows I figured it out. I had my close tags backwards. Wow that one hurt 🤕😂
I love this. Before I implement, I am wondering, if instead of hard coding the styling in a header tag, have you tried linking to a custom css file or bootstrap css file in a document library or a cdn link. I am working in a canvas app on a table of reports and links (nested under categories and things like that) - so I still want my tables to look amazing and styling usually takes me a very long time and takes the fun out of it. So in my non-power app websites, I use a lot of bootstrap css. So have you tried that and has it worked?
Never tried. Sorry
Hi Shane thanks for your videos, so helpful! I'm trying to do something similar on CDS to use on a model-driven app- adding a view column that concats a one to many lookup field from another table, but no luck. Any suggestions?
I got nada. Sorry
Best of all Powerapps training at youtube !
Question about: I have a collection with different entrys, also with picture information as base64 string in, comming from powerapps camera. how did i get this into the html table to show the picture and send it also by email?
Kind regards Klaus
See if this video on base64 images helps th-cam.com/video/bIne3DD3HAg/w-d-xo.html
@@ShanesCows Hi, thank you for answer. What is the failure? The data for picture is stored as field "Imagedata" but i get error message. here are the text:
"OrtBeschreibungEinstufungZuständigDuedateBild
Funny seeing w3schools in 2024 heh. I was doing tables for html email. I was surprised to see your css styles working in your email. When I tried to put it in it's own style tag it wasn't working. But it did work when i put the style in each table td and th tag heh. I atleast used the With function for that. I wonder why it wasn't working. I also didn't know there was an HTML Text control.
In class I always joke I was great at HTML in the late 90s and again now. I guess some things never change.
Since this video, I have also learned that Copilot/ChatGPT/etc are all great at HTML if you need a hand. Inline styles always seem to have the best chance of success with Power Platform, so I always ask for that first.
Thanks Shane for wonderful tips. I am curious if we can do the same with Power Automate i.e. Create HTML Table on the basis of filter query like current user and send the email?
Hi Shane, Sorry, for some reason, I can't get the last formatted code block (your version with the border etc) to work. I can get hard coded versions to work, but as soon as I plug in the non-html text it fails. I can't seem to figure out why!! Are you able to post the whole html text block please? Thanks...
Nevermind! Got it....missing closing brackets!!
Glad you got it Paul
Can you edit the Concat-ed data and save it? @ShaneCows
It makes a string. You could save that string to a variable and then use a text input to edit?
Hi Shane, thank you very much to help us learn this wonderful tool. Basically, everything I know about it I learned from you. Congratulations!
I have one doubt here, to get details of the expenses you build a second table where you are getting "Title" when I believe it should be "ExpenseItem" but it is working in your application, why?
Part of your code where I have doubt: ... & "&Concat(Filter(ExpenseDetails, MasterID = MID), "" & Title & ...
Thank you.
Regards,
Moacir Radiuk - Brazil
The name of the column under the hood is title that is why it works
This is a sweet solution; however, in my second Concat the ID I get the error "Invalid argument type" and "Name is invalid" for the renamed column. All IDs are numbers (I am using a SharePoint list). The first ID is the SP row ID, and the second is a foreign key in the second list.
Any suggestions?
Not sure without more info 😑
I want to create "foncy" PowerApps like Shane!
🤑
Hi Shane, after I learned to do this a few weeks back I wanted to take the HTML to another level without having to write out all the HTML so I took for example a table I build in Excel pasted it in an email and then sent it. Then I went to the “view code” in the email and copied the HTML code and pasted it in PowerApps HTML Label and it worked with some tweaking. Based on that I bi-passed all the writing of the code. I am curious to know if you think something like this or a way to generate the html code is a good way to get some complex HTML results. Any thoughts on that or an easier way to do it. Or am HTML version/style to use for PowerApps or Flow? Thanks for the video.
If the HTML works I wouldn’t over think I it. 😻
Shane. You are great. But I cannot say it about MS. I think this October changes will make a lot of users stop using Powerapps. I am in this list.
Sorry. Here is a link to a write up I did mailchi.mp/baa6477a1146/powerapps-flow-and-dynamics-licensing-changes
Hi Shane. Have you considered the license strategy changes that MS has announced?
Reading about this move from Microsoft, I'm truly saddened.
Being a long term promoter of Microsofts solutions, I have been driving and implementing Microsoft technologies for more than a decade. Specifically, we just completed a major project to move a number of on-prem SQL servers into Azure, with the specific goal to avoid using premium connectors, the price of which would undermine our IT strategy.
Now, Microsoft decides to completely change the guiding points we have used to decide on PowerApps and Flow for our business applications. Not only are they reclassifying the Azure SQL connector to "Premium", but they are also increasing prices at rates, I have never seen before from any serious IT solutions provider - in our case, specifically, we are using a number of Office 365 Business Essentials and Business Premium licenses for our users. My calculations show we will experience price increases of more than 500% !!.
I ask myself: How can I ever trust Microsoft again, when this can happen - with this, you are directly undermining my personal credibility as an advisor, promoting Microsoft solutions. Customers have invested in migrating to Azure and the Powerplatform under completely wrong assumptions and based on Microsoft being a trustworthy partner in the long run. All gone now. It makes me sad. One of the big arguments for migrating to the cloud in general, is less hassle with operations. This just moves the hassle from the IT operations to the strategic level - constantly forcing management in companies to get involved to re-consider their IT strategy, because Microsoft decides to change the economical foundation decisions were based on.
I just kindly ask MS to deliver on their promises - make it a worry free experience to migrate to the cloud without constantly rocking (tipping over) the boat. The least they could do is to provide existing users an option for nothing to change and then only change the price structure for new/added or changed featuresets instead of causing all this agony that is slowly undermining your position as a trustworthy and reliable partner for companies and cloud first strategies in general.
How about a special on this, which I believe is confusing to a lot of us.
This should help. 😀 I wrote it up. mailchi.mp/baa6477a1146/powerapps-flow-and-dynamics-licensing-changes
Could anyone show me what I am missing with this? I have everything working except the filter for the second table doesn't recognize the renamed column. Also doesn't work if I do a ClearCollect with a rename. Also doesn't work just using ID. If I remove the filter it works perfectly.
""&
Concat(Sort(RenameColumns(CameraInfo,"ID","MID"),CameraName,SortOrder.Ascending), CameraName,""&""
&
""&
Concat(Filter(CameraTestLog,CameraInfoLockIn=MID)," "&DateTested&" "&NotesShort&"")&""
&""
)&""
Thank you Shane and everyone here!
Got it working with this:
Concat(Sort(RenameColumns(CameraInfo,"ID","NewID"),CameraName,SortOrder.Ascending),""& CameraName &":"&
"" & Concat(Sort(Filter(CameraTestLog,NewID=CameraInfoLockIn),DateTested,SortOrder.Descending), DateTested &" - Battery: "&Battery&": "& NotesShort&" ") & "
")
Why don't the sum of your items for "taco" agree to the total? $2,061 v $1,061
Must have been a crazy mistake from the video. 😀
I'm using Excel, why did you say I hope you're not using Excel? Now im scared. Should I not be using Excel to try and build a Powerapp?
It is Meh as a data source if you want to have multiple users.
Thanks Shane. As you stated, needing HTML experience is something that coincides with developing quality email outputs. Something I have been stuck on for months came down to putting a in my HTML. :( Appreciate the community service you do with these short videos. Great work.
Thanks glad you got it. 🤩