Send Unique Emails with HTML Table using Data from Excel

Подписаться 13 тыс.

Просмотров 38 тыс.

50% 1

How to combine two tables in excel to form one email per user, using Power Automate, Filter Array Actions, HTML Formatting / Styling, and Excel.
Also, learn how to get unique managers /emails using select and compose (with union) and create an array of Distinct Email Addresses.
This video is a demo of how to solve the following question on the forum powerusers.microsoft.com/t5/B....
Sample Styling for HTML Table www.w3schools.com/Css/tryit.a...
To date I have answered 400+ solutions as a super user and this is an insight into how I build out a solution for an end user. Contributing to the forum is a great way to accelerate your understanding and career. Feel free to reach out to me as DamoBird365 on LinkedIn / Twitter & Reddit or drop me a message below.
00:00 Intro
00:46 Getting the data setup in Excel
01:55 Creating the PowerAutomate Flow
03:31 Filter Array
07:00 Email HTML Table Styling
08:24 Running the flow
09:17 Editing the columns returned by Create HTML Table
11:25 Using Select, Compose, Union to get Distinct Email Addresses
14:22 quick overview of new Solution with Distinct Emails
15:20 Woopsie - dynamic Email no longer exists
15:55 Review of Flow History and Exploring the Distinct Array of Emails
16:21 Outro
Also check out • Transform Excel Data i...
#PowerAutomate #FlowNaut #Tables #Excel #Email Please buy me a coffee www.buymeacoffee.com/DamoBird365 ☕

Наука

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 131

@anshukumari8982 2 года назад

A similar solution is available on RU-vid 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.

@FabioSilva-kj3bm Год назад

Amazing. It was just what I've been looking for hours. I really appreciated. Thanks for the clear explanation.

@allrise4 Год назад

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.

@qww760 10 месяцев назад

This is what I was looking to expand to my Power Automate email series.

@race4win 7 месяцев назад

knowing about filter array was very useful. I was doing apply all condition and reading rows one by one. Super thanks 🙏

@kunalIndia 5 месяцев назад

Thank you so much. You helped me on my way to build automation for my work. I appreciate. :)

@erinfield1943 2 года назад

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!

@DamoBird365 2 года назад

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.

@euddyrodriguez3603 2 года назад

Thank you, this video was very helpful and exactly what I was looking for.

@DamoBird365 2 года назад

Cheers Euddy, appreciate the support 👍

@salmanriaz5184 11 месяцев назад

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 ❤

@salmanriaz5184 11 месяцев назад

What if we need to add a sum of total under each column for all rows values for each group of managers

@dakshaagarwal4018 Год назад

Great video! Was looking for exactly this solution

@DamoBird365 Год назад

Hey Daksha, glad you found it useful 👍

@pramodagarwal1990 11 месяцев назад

Thank you for making such a nice video. it is really helpful.

@navinnathan7015 Год назад

Great help. God bless you

@ardeykurniawan1916 2 года назад

perfect to. its a sollutions for my problem. create union and 2 condition with many key 👍👍👍👍

@divya7555 2 года назад

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.

@garcialex06 Год назад

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!

@DamoBird365 Год назад

Thanks David 👍

@diegomartin5250 2 года назад

Excelente!! 👍👍👍👍

@45Benning 12 дней назад

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.

@robertjeffers8439 8 месяцев назад

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

@DamoBird365 8 месяцев назад

You could use filter array? pnp.github.io/blog/post/comparing-two-arrays-without-an-apply-to-each/

@user-fy3sp2fr5q Год назад

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)?

@DamoBird365 Год назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-d99Rr5djcME.html

@mariolopez-od7pr 2 года назад

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?

@DamoBird365 2 года назад

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

@mmbcampus 11 месяцев назад

Hello Sir, i wan to mention attention lile " Dear " in top the mail. Please advise is there any way?

@DamoBird365 11 месяцев назад

You could lookup the user name based on the email address?

@deepavk_queen Год назад

Can we send an follow up reminder email on top of the initial email with same subject..please explain

@DamoBird365 Год назад

Is the follow up based on a number of days, or an action that you record the status of?

@Bal2k13 Год назад

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?

@DamoBird365 Год назад

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?

@Bal2k13 Год назад

@@DamoBird365 The above worked perfectly.

@MAD12MIDGET Год назад

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 Год назад

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.

@MAD12MIDGET Год назад

@@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

@DamoBird365 Год назад

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.

@rvr1369 5 месяцев назад

@DamoBird365 is there any possible way to embed pivot tables in email body using powerautomte

@DamoBird365 5 месяцев назад

Are you trying to do something like: Power Automate - Fast Data Aggregation - Group By, Sum, Count #powerautomate ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-z5MxbwURV68.html

@rvr1369 5 месяцев назад

@@DamoBird365 No I wanted excel pivot table to be sent in email body using powerautomte

@verolaj5119 Год назад

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

@DamoBird365 Год назад

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/

@verolaj5119 Год назад

@@DamoBird365 I’ll try it thank you

@herviolentheart 10 месяцев назад

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?

@DamoBird365 10 месяцев назад

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. 👍

@maazahmed2607 2 года назад

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

@DamoBird365 Год назад

It would be possible yes. I have a video on how to create new Excel files here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RB_ySjhm9Sg.html

@carinaslim2378 2 года назад

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.

@DamoBird365 2 года назад

