This is such a fantastic video, How many times I end up on your videos while dealing with actual customer requests is insane! How do I send you a check?

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.

Awesome, but can you help how to store the selected answers into the list for the all the 10 questions

Hi, thanks a lot for this vidéo! Really helpfull! In my companie we avoid blob storage due to data security, do you have any alternative to it?

Awesome

I love you! This is exactly I was looking for! Thank you!

Hi @DamoBird365 - thank you for your video, I have built 3 beautiful vertical tables, formatting correctly and sending by email with no prior HTML experience! What I am struggling with is how to apply the conditional formatting (if expression) to the 'Concat' function used in the Select action for the vertical table, as it is in the text method rather than the array method. Can you explain how you would add the IF expression (I need 3 conditions for IF=[Yes, no or N/A]) to row 3 in your vertical table where you have used the concat expression?

Hello how can I send to multiple users

Brilliant video. Awesome explanation

This solution doesn't seem to work for shared mailbox is there a work around?

Thanks!

Nice work, I think it's crazy that you have to use a patch statement to update a collection value in application that you have full control. you would think you could use set(). Also you seleted the first three items in your control? Please tell me that isn't because you can only leverage the check and uncheck properties for control state? If that really is the case once again wouldn't just use a if(), case() switch() or whatever PowerApps call it?

Hi, Great Content. Do you have any steps that would allow me to update the metadata fields for those duplicate records?

Hi, Great content. Do you have any steps that would update a SharePoint List when duplicate records are found?

Hi Damien. Your video is super-informative and pretty easy for a layman like me to understand. I followed it step-by-step, except in my case I am running a query against a Power BI dataset. I'm certainly not an expert and I mimicked your flow as closely as possible but, I think that my attempt is failing because I can't seem to get the grouped categories into the same structure as your in the XML output. My output looks like this: [ { "Category": "" }, { "Category": "- ACC CLOSED" }, { "Category": "- ADD INCOME" }, { "Category": "- INTERNAL" }, { "Category": "* CASH 1 _DEL Mon - INV Fri - CALL Thu" }, { "Category": "* CASH 2 _DEL Tue - INV Mon - CALL Fri" }, { "Category": "* CASH 3 _DEL Wed - INV Tue - CALL Mon" }, { "Category": "* CASH 4 _DEL Thu - INV Wed - CALL Tue" }, { "Category": "* CASH 5 _DEL Fri - INV Thu - CALL Wed" }, { "Category": "* EFT 1 _DEL Mon - INV Fri - CALL Thu" }, { "Category": "* EFT 2 _DEL Tue - INV Mon - CALL Fri" }, { "Category": "* EFT 3 _DEL Wed - INV Tue - CALL Mon" }, { "Category": "* EFT 4 _DEL Thu - INV Wed - CALL Tue" } ] As you can see, my output contains all of the squiggly brackets { } and I can only guess that it is this that is the stumbling block for later flow steps. I get this message at the Compose XML step "This XML file does not appear to have any style information associated with it. The document tree is shown below." <root> <values> <results> <tables> <rows> <CUSTOMER_x0020_LISTING_x005B_Category_x005D_/> <DAYS_x0020_OUTSTANDING_x005B_Customer_x005D_>72 DEGREES BAKERY & FROZEN FOODS</DAYS_x0020_OUTSTANDING_x005B_Customer_x005D_> <DAYS_x0020_OUTSTANDING_x005B_120_x002B__x0020_Days_x005D_>0</DAYS_x0020_OUTSTANDING_x005B_120_x002B__x0020_Days_x005D_> <DAYS_x0020_OUTSTANDING_x005B_90_x0020_Days_x005D_>0</DAYS_x0020_OUTSTANDING_x005B_90_x0020_Days_x005D_> <DAYS_x0020_OUTSTANDING_x005B_60_x0020_Days_x005D_>2314.5</DAYS_x0020_OUTSTANDING_x005B_60_x0020_Days_x005D_> <DAYS_x0020_OUTSTANDING_x005B_30_x0020_Days_x005D_>0</DAYS_x0020_OUTSTANDING_x005B_30_x0020_Days_x005D_> <DAYS_x0020_OUTSTANDING_x005B_Current_x005D_>0</DAYS_x0020_OUTSTANDING_x005B_Current_x005D_> <DAYS_x0020_OUTSTANDING_x005B_Total_x0020_Due_x005D_>2314.5</DAYS_x0020_OUTSTANDING_x005B_Total_x0020_Due_x005D_> I'm very inexperienced and not entirely sure that I have identified the actual error but it is the one thing that stands out for me. I'd really appreciate it if you could point me in the right direction. It will save me bucket loads of time if I can get the desired result. I've spent so much time on this and I'm super keen to get a positive result. Many thanks for your assistance, Andrew

This is great, I'm struggling a bit to combine this with your previous video, where you get an array of the tables then loop through that based on manager name. In this video you do not use the create html table action, should I just replace the create html table action with the first select from this video. If not what would be the alternative?

Do you have an example of calling an array from an Excel workbook where you haven't manually input the arrays in the back end of the flow? I'm trying to follow your code to build a table at 7:00, but I just have strings. Can I fill in a range with strings?

