A similar solution is available on UA-cam but the way to make it simpler in terms of explaining is what I like about you. I really look forward to your videos. Thanks for your time and effort. You are helping people like me to do better in career.
Thank you so much for this video! Our leadership team was in a panic about how sending out a ton of individualized emails and this provided a perfect solution. I've never used PowerAutomate before and I was able to get this created in an hour.
This was incredibly instructive, I'm going to be watching this 30 more times. So my problem is I want to do what you're doing here, but in Power BI, and I want Power Automate to filter what points are selected on a map of properties in Power BI, and send an e-mail with the loan numbers hyperlinked along with their addresses, city, postal code, etc. All the loan data is stored in Sharepoint. The hyperlink leads to an inspection form (already created in Power Apps). Thank-you if you do a video for this!
Awesome!! I was trying to make something like this but I was lost. I need to send many emails based on the client info when every client can have many contracts related and wanted to just do what you showed. Many thanks!
Thanks Damian. One further tip I would give. For any html emails put the html into a compose action and then inject the outputs of that into the email. Why? Well that send email step has two modes standard editor and html. If you put things in the html editor and accidentally put it back to standard things get seriously messed up especially special characters like // etc. That has messed up some of my flows big time. The other advantage of using the compose steps is you canconstruct emails in sections and inject outputs as you need them. If an output through some logical result is blank then the email has nothing to inject. Conversely you can insert sections of text or html conditionally. Without having to have multiple email steps.
Hi. I just noticed that my flow is sending the html table empty to contacts that don't have any information available. How can I avoid this to happen... I have a contact list but not always they'll need to receive the email. Just when they have something pending in the mail table. How could i fix this?
Because you are using your brain en list, one method would be to introduce a condition in the loop to check if the filter array output length() is greater than 0. The other option would be to create a distinct list of contacts based on the original data. Let me know if you crack it. 👍
Hi, thank you for the great video! You have saved tons of my time! Some additional questions on this video - 1) can you please kindly guide if I could use cc/bcc function with this flow? If yes, is there a video that I can refer to? 2) can I also add/use Name in the email body? For example, instead of sending only the table, I was wondering if I could customize email body as: Hi XXX (Name), hope this email finds you well. :) Thank you for your time!
Hi Verola, if you filter the get items by date and use a recurrence trigger you could achieve what you’re looking for. I don’t have a video, so I would suggest you try the forum just now powerusers.microsoft.com/
Thank you for your video. How can I achieve this through Sharepoint? I'm trying to send emails to each row (each recipient) and add html table to each email as it pertains to.
@@DamoBird365 it’s giving me a for each on top of the create HtMl table, I tried to remove it but it gave me an error message. Have to try again I guess. Thanks for the response!!
Very helpful, thank you. I have a similar issue. However in my "managers" table I have all the possible managers. My second table only has information for a subset of those managers. The issue I have when I do the above is I end up sending empty emails to any manager who does not have data in table 2. How do I suppress those emails? I know its an inner join, but don't know how to do that on power automate. Thank you
Hi Damian. Thanks for your explanations. I have a question. I did the filter array in my environment. It worked fine. However, when migrating the flow to production in my customer's environment the array does not filter and sends all the values in the email. Do you probably know what could be the reason? I checked and I followed the same steps as in my environment. Thanks, Fabio
Hey Fabio, hard to be sure but I would take a look at the history output. Most likely the wrong dynamic value has been used for creating the html table? If this wasn’t a solution export/import, it’s usually human error. Maybe one for the forum? powerusers.microsoft.com/
@@DamoBird365 Thanks Damian, appreciate your help. I could figure it out. The two columns I was comparing had a slash (/) in their name. It was causing issues to filter the array.
I have 5 excel files that are based on template of part timers attendance. Columns are dates, name, worked hours. I need to combine these every month into one excel or html table and send it to my mamager. The new table should have columns name, total hours and column for each day in that particular month (1,2,3,4,5 and so on). How could i combine those excel files into one report using power automate?
I don’t believe an html table would view very well unless you split it into tables by week. If you wanted a portable file, excel would be better. But if I am honest, a list would be best as you could have all the data in a list and have views or group by the employees.
You could consider inline 👉 Advanced HTML Tables in Power Automate - Formatting cells, rows and vertical tables ua-cam.com/video/LQumCR1B-q0/v-deo.html
Just wanted to add my thanks to posting this video! Great stuff. I am new to Power Automate. I was able to recreate the initial scenario with a separate unique manager table. However, when I removed that table from the flow, my "Send an email" action was preceded by a second "Apply to each" and many duplicate emails were sent. I think this occurred because in my email body, I was trying to include a field from the Data table (in my case, it was the first name of the manager). Any tips on how to add this from the Data table itself (for instance, the column H value from your video 1:42)?
You want to write your own expression, as it will be based on the array value in the apply to each and not the original data source. Adding the dynamic data from the original data source will create an additional apply to each. ua-cam.com/video/d99Rr5djcME/v-deo.html
Hello Sir, thanks for the guidance, I would like to ask some more guidance, how to filter Excel rows with a client code or unique email address and send them an HTML table with their list of invoices using Power Automate. I have a multiple clients' list in an Excel file, with columns for invoice dates, invoice amount, paid payment, remaining balance, and remarks. In the same Excel sheet, I have additional columns like a customizable subject column, a customer unique ID for each client, and email recipients (To and CC). Could you please guide me on how to filter the Excel rows based on the client code or unique email address and then send them an HTML table with their list of invoices using Power Automate?
I need help. I have a excel in SharePoint and I want to trigger an email each time a person adds or updates that excel file . The email must contain who modified and the data that was modified. Please help me please
in apply to each under filter array action, when I select Email from dynamic value it automatically created For each section. Then I selected email after equals to, it added another For Each... how to avoid that or what am I doing wrong?
Most likely down to the from of your filter is not directly related to your email field. I have a video that explains apply to each: Power Automate | Apply to Each | Why? | Arrays and Objects ua-cam.com/video/d99Rr5djcME/v-deo.html let me know if it helps.
It will be your condition not equaling true for any records. Look at the history input to the filter array. Look for the value you are filtering. String conditions are case sensitive. Let me know how you get on 👍
@@DamoBird365 Hi after years😂😂 I was able to make it The problem was since my data was too large I needed to go to settings of list rows and change the pagination threshold Thank you so much buddy for the help Can you please also guide me if I want to add the data into an excel file and then send the file as an excel attachement in the mail
My employer uses Office 365 but nobody uses Power Automate. I was looking for a VBA routing to do exactly what this demo does except that I did not expect to find code that could retrieve multiple rows of data for a single user and send a single email. I thought at best, certain users would receive multiple emails corresponding to how many rows of data pertain to that user. Then I came across this video, and it does exactly what I need. So deskside support downloaded the desktop version. However, I was very frustrated to find that when I search actions there is no " list Rows present in a Table". The interface doesn't even look like this video. The dream came to an end. I am sure there must be another set of actions to get to the same place but I don't have the expertise to figure that out. I am baffled as to why "List Rows Present in a Table" is totally missing!
Hi there Ginger. You are looking at Power Automate Desktop, which is for local pc based automation known as RPA. You want cloud based automation, power automate. This is accessed via the web only.
your are genious , I'm new to power automate and using your material was instrumental ! thank you , now I'd like to do the samething but from a desktop flow ( files are on a local network drive, not a cloud drive ), any info how to move on would be great !
Hi Eric, thanks for your feedback. You could use Power Automate Desktop for which I don’t have many videos or there is a cloud connector for local files. It depends on your use case.
Thanks Damian, have you got any videos using the desktop version, the processes you are using in this video, is not available to me on the desktop version? I can't find any other videos that have exactly what you demonstrate above, but in the desktop version. Any help would be much appreciated!
@@DamoBird365 thanks for the reply. Do you know how I can pick up computer files using the web version? Instead of using one drive or share point files? My share point is in a different location than the share point on my office account. Thanks
Are you still talking desktop or cloud flows? A cloud flow has a connection reference which is the user credentials. You could use credentials that attach to this other tenant you mention. Desktop I am unsure.
how to add filter data step or anyway before send to email. example : send only data in Tot3 columns > 150. I just learn about power automate. thank you.
It was verry useful watching this video. I managed to create my own automation flow using the steps explained in your video. I'm having an issue though. The styling of the table it's only applied to the first table and not the second one. What could be wrong? I also added a Compose action and added the html table styling there, before the Send an Email action witch also only applies the styling to the first table. Thank you!
Are you trying to do something like: Power Automate - Fast Data Aggregation - Group By, Sum, Count #powerautomate ua-cam.com/video/z5MxbwURV68/v-deo.html
Hi Damien, have a question about styling this table - I can't figure out how to apply a background color to specific columns, or a background color for specific rows. I've watched other videos you posted about if statements, but it's not for a "create an HTML table" action, it was on a select. Any ideas? Thanks!
@@alecseidman5601 you can’t apply formatting to specific cells with the basic create html table. Hence my demo of using a select to build the html table. It’s because you would need to edit the tags in create html which you can’t do. I’ve seen some folk do a find /replace after the create html, but I would suggest select is cleaner.
@@DamoBird365 Hi, sounds good - Can I apply the Compose with a Union to have a distinct array of emails as well as a select for the HTML table? I just don't want to lose the ability to send distinct emails
@@alecseidman5601 yes, have the compose in the apply to each. Each loop will have its own html table made by the select, which can be based on a filter.
Great video! I'm learning a lot! Is there some way to do this with just 1 table. I want to email managers a list of thier employees and the hours they worked that week. Any advice?
Is it possible to add a condition that if a cell from our table is empty to not show in our HTML table from the email? For ex. If "Tot 3" is empty for Manager 4, than not add the column in that email that is sent?
I don’t fully understand, but if you can perform a condition on your array to do the check you mention, you can then branch yes/no and use a select action to add or remove the key/column in question. Or use advanced on create html table.
Hi Damian, can include the total of integer values in the report sent to outlook? Is there any way? I mean, I would like to include a total of Text1, text2 & Text3 as a new raw when I receive mail in outlook.. Please help.
Hey very helpful video, its helped us automate our very manual quarterly access reviews for application access. Is it possible to set the table cell widths or to carry a dropdown through from Excel?
Thanks for sharing. To format the columns you could use replace() on the table output to add a colgroup. www.w3docs.com/snippets/css/how-to-set-the-width-of-the-table-column.html include the tag in a compose with the colgroup and replace the table tag with the content of the compose. Let me know if that works?
Great video Damian. Thank you for sharing your knowledge and making awesome PA videos. I've learned so much from you. You make it look very simple. I have a question, it's similar case as this video but taking one step further, asuming that each employee are members of different branches, in this example, let's assume employee 10 and 11 belong to branch New York and the rest to branch New Jersey, how would you automatically create a html table for each branch with a headed branch location to identify each branch per table? I could have 3, 4, or more branches so I'd like to see a html table group by employee per branch. Is this even possible?
Thank you Mario. Anything is possible 😀 well most of the times! Can you send me an example? The user on the forum gave me everything I needed, sample data and expected output. Here is another example on the forum which makes a very good use case powerusers.microsoft.com/t5/General-Power-Automate/Compare-Two-Array-for-Each-Unique-ID-and-Send-Email/m-p/1461516#M86313
Hello Damian, Very nice Video and a proper business related issue you covered here. I did for my self an it worked out .Thanks for your time Additionally, by any chance, if we need output on Excel instead of HTML with multiple data, will this be possible. Thank you
Hi damian, in the email, i would like to state what the sum of all the values for that email address is, how would i do this? have you got a video on this? thanks, timo
I’ve not but I could look to do this. Unfortunately power automate only is an add which accepts two values. This results in the need for an apply to each but there are other ways which I can try and demonstrate.
Hi, Thanks for this. Instead of creating one HTML table for each email address, can you guide me on how to create a separate excel file for each email address, so there should be multiple rows in each file? I can create a file but I ended up with only one row each and then my flow failed. I likely have the apply-to-each incorrect but i don't know how to fix it. Also, should I be using apply-to-each if my source file as 7000+ rows? Thanks.
This video is really helpful and I got what I'm looking for. I would like to know how can we get last few rows (ex. last 10 rows values out of 30 values)data and send it in email. Could you please help with that.
Excellent video thanks. I followed this logic however, I saw on your first email test the two tables. For the life of me I can't seem to enforce the same column width for columns in both tables. I've tried CSS, tlreolaving the header with explicit column widths but nada. It seems this may be a big? I know you've encountered it it. Have you looked into that issue as well? Cheers
I’m not sure Carl. Have you tried your flow generated html in a wysiwyg editor? Build the html in a compose and then copy it from history to paste online to see the output.
@@DamoBird365 Yes in a sense. I got my styling from Ryan Maclean's site and W3Schools. Also obtained my table header example from Grant Jenkins on Power Automate forum. I've found if you go the route of using advanced options under create table with custom columns it works. BUT now my tables are well formatted and void of data. 🙄🙄 It's always something with MSFT products. You can do this and do that but only if it's a Tuesday with a full moon.
hi Buddy this is very useful. i also want to know (for our requirement) on how to ensure the relevant managers can ONLY see their own rows of data (in the emails they receive respectively). can you pls add that information as well? So far, I was able to get this tested successfully with the formatting. however if there are say 5 managers in that excel, and each manager is supposed to ONLY see the rows for their reportees, how can I achieve that, and what condition can I include in this flow (and where can i add that step in this flow)?
I however would also like to know, if each manager email address (in the excel) Can get the data of their own respective members. Here are my questions : Question 1 : Manager 1 --> has user A and User B under himManager 2 --> has user C and User D under him So whenever emails are sent to Manager 1 (to approve), the email should ONLY contain the rows for user A and User B (similarly for manager 2) Question 2 : If Manager 1 gets the email with the user A and B row lines, he should individually be able to approve/deny each line (ie, he approves user A line, and maybe deny User B line). Is that possible? I would really like to know how this can be done.
Hi there. Q1 you can get the distinct managers using a select in text mode, insert the manager email and then perform a union on this result x2 in a compose. You can then supply the manager array to an apply to each, filter your data based on manager = current item and perform the rest of your html table requirements. Each loop would be done on a manager by manager basis. Q2: approving each item, is a bit more trickier and I don’t think power automate is best suited. I would possibly recommend a power app if you want to approve on a line by line basis.
@@DamoBird365 For question 2, I am trying to find videos that explain how Managers can approve/deny only individual employee rows that belong to them. Can you possibly point me to a good resource that explains how to set this up in a canvas app? How do I create the logic in the powerapp, that each manager only sees their own respective reportees data to individually approve/deny? Each manager should see only his own data to do line level approval. How do I do that in power app? any pointers would be appreicated
Hello Damian, great video!. I need to send an e-mail with both text (eg. this is your commision for the month [april] , where [april] is extracted from the excel table column A) and below a table with data (columns B-H). I have a table where one manager appears just once so I do not need to combine rows. I need to go row after row sending extracted data. From your videos I know how to send an e-mail with changing texts and an e-mail with just the table, but I have no idea how to join them into one e-mail. Could you help me :) ?
Hi Aleksandra, you can add both dynamic values into the send email action? If you build the first sentence in a compose and the table via create html table, you can add both outputs from these actions into your email. If you are struggling to get the month (maybe you get an apply to each?), from a table of rows, you can use first() or [0] as seen here ua-cam.com/video/6nJSUNh579w/v-deo.html
Hello, It is possible to eliminate odata.etag and ItemInternalId column from HTML table in solution which you showed 14:24? Table from 15:55. I've tried to build it from other values in custom way but it is going for apply to each container which won't work for it. Is there any solution to remove/hide this 2 colums which are added automatically?
@@DamoBird365 When I am trying to do it applt to each containter is created and it creates HTML table for each values not adding values in HTML table.. How it should like to define key and values to make it works?
Ah got you. It’s because a filter has been applied so it can be a bit confusing. I’ve a video on apply to each 😉 you’ll need to write the expressions item()?[‘name of field’] 👍
Hi, iam struggling to connect my power app to an excel file that resides in a folder inside a SharePoint document Library. When choosing data source, i can only connect to a list, but NOT a folder inside a document library. Any pointers would be appreciated.
@@DamoBird365 thanks I sorted it out. I do have another question on PowerApps though. this is regarding a "If" Statement that controls visiblity of a checkbox. in my SharePoint list (named "Reps for FLSMs"), I have a column called "HOS BUH Email" that is basically a column containing second level Approver email addresses. I have a checkbox "Select All" which should ONLY display when the logged in user is the same as one of the users in that "HOS" column above. so in the "visible" property of the checkbox, I provide this formula (which I think is correct), but it doesn't seem to work. I ve tried so much but no luck. can you help me identify what's wrong with this statement below? If('Reps for FLSMs'.'HOS BUH Email'=User().Email,true,false)
@@vvaassaanntthh if I were testing, I would create two temporary labels. One with user().email and the other with ‘Reps for FLSMs'.'HOS BUH Email’. Then you can see why your expression is not working as presumably they don’t match.
Thanks Damien, great vidoe. In my case I need to put dates into the email but when doing this they are just in the number format of 44771. Is their a way to format it in the htlm table as 12/06/2022 like it is in excel? Thanks.
My companies excel doest seem to have this option. I managed in power auto to wrap two composes inside an apply to each anf used the expression addDays('1899-12-30',int(outputs('Compose')),'dd-MM-yyy') on the output. But I'm not sure how to correctly use this output the as input reference for the expression inside the Creat HTML Table. Thanks for your guidance 🙏
It’s part of the list rows action under advanced. If you’re changing the format afterwards in create html table, you need to use advanced on create table and define the columns and expressions.
Heyy!!! Your video is very helpful to me, but faced a challenge.. when i created a HTML Table and added "Outputs from Compose" in "from" category, i did got the error stating the following "The 'from' property value in the 'table' action inputs is of type 'String'. The value must be of type 'Array'." Can you please help me with this?? i would be highly appreciated..
Hi Misbaah, you’ve supplied a string “this is a string”, rather than an array [“key”:”value”]. Check the dynamic value that you’ve supplied to the create html table.
@@DamoBird365 Hi Sir, A vey good afternoon, Thank you for the above comment, it helped me to get rid of the problem i faced.☺I've successfully created a HTML table and used the given styling. but again facing a challenge, it's of duplication. i'm getting multiple rows rather than getting a singly row of information. I've emailed you this ScreenShot at as SS can't be pasted here. Your help is highly needed. Email sent from- Misbaah Shaikh Subject Mentioned- UA-cam- Power Automate
Could you please help with the solution Example- excel file having multiple columns and rows for 10suppliers Now i wish to email 10 suppliers with their data from that excel Please guide
I appreciate the fact that you keep the errors you encounter instead of editing them out.
A similar solution is available on UA-cam but the way to make it simpler in terms of explaining is what I like about you. I really look forward to your videos. Thanks for your time and effort. You are helping people like me to do better in career.
Thank you so much for this video! Our leadership team was in a panic about how sending out a ton of individualized emails and this provided a perfect solution. I've never used PowerAutomate before and I was able to get this created in an hour.
This is what I was looking to expand to my Power Automate email series.
This was incredibly instructive, I'm going to be watching this 30 more times. So my problem is I want to do what you're doing here, but in Power BI, and I want Power Automate to filter what points are selected on a map of properties in Power BI, and send an e-mail with the loan numbers hyperlinked along with their addresses, city, postal code, etc. All the loan data is stored in Sharepoint. The hyperlink leads to an inspection form (already created in Power Apps). Thank-you if you do a video for this!
I’m a bit rough on BI. If I had a basic proof of concept to follow, I am sure I could create a solution though.
Amazing. It was just what I've been looking for hours. I really appreciated. Thanks for the clear explanation.
knowing about filter array was very useful. I was doing apply all condition and reading rows one by one. Super thanks 🙏
Awesome!! I was trying to make something like this but I was lost. I need to send many emails based on the client info when every client can have many contracts related and wanted to just do what you showed. Many thanks!
Thanks David 👍
Thank you so much. You helped me on my way to build automation for my work. I appreciate. :)
Thanks Damian. One further tip I would give. For any html emails put the html into a compose action and then inject the outputs of that into the email.
Why? Well that send email step has two modes standard editor and html. If you put things in the html editor and accidentally put it back to standard things get seriously messed up especially special characters like // etc. That has messed up some of my flows big time.
The other advantage of using the compose steps is you canconstruct emails in sections and inject outputs as you need them. If an output through some logical result is blank then the email has nothing to inject. Conversely you can insert sections of text or html conditionally. Without having to have multiple email steps.
Cool! Could you please point me in the direction of said method? 😀
Great video! Was looking for exactly this solution
Hey Daksha, glad you found it useful 👍
That was Awesome. Thanks for your help. It works and i'm able to achieve my requirement, in quite different way but manageable.
Thanks again ❤
What if we need to add a sum of total under each column for all rows values for each group of managers
Great help. God bless you
Hi.
I just noticed that my flow is sending the html table empty to contacts that don't have any information available.
How can I avoid this to happen... I have a contact list but not always they'll need to receive the email. Just when they have something pending in the mail table.
How could i fix this?
Because you are using your brain en list, one method would be to introduce a condition in the loop to check if the filter array output length() is greater than 0. The other option would be to create a distinct list of contacts based on the original data. Let me know if you crack it. 👍
perfect to. its a sollutions for my problem. create union and 2 condition with many key 👍👍👍👍
Hi, thank you for the great video! You have saved tons of my time! Some additional questions on this video - 1) can you please kindly guide if I could use cc/bcc function with this flow? If yes, is there a video that I can refer to? 2) can I also add/use Name in the email body? For example, instead of sending only the table, I was wondering if I could customize email body as: Hi XXX (Name), hope this email finds you well. :)
Thank you for your time!
You would use first() from the filter array to get the manager name. Cc and bcc are possibly advanced properties.
Si I was able do it!!! Yeiii! Now I really need your help because I need to send a 30 day reminder in email to those whose customers are expiring
Hi Verola, if you filter the get items by date and use a recurrence trigger you could achieve what you’re looking for. I don’t have a video, so I would suggest you try the forum just now powerusers.microsoft.com/
@@DamoBird365 I’ll try it thank you
Thank you for making such a nice video. it is really helpful.
Thank you for your video. How can I achieve this through Sharepoint? I'm trying to send emails to each row (each recipient) and add html table to each email as it pertains to.
LFG Damo this is what I have needed for over a week!! QQ - How to remove the Odata and IteminternalID columns?
@@alecseidman5601 🤘 nice. You can use custom columns on create html table.
@@DamoBird365 it’s giving me a for each on top of the create HtMl table, I tried to remove it but it gave me an error message. Have to try again I guess.
Thanks for the response!!
@@DamoBird365Nevermind I just got it, thank you so much!!! Saved me days of work!!!
Very helpful, thank you. I have a similar issue. However in my "managers" table I have all the possible managers. My second table only has information for a subset of those managers. The issue I have when I do the above is I end up sending empty emails to any manager who does not have data in table 2. How do I suppress those emails? I know its an inner join, but don't know how to do that on power automate. Thank you
You could use filter array? pnp.github.io/blog/post/comparing-two-arrays-without-an-apply-to-each/
Please make video on Power Automate Copilot
Take a look here
ua-cam.com/video/UGevh7WF_kM/v-deo.html
Can we send an follow up reminder email on top of the initial email with same subject..please explain
Is the follow up based on a number of days, or an action that you record the status of?
Hi Damian. Thanks for your explanations. I have a question. I did the filter array in my environment. It worked fine. However, when migrating the flow to production in my customer's environment the array does not filter and sends all the values in the email. Do you probably know what could be the reason? I checked and I followed the same steps as in my environment.
Thanks, Fabio
Hey Fabio, hard to be sure but I would take a look at the history output. Most likely the wrong dynamic value has been used for creating the html table? If this wasn’t a solution export/import, it’s usually human error. Maybe one for the forum? powerusers.microsoft.com/
@@DamoBird365 Thanks Damian, appreciate your help. I could figure it out. The two columns I was comparing had a slash (/) in their name. It was causing issues to filter the array.
@@FabioSilva-kj3bm thanks for sharing your findings
I have 5 excel files that are based on template of part timers attendance. Columns are dates, name, worked hours. I need to combine these every month into one excel or html table and send it to my mamager. The new table should have columns name, total hours and column for each day in that particular month (1,2,3,4,5 and so on).
How could i combine those excel files into one report using power automate?
I don’t believe an html table would view very well unless you split it into tables by week. If you wanted a portable file, excel would be better. But if I am honest, a list would be best as you could have all the data in a list and have views or group by the employees.
When changing css for one table it is applying in all tables can you help in this.
You could consider inline 👉 Advanced HTML Tables in Power Automate - Formatting cells, rows and vertical tables
ua-cam.com/video/LQumCR1B-q0/v-deo.html
Just wanted to add my thanks to posting this video! Great stuff. I am new to Power Automate. I was able to recreate the initial scenario with a separate unique manager table. However, when I removed that table from the flow, my "Send an email" action was preceded by a second "Apply to each" and many duplicate emails were sent. I think this occurred because in my email body, I was trying to include a field from the Data table (in my case, it was the first name of the manager).
Any tips on how to add this from the Data table itself (for instance, the column H value from your video 1:42)?
You want to write your own expression, as it will be based on the array value in the apply to each and not the original data source. Adding the dynamic data from the original data source will create an additional apply to each. ua-cam.com/video/d99Rr5djcME/v-deo.html
Hello Sir, thanks for the guidance, I would like to ask some more guidance, how to filter Excel rows with a client code or unique email address and send them an HTML table with their list of invoices using Power Automate. I have a multiple clients' list in an Excel file, with columns for invoice dates, invoice amount, paid payment, remaining balance, and remarks. In the same Excel sheet, I have additional columns like a customizable subject column, a customer unique ID for each client, and email recipients (To and CC). Could you please guide me on how to filter the Excel rows based on the client code or unique email address and then send them an HTML table with their list of invoices using Power Automate?
You could combine this video with
ua-cam.com/video/-oz9R6pJv94/v-deo.html
@@DamoBird365 Thank you for the guidance Sir
I need help. I have a excel in SharePoint and I want to trigger an email each time a person adds or updates that excel file . The email must contain who modified and the data that was modified. Please help me please
Thank you, this video was very helpful and exactly what I was looking for.
Cheers Euddy, appreciate the support 👍
Hello Sir, i wan to mention attention lile " Dear " in top the mail. Please advise is there any way?
You could lookup the user name based on the email address?
in apply to each under filter array action, when I select Email from dynamic value it automatically created For each section. Then I selected email after equals to, it added another For Each... how to avoid that or what am I doing wrong?
Most likely down to the from of your filter is not directly related to your email field. I have a video that explains apply to each: Power Automate | Apply to Each | Why? | Arrays and Objects
ua-cam.com/video/d99Rr5djcME/v-deo.html let me know if it helps.
@@DamoBird365 Thanks a lot, sure! will jump into that. Thanks a lot for your videos
Hi I am doing something very similar but my filter array is returning blank output can u help me understand why is that so please
It will be your condition not equaling true for any records. Look at the history input to the filter array. Look for the value you are filtering. String conditions are case sensitive. Let me know how you get on 👍
@@DamoBird365
Hi after years😂😂 I was able to make it
The problem was since my data was too large I needed to go to settings of list rows and change the pagination threshold
Thank you so much buddy for the help
Can you please also guide me if I want to add the data into an excel file and then send the file as an excel attachement in the mail
My employer uses Office 365 but nobody uses Power Automate. I was looking for a VBA routing to do exactly what this demo does except that I did not expect to find code that could retrieve multiple rows of data for a single user and send a single email. I thought at best, certain users would receive multiple emails corresponding to how many rows of data pertain to that user.
Then I came across this video, and it does exactly what I need. So deskside support downloaded the desktop version. However, I was very frustrated to find that when I search actions there is no " list Rows present in a Table". The interface doesn't even look like this video. The dream came to an end. I am sure there must be another set of actions to get to the same place but I don't have the expertise to figure that out. I am baffled as to why "List Rows Present in a Table" is totally missing!
Hi there Ginger. You are looking at Power Automate Desktop, which is for local pc based automation known as RPA. You want cloud based automation, power automate. This is accessed via the web only.
your are genious , I'm new to power automate and using your material was instrumental ! thank you , now I'd like to do the samething but from a desktop flow ( files are on a local network drive, not a cloud drive ), any info how to move on would be great !
Hi Eric, thanks for your feedback. You could use Power Automate Desktop for which I don’t have many videos or there is a cloud connector for local files. It depends on your use case.
Thanks Damian, have you got any videos using the desktop version, the processes you are using in this video, is not available to me on the desktop version? I can't find any other videos that have exactly what you demonstrate above, but in the desktop version. Any help would be much appreciated!
I don’t I’m afraid. I’ll add it to my list. I definitely like a bit of desktop RPA but I lack access to legacy systems for a demo.
@@DamoBird365 thanks for the reply. Do you know how I can pick up computer files using the web version? Instead of using one drive or share point files? My share point is in a different location than the share point on my office account. Thanks
Are you still talking desktop or cloud flows? A cloud flow has a connection reference which is the user credentials. You could use credentials that attach to this other tenant you mention. Desktop I am unsure.
how to add filter data step or anyway before send to email. example : send only data in Tot3 columns > 150. I just learn about power automate. thank you.
Take a look at the filter array action?
It was verry useful watching this video. I managed to create my own automation flow using the steps explained in your video. I'm having an issue though. The styling of the table it's only applied to the first table and not the second one. What could be wrong? I also added a Compose action and added the html table styling there, before the Send an Email action witch also only applies the styling to the first table. Thank you!
I’m not sure to be honest. Are you using the create table action for both? Let us know how you solve it when you do.
@@DamoBird365 It worked for me by changing both HTML tables to [Curent item]
@DamoBird365 is there any possible way to embed pivot tables in email body using powerautomte
Are you trying to do something like: Power Automate - Fast Data Aggregation - Group By, Sum, Count #powerautomate
ua-cam.com/video/z5MxbwURV68/v-deo.html
@@DamoBird365 No I wanted excel pivot table to be sent in email body using powerautomte
Hi Damien, have a question about styling this table - I can't figure out how to apply a background color to specific columns, or a background color for specific rows. I've watched other videos you posted about if statements, but it's not for a "create an HTML table" action, it was on a select. Any ideas? Thanks!
@@alecseidman5601 you can’t apply formatting to specific cells with the basic create html table. Hence my demo of using a select to build the html table. It’s because you would need to edit the tags in create html which you can’t do. I’ve seen some folk do a find /replace after the create html, but I would suggest select is cleaner.
@@DamoBird365 Hi, sounds good - Can I apply the Compose with a Union to have a distinct array of emails as well as a select for the HTML table? I just don't want to lose the ability to send distinct emails
@@alecseidman5601 yes, have the compose in the apply to each. Each loop will have its own html table made by the select, which can be based on a filter.
@@DamoBird365 You are the best, I got it now! Thank you for your help, truly appreciate it!!
Great video! I'm learning a lot! Is there some way to do this with just 1 table. I want to email managers a list of thier employees and the hours they worked that week. Any advice?
Hey Dionne, you should be able to just have 1 filter and 1 create table in the loop. Hope that helps. Let me know how you get on.
I don’t have two tables just one … how can I do that with one table?
I explain later in the video how to get the distinct managers (instead of a separate table) using the union expression. Hope that helps.
Excelente!! 👍👍👍👍
Is it possible to add a condition that if a cell from our table is empty to not show in our HTML table from the email? For ex. If "Tot 3" is empty for Manager 4, than not add the column in that email that is sent?
I don’t fully understand, but if you can perform a condition on your array to do the check you mention, you can then branch yes/no and use a select action to add or remove the key/column in question. Or use advanced on create html table.
Hi Damian, can include the total of integer values in the report sent to outlook? Is there any way?
I mean, I would like to include a total of Text1, text2 & Text3 as a new raw when I receive mail in outlook.. Please help.
Hey very helpful video, its helped us automate our very manual quarterly access reviews for application access. Is it possible to set the table cell widths or to carry a dropdown through from Excel?
Thanks for sharing. To format the columns you could use replace() on the table output to add a colgroup. www.w3docs.com/snippets/css/how-to-set-the-width-of-the-table-column.html include the tag in a compose with the colgroup and replace the table tag with the content of the compose. Let me know if that works?
@@DamoBird365 The above worked perfectly.
Great video Damian. Thank you for sharing your knowledge and making awesome PA videos. I've learned so much from you. You make it look very simple.
I have a question, it's similar case as this video but taking one step further, asuming that each employee are members of different branches, in this example, let's assume employee 10 and 11 belong to branch New York and the rest to branch New Jersey, how would you automatically create a html table for each branch with a headed branch location to identify each branch per table? I could have 3, 4, or more branches so I'd like to see a html table group by employee per branch. Is this even possible?
Thank you Mario. Anything is possible 😀 well most of the times! Can you send me an example? The user on the forum gave me everything I needed, sample data and expected output. Here is another example on the forum which makes a very good use case powerusers.microsoft.com/t5/General-Power-Automate/Compare-Two-Array-for-Each-Unique-ID-and-Send-Email/m-p/1461516#M86313
Hello Damian,
Very nice Video and a proper business related issue you covered here. I did for my self an it worked out .Thanks for your time
Additionally, by any chance, if we need output on Excel instead of HTML with multiple data, will this be possible.
Thank you
It would be possible yes. I have a video on how to create new Excel files here ua-cam.com/video/RB_ySjhm9Sg/v-deo.html
Hi damian, in the email, i would like to state what the sum of all the values for that email address is, how would i do this? have you got a video on this? thanks, timo
I’ve not but I could look to do this. Unfortunately power automate only is an add which accepts two values. This results in the need for an apply to each but there are other ways which I can try and demonstrate.
Hi, Thanks for this. Instead of creating one HTML table for each email address, can you guide me on how to create a separate excel file for each email address, so there should be multiple rows in each file? I can create a file but I ended up with only one row each and then my flow failed. I likely have the apply-to-each incorrect but i don't know how to fix it. Also, should I be using apply-to-each if my source file as 7000+ rows? Thanks.
Hi Carina, I like this use case. Can you drop me more info to ideas@damobird365.com.
@@DamoBird365 Hi! Did you ever create a video for this use case?
This video is really helpful and I got what I'm looking for. I would like to know how can we get last few rows (ex. last 10 rows values out of 30 values)data and send it in email. Could you please help with that.
You could get all rows and then use skip() expression on your array.
@@DamoBird365 thanks, I'll try that. If you have any reference, please share
Excellent video thanks. I followed this logic however, I saw on your first email test the two tables.
For the life of me I can't seem to enforce the same column width for columns in both tables.
I've tried CSS, tlreolaving the header with explicit column widths but nada.
It seems this may be a big?
I know you've encountered it it. Have you looked into that issue as well?
Cheers
I’m not sure Carl. Have you tried your flow generated html in a wysiwyg editor? Build the html in a compose and then copy it from history to paste online to see the output.
@@DamoBird365 Yes in a sense. I got my styling from Ryan Maclean's site and W3Schools. Also obtained my table header example from Grant Jenkins on Power Automate forum.
I've found if you go the route of using advanced options under create table with custom columns it works. BUT now my tables are well formatted and void of data. 🙄🙄
It's always something with MSFT products. You can do this and do that but only if it's a Tuesday with a full moon.
@@carlw luck and patience are definitely part of building flows 👍
@@DamoBird365 Haha, ya really. 😀🤔
hi Buddy this is very useful. i also want to know (for our requirement) on how to ensure the relevant managers can ONLY see their own rows of data (in the emails they receive respectively). can you pls add that information as well?
So far, I was able to get this tested successfully with the formatting. however if there are say 5 managers in that excel, and each manager is supposed to ONLY see the rows for their reportees, how can I achieve that, and what condition can I include in this flow (and where can i add that step in this flow)?
I however would also like to know, if each manager email address (in the excel) Can get the data of their own respective members.
Here are my questions :
Question 1 :
Manager 1 --> has user A and User B under himManager 2 --> has user C and User D under him
So whenever emails are sent to Manager 1 (to approve), the email should ONLY contain the rows for user A and User B (similarly for manager 2)
Question 2 :
If Manager 1 gets the email with the user A and B row lines, he should individually be able to approve/deny each line (ie, he approves user A line, and maybe deny User B line). Is that possible? I would really like to know how this can be done.
Hi there. Q1 you can get the distinct managers using a select in text mode, insert the manager email and then perform a union on this result x2 in a compose. You can then supply the manager array to an apply to each, filter your data based on manager = current item and perform the rest of your html table requirements. Each loop would be done on a manager by manager basis. Q2: approving each item, is a bit more trickier and I don’t think power automate is best suited. I would possibly recommend a power app if you want to approve on a line by line basis.
@@DamoBird365 For question 2, I am trying to find videos that explain how Managers can approve/deny only individual employee rows that belong to them. Can you possibly point me to a good resource that explains how to set this up in a canvas app? How do I create the logic in the powerapp, that each manager only sees their own respective reportees data to individually approve/deny? Each manager should see only his own data to do line level approval. How do I do that in power app? any pointers would be appreicated
can we get table borders in mail. As of now in your video it was just text right in table format. Could you please show how we can do that too..
You could just add in a style tag for table borders - check out the examples here www.w3schools.com/html/html_table_borders.asp
Hello Damian, great video!. I need to send an e-mail with both text (eg. this is your commision for the month [april] , where [april] is extracted from the excel table column A) and below a table with data (columns B-H). I have a table where one manager appears just once so I do not need to combine rows. I need to go row after row sending extracted data. From your videos I know how to send an e-mail with changing texts and an e-mail with just the table, but I have no idea how to join them into one e-mail. Could you help me :) ?
Hi Aleksandra, you can add both dynamic values into the send email action? If you build the first sentence in a compose and the table via create html table, you can add both outputs from these actions into your email. If you are struggling to get the month (maybe you get an apply to each?), from a table of rows, you can use first() or [0] as seen here ua-cam.com/video/6nJSUNh579w/v-deo.html
@@DamoBird365 Thank you very much! :)
Hello,
It is possible to eliminate odata.etag and ItemInternalId column from HTML table in solution which you showed 14:24? Table from 15:55.
I've tried to build it from other values in custom way but it is going for apply to each container which won't work for it.
Is there any solution to remove/hide this 2 colums which are added automatically?
Sure, pop open the advanced tab on create html table and then define you keys (column name) and values, the dynamic content.
@@DamoBird365 When I am trying to do it applt to each containter is created and it creates HTML table for each values not adding values in HTML table.. How it should like to define key and values to make it works?
Ah got you. It’s because a filter has been applied so it can be a bit confusing. I’ve a video on apply to each 😉 you’ll need to write the expressions item()?[‘name of field’] 👍
@@DamoBird365 thanks :) Now works as it should
Hi, iam struggling to connect my power app to an excel file that resides in a folder inside a SharePoint document Library. When choosing data source, i can only connect to a list, but NOT a folder inside a document library. Any pointers would be appreciated.
I would try the Ms forum powerusers.microsoft.com/
@@DamoBird365 thanks I sorted it out. I do have another question on PowerApps though.
this is regarding a "If" Statement that controls visiblity of a checkbox.
in my SharePoint list (named "Reps for FLSMs"), I have a column called "HOS BUH Email" that is basically a column containing second level Approver email addresses. I have a checkbox "Select All" which should ONLY display when the logged in user is the same as one of the users in that "HOS" column above.
so in the "visible" property of the checkbox, I provide this formula (which I think is correct), but it doesn't seem to work. I ve tried so much but no luck. can you help me identify what's wrong with this statement below?
If('Reps for FLSMs'.'HOS BUH Email'=User().Email,true,false)
@@vvaassaanntthh if I were testing, I would create two temporary labels. One with user().email and the other with ‘Reps for FLSMs'.'HOS BUH Email’. Then you can see why your expression is not working as presumably they don’t match.
Thanks Damien, great vidoe. In my case I need to put dates into the email but when doing this they are just in the number format of 44771. Is their a way to format it in the htlm table as 12/06/2022 like it is in excel? Thanks.
If you’re extracting dates from excel looking under advanced options for date format and select iso 8601.
My companies excel doest seem to have this option. I managed in power auto to wrap two composes inside an apply to each anf used the expression addDays('1899-12-30',int(outputs('Compose')),'dd-MM-yyy') on the output. But I'm not sure how to correctly use this output the as input reference for the expression inside the Creat HTML Table. Thanks for your guidance 🙏
It’s part of the list rows action under advanced. If you’re changing the format afterwards in create html table, you need to use advanced on create table and define the columns and expressions.
Ah amazing, I see now. Just need to figure out the right expression now. Thanks a mill 🔥
I got with formatDateTime(item()?['Column Header'],'dd/MM/yyy') after changing to iso 8601. Thanks again pal 👍
Heyy!!!
Your video is very helpful to me, but faced a challenge.. when i created a HTML Table and added "Outputs from Compose" in "from" category, i did got the error stating the following "The 'from' property value in the 'table' action inputs is of type 'String'. The value must be of type 'Array'." Can you please help me with this?? i would be highly appreciated..
Hi Misbaah, you’ve supplied a string “this is a string”, rather than an array [“key”:”value”]. Check the dynamic value that you’ve supplied to the create html table.
@@DamoBird365
Hi Sir,
A vey good afternoon,
Thank you for the above comment, it helped me to get rid of the problem i faced.☺I've successfully created a HTML table and used the given styling. but again facing a challenge, it's of duplication. i'm getting multiple rows rather than getting a singly row of information.
I've emailed you this ScreenShot at as SS can't be pasted here. Your help is highly needed.
Email sent from- Misbaah Shaikh
Subject Mentioned- UA-cam- Power Automate
I have a excel file for multiple suppliers, now i wish to share them the details to them by creating a table in email with their details only
Can you share with me further details as I am not clear what you are trying to achieve ? You can tag me on the forum if need be.
Could you please help with the solution
Example- excel file having multiple columns and rows for 10suppliers
Now i wish to email 10 suppliers with their data from that excel
Please guide
Sorry I missed your comment. I’ve just done another video that might help with explanation ua-cam.com/video/pwJ73jFEtDQ/v-deo.html