Hi Carina, I like this use case. Can you drop me more info to ideas@damobird365.com.

@dionneclarke5568 Год назад

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?

@DamoBird365 Год назад

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.

@iamalikesodia 2 месяца назад

When changing css for one table it is applying in all tables can you help in this.

@DamoBird365 2 месяца назад

You could consider inline 👉 Advanced HTML Tables in Power Automate - Formatting cells, rows and vertical tables ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LQumCR1B-q0.html

@kareldurovic5061 Год назад

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?

@DamoBird365 Год назад

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.

@robert2crazy1 Год назад

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?

@DamoBird365 Год назад

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.

@pravrambo2848 2 года назад

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

@DamoBird365 2 года назад

You could just add in a style tag for table borders - check out the examples here www.w3schools.com/html/html_table_borders.asp

@ericcaron5654 Год назад

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 !

@DamoBird365 Год назад

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.

@KamaleshwarN 2 года назад

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.

@DamoBird365 2 года назад

You could get all rows and then use skip() expression on your array.

@KamaleshwarN 2 года назад

@@DamoBird365 thanks, I'll try that. If you have any reference, please share

@robert2crazy1 Год назад

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!

@DamoBird365 Год назад

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.

@robert2crazy1 Год назад

@@DamoBird365 It worked for me by changing both HTML tables to [Curent item]

@MAD12MIDGET 7 месяцев назад

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

@DamoBird365 7 месяцев назад

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.

@carlw Год назад

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

@DamoBird365 Год назад

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.

@carlw Год назад

@@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.

@DamoBird365 Год назад

@@carlw luck and patience are definitely part of building flows 👍

@carlw Год назад

@@DamoBird365 Haha, ya really. 😀🤔

@apacsvcmarketingcytiva6282 2 месяца назад

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!

@DamoBird365 2 месяца назад

You would use first() from the filter array to get the manager name. Cc and bcc are possibly advanced properties.

@GregDolan 2 года назад

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.

@DamoBird365 2 года назад

If you’re extracting dates from excel looking under advanced options for date format and select iso 8601.

@GregDolan 2 года назад

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 🙏

@DamoBird365 2 года назад

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.

@GregDolan 2 года назад

Ah amazing, I see now. Just need to figure out the right expression now. Thanks a mill 🔥

@GregDolan 2 года назад

I got with formatDateTime(item()?['Column Header'],'dd/MM/yyy') after changing to iso 8601. Thanks again pal 👍

@FabioSilva-kj3bm Год назад

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

@DamoBird365 Год назад

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/

@FabioSilva-kj3bm Год назад

@@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.

@DamoBird365 Год назад

@@FabioSilva-kj3bm thanks for sharing your findings

@puneetgupta9827 10 месяцев назад

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

@DamoBird365 10 месяцев назад

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 👍

@puneetgupta9827 4 месяца назад

@@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

@teerawutdireksri8861 Год назад

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.

@DamoBird365 Год назад

Take a look at the filter array action?

@naeeminfo Год назад

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?

@DamoBird365 Год назад

You could combine this video with ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--oz9R6pJv94.html

@naeeminfo Год назад

@@DamoBird365 Thank you for the guidance Sir

@vvaassaanntthh 2 года назад

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)?

@vvaassaanntthh 2 года назад

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.

@DamoBird365 2 года назад

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.

@vvaassaanntthh 2 года назад

@@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

@vvaassaanntthh 2 года назад

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 2 года назад

I would try the Ms forum powerusers.microsoft.com/

@vvaassaanntthh 2 года назад

@@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)

@DamoBird365 2 года назад

@@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.

@aleksandraszlegier1812 Год назад

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 :) ?

@DamoBird365 Год назад

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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6nJSUNh579w.html

@aleksandraszlegier1812 Год назад

@@DamoBird365 Thank you very much! :)

@olkuszanin1 Год назад

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 Год назад

Sure, pop open the advanced tab on create html table and then define you keys (column name) and values, the dynamic content.

@olkuszanin1 Год назад

@@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?

@DamoBird365 Год назад

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’] 👍

@olkuszanin1 Год назад

@@DamoBird365 thanks :) Now works as it should

@kumarirakhi75 Месяц назад

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?

@DamoBird365 Месяц назад

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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-d99Rr5djcME.html let me know if it helps.

@kumarirakhi75 Месяц назад

@@DamoBird365 Thanks a lot, sure! will jump into that. Thanks a lot for your videos

@Worrelpa 2 года назад

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.

@carlw Год назад

Cool! Could you please point me in the direction of said method? 😀

@gingerlane6401 2 года назад

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!

@DamoBird365 2 года назад

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.

@verolaj5119 Год назад

I don’t have two tables just one … how can I do that with one table?

@DamoBird365 Год назад

I explain later in the video how to get the distinct managers (instead of a separate table) using the union expression. Hope that helps.

@pramodagarwal1990 11 месяцев назад

Please make video on Power Automate Copilot

@DamoBird365 11 месяцев назад

Take a look here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UGevh7WF_kM.html

@ThakralShubham 2 года назад

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

@DamoBird365 2 года назад

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.

@misbaah9978 Год назад

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

@DamoBird365 Год назад

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.

@misbaah9978 Год назад

@@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- RU-vid- Power Automate

@ThakralShubham 2 года назад

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

@DamoBird365 2 года назад

Sorry I missed your comment. I’ve just done another video that might help with explanation ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pwJ73jFEtDQ.html