3:50- examplevar1-4

4:27- his office script accepts an array 5:18- "Select" action gives you an array 7:19- "array of data"

Without blob storage is it possible to chose onedrive path as a output folder for converted file

this method don't work while trying to send 5000 rows , I always get bad gateway error after 15 min, if I limit the data to 100 it works

Good day! Can this be done in cases where there are separate activities on a single canvas app? If so, how would we do it? Thank you

Followed the steps. Worked for about 10 documents and now all the documents are corrupted. Any ideas ? Thanks a lot!

This really helped, as i have a query on 3 lists (parent, 2 child lists) and wanted to bring the latest details into a table. The select after the apply to each to grab the results from the array variable was perfect! Thanks for the detailed explanation!

Thank you! This video is all I've wanted for the past 2 weeks. But I don't know what you put in the first compose (filecontent) because I can't create a table and my excel file is unusable. I want to export the information from my PowerBI report to my Excel file

How can we get it so the flow outputs all of the current incidents from the services? For example, I built the flow as you describe but I’m only seeing one incident of each service when some like Teams or EXO have up to 3 active incidents

Thanks for this video! It's great and super helpful! I'm a bit lost on how I create the 'list' document with sections and the pipes in it. I don't understand how to create this list, what is the obvious thing that I'm missing?

is there any way to replace a picture in the pdf from adobe? the microsoft word options are just very basic looking to send from my business

Omg!!! Just what I was looking for. ❤

Hi This API stopped working for me suddenly after using this successfully for a year. Looks like Microsoft has changed the API. Can you please share some insight if you have any? @damobird365

I am trying to replicate same for each trick but it creates blank entries in my sharepoint list

Hi.. Your video really helps me in html table styling, i follow yr suggested action, it works. Seeking your advice to include a sort (employee name) expression. i have tried few ways, all resulted in error.

Watching some of your videos and very interesting ways presented and very detailed, basically great. Question please, is this scenario doable? Storing an MS Word doc (template) as .xml, then PA time. Format JSON(XML()) then parse, get w:document and then manipulate !values! and even more add items in the array (more letters as in merging idea as well), with new items a number sequence for more items. Once manipulated, add the new w:document content within the right section of the collected xml. Then, create a new document with the new content.

In my scenario i need to add the title in the first row in the merged cell and then add the data. how we will do that?

great video as always, nicely technically explained. cheers!

is there anyway to make this flow export more than 200 thousand of rows?

Love it. This is similar to what I messaged you about on reddit. Now you should do a video on when you need to pull the nest array values for a multi-lookup sharepoint column; when sharepoint has all that ID, Value, etc and you want to flatten just the value.

amazing video :) A great help

Hey, question - will this script also work when transferring a table from a specific sheet from an onedrive file to a specific sheet in a sharepoint file? I'm referring to your other video - where you showed how to save a csv file and use the script to convert the file to XLSX (huge thanks by the way - great video <3) now from this XLSX file I have to paste this table unfortunately into another XLSX file - dynamically, updated daily

This was fantastic. Thank you so much.

Thanks for this , but how can we grab the attendance sheet from Microsoft team automatically using power automate Without download it manually and add it on SP

Howdy! I got this working fairly well except I can't get the hoverable table to work. I followed the instructions and verified I've copied the code for the hoverable table. It comes out formatted, but the hover doesn't work. Also, any thoughts to how to sort the date in ascending order from oldest to newest? Thanks!

Question: how would you adapt this for a very large Dataverse table, say greater than 100,000 rows? Are there limits on those variables for holding all that data?

Hi , I am using power automate to filter a second file using values from the first excel file and then paste the filtered rows to a 6 different files based on the the filtered value. I am using a apply to each within a apply to each . Is there a better way of doing this because its taking 25 mins for 1200 entries

Should the shared mailbox be on Office 365 exchange server? Or can do this on older versions of exchange server

Putting the plural "s" in logical name is so weird I was stuck on it for 5+ hours. Thank you for this!

Hi I work in a UK bank and have to track new items and regulations that have been added to the FCA website. Using . Ideally I want to be notified about new items on the FCA website eg by teams or email then I want a summary of the new item to update a SharePoint or excel. Using ms office or power automate how do I do this. I don't have coding skills

Excellent, I was scratching my head on this one for a while.

This is really great .. thank you for posting these videos. Our team is looking to automate manual work for 100s of reports . We get the data from sql and download it in excel (but the catch is we can not use direct excel files.. these r regulatory reports excel report n these excels have multiple worksheets) and the template is fixed. So how can we update these templates weekly with new numbers using power automate ?

Great video! Would love to see further enhancements in future videos such as collecting responses as well as the score in SharePoint. I am attempting to navigate around the fact you used 1 radio button which captures all the questions ( very efficient) however capturing the responses I am having some challenges as it only gives me 1 response in SharePoint. I’m thinking to use the collect function to capture the responses in a table(similar to how you did shuffle)and then use patch to send the table of selected answers over, hoping I’m on the right path.