Send Unique Emails with HTML Table using Data from Excel

Рет қаралды 37,021

Күн бұрын

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 ☕

Пікірлер: 130

@FabioSilva-kj3bm Жыл бұрын

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

@anshukumari8982 2 жыл бұрын

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

@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 9 ай бұрын

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

@race4win 6 ай бұрын

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

@euddyrodriguez3603 2 жыл бұрын

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

@DamoBird365 2 жыл бұрын

Cheers Euddy, appreciate the support 👍

@kunalIndia 4 ай бұрын

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.

@dakshaagarwal4018 Жыл бұрын

Great video! Was looking for exactly this solution

@DamoBird365 Жыл бұрын

Hey Daksha, glad you found it useful 👍

@pramodagarwal1990 10 ай бұрын

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

@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

@navinnathan7015 Жыл бұрын

Great help. God bless you

@ardeykurniawan1916 2 жыл бұрын

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

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

@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

@divya7555 Жыл бұрын

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.

@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

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

@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. kzfaq.info/get/bejne/mp9phdVmydDHfXk.html

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

@maazahmed2607 Жыл бұрын

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 kzfaq.info/get/bejne/iKiPrLabzdOdg5s.html

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

@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 Ай бұрын

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

@robertjeffers8439 7 ай бұрын

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 7 ай бұрын

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

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

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

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

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

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

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

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

@rvr1369 4 ай бұрын

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

@DamoBird365 4 ай бұрын

Are you trying to do something like: Power Automate - Fast Data Aggregation - Group By, Sum, Count #powerautomate kzfaq.info/get/bejne/sJt9q8Wouri6Zmw.html

@rvr1369 4 ай бұрын

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

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

@pramodagarwal1990 10 ай бұрын

Please make video on Power Automate Copilot

@DamoBird365 10 ай бұрын

Take a look here kzfaq.info/get/bejne/i62VqctovKzDm4E.html

@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

@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

@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

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

@herviolentheart 9 ай бұрын

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 9 ай бұрын

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

@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 kzfaq.info/get/bejne/Y9WqbLVn1bDaaWg.html

@naeeminfo Жыл бұрын

@@DamoBird365 Thank you for the guidance Sir

@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 kzfaq.info/get/bejne/bNR6hrh_zZubaas.html

@aleksandraszlegier1812 Жыл бұрын

@@DamoBird365 Thank you very much! :)

@iamalikesodia Ай бұрын

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

@DamoBird365 Ай бұрын

You could consider inline 👉 Advanced HTML Tables in Power Automate - Formatting cells, rows and vertical tables kzfaq.info/get/bejne/greloKaDlqiRoWQ.html

@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

@MAD12MIDGET 6 ай бұрын

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 6 ай бұрын

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.

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

@puneetgupta9827 9 ай бұрын

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 9 ай бұрын

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

@olkuszanin1 11 ай бұрын

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 11 ай бұрын

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

@olkuszanin1 11 ай бұрын

@@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 11 ай бұрын

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 11 ай бұрын

@@DamoBird365 thanks :) Now works as it should

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

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

@kumarirakhi75 18 күн бұрын

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 18 күн бұрын

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 kzfaq.info/get/bejne/mp9phdVmydDHfXk.html let me know if it helps.

@kumarirakhi75 17 күн бұрын

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

@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- KZfaq- Power Automate

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

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

@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 kzfaq.info/get/bejne/pt16apabq6vYdIU.html