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
@DamoBird365Күн бұрын
@@aceco4431 do you mean separate progress bars on separate processes? I don’t see why not. You just need to maintain a separate variable.
@pasfins3 күн бұрын
Followed the steps. Worked for about 10 documents and now all the documents are corrupted. Any ideas ? Thanks a lot!
@DamoBird365Күн бұрын
Sounds like an issue with the service, do let me know if you find the problem to help others but I don't know the reason why.
@pasfinsКүн бұрын
@@DamoBird365 I recreated the Translator instance and it seems to be working now. Could it be related to the credits in the PowerAutomate Admin center? Thanks
@DamoBird365Күн бұрын
@pasfins no - as this service runs in Azure. Your requirements for Power Platform are premium licensing to run the http action or a custom connector. Glad you’ve got it working now though 👍
@zachbean95893 күн бұрын
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!
@NouradineMahamatArabi4 күн бұрын
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
@DamoBird365Күн бұрын
Ahhh... well you want to check out kzbin.info/www/bejne/naXPnJ-wnpuAesk and see two options and a SharePoint rest API to create an empty file.
@TechSkater7774 күн бұрын
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
@NatalieBarker-s6x4 күн бұрын
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?
@JorgePorter-Wolf4 күн бұрын
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
@thasfun5 күн бұрын
Omg!!! Just what I was looking for. ❤
@arunkaggarwal19625 күн бұрын
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
@iraitzgoikoetxea90215 күн бұрын
I am trying to replicate same for each trick but it creates blank entries in my sharepoint list
@berniceleong91486 күн бұрын
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.
@DamoBird3656 күн бұрын
@@berniceleong9148 take a look at learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#sort
@richardhedley67516 күн бұрын
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.
@ankitsharma19437 күн бұрын
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?
@thanura.m7 күн бұрын
great video as always, nicely technically explained. cheers!
@DamoBird3657 күн бұрын
Thank you! Cheers!
@PatriciaMarielaMunozMartinez7 күн бұрын
is there anyway to make this flow export more than 200 thousand of rows?
@TheCarter117Gaming7 күн бұрын
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.
@DamoBird3657 күн бұрын
@@TheCarter117Gaming hello 👋 would that be get items? I reckon xpath would be your best bet maybe?
@TheCarter117Gaming7 күн бұрын
@@DamoBird365 i ended up figuring something out using select actions after doing a get items action. Ill have to take a look at what I did and let you know. I am thinking how I could make it even more efficient with a string manipulation like you did in this video. But as an example… lets say you have a sharepoint list of a asset inventory that is three columns: Hostname (single line text) IP Address (single line text) Installed Software (multi-look up) You would do a get items > select to map the three fields where for the multi lookup column you select the dynamic content of the installed software array (which has all the stuff in the multi-lookup array, as it doesnt let you just select the value elements within the array). The output would like like: [ { “Hostname”: “TESTSERVER01”, “IP Address”: “192.168.0.3”, “Installed Software”: [ { “ID”: 1, “Value”: “WinZip v1.0” }, { “ID”: 5, “Value”: “League of Lengends v13.8” } ] } ] The output you want to get to is: [ { “Hostname”: “TESTSERVER01”, “IP Address”: “192.168.0.3”, “Installed Software”: “WinZip v1.0, League of Lengends v13.8” }, {…} ]
@prajaktaagte83827 күн бұрын
amazing video :) A great help
@Sese29yt8 күн бұрын
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
@allrise49 күн бұрын
This was fantastic. Thank you so much.
@nadafathi82219 күн бұрын
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
@JWatCOH10 күн бұрын
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!
@DamoBird36510 күн бұрын
Not sure about the formatting. Is it the client or code? Test the code in an editor wysiwyg? There is a sort and reverse expression.
@seang201211 күн бұрын
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?
@DamoBird36510 күн бұрын
You might have to batch it. You could explore the chunk expression. I’ve not worked with volumes larger than this.
@melvinnadar811 күн бұрын
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
@DamoBird36510 күн бұрын
I would have 6 filters and 6 batch writes with graph or offices scripts. kzbin.info/www/bejne/naXPnJ-wnpuAesksi=IwzQYxyuvuIwKOtY
@MrRajkumarsekar12 күн бұрын
Should the shared mailbox be on Office 365 exchange server? Or can do this on older versions of exchange server
@DamoBird36510 күн бұрын
It would need to be office 365.
@glendhingra820613 күн бұрын
Putting the plural "s" in logical name is so weird I was stuck on it for 5+ hours. Thank you for this!
@rsb865314 күн бұрын
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
@DamoBird36514 күн бұрын
Interesting use case. Do you want to drop me a note through contact me on my blog with more details. I can’t promise.
@alanjwells14 күн бұрын
Excellent, I was scratching my head on this one for a while.
@Sunshines99914 күн бұрын
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 ?
@DamoBird36510 күн бұрын
You could look at office scripts? kzbin.info/aero/PLzq6d1ITy6c2_qM_ocYDtEaENrqi92YmM&si=PszCV42wvJU74lBn
@stuntd8914 күн бұрын
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.
@justcalm18715 күн бұрын
Would it be possible to have 100 questions then shuffle and select a random 25. Then keep track of historical pass % on each question?
@DamoBird36515 күн бұрын
Yes, absolutely 👍
@notorioussamurai167116 күн бұрын
Thanks for your great explenation ☺ I am new to the scripts in excel, but could I bend this solution to only take list 6 (bascially a dashboard which has connections to different sheets for graphs etc.- no idea if it would break the data). Its called Dashboard and I would need to print it into PDF and there are 16 sheets total....
@DamoBird36510 күн бұрын
I’m note sure. Worth exploring 👍
@aaronalbers728017 күн бұрын
Does xpath in this context support string lookups instead of integers? For example, lets say you wanted to to use John Smith instead. "//values[Name="John Smith"]/Expense[1]/text()"
@DamoBird36510 күн бұрын
It does indeed. 👍
@kumarirakhi7517 күн бұрын
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?
@DamoBird36517 күн бұрын
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 kzbin.info/www/bejne/mmqcg6Vrmc-Wg6c let me know if it helps.
@kumarirakhi7516 күн бұрын
@@DamoBird365 Thanks a lot, sure! will jump into that. Thanks a lot for your videos <3 It's really helpful and useful!
@S0ulH0und17 күн бұрын
Would it be possible to feed chatgpt inside power automate both jpeg and pdf for it to extract data from?
@DamoBird36510 күн бұрын
I don’t believe pdf can be ingested directly but you could convert to text via ocr first.
@billypham302417 күн бұрын
Great video, is there a way that you can search multiple items at the same time using API calls? Example that I want to know who's the IT Owner of Cloud Office applicaton? Appreciate if you can assist on this one.
@DamoBird36510 күн бұрын
You can use your own data with copilot studio. Could you build a flow?
@stefankirst323418 күн бұрын
Another excellent tutorial. Thanks a lot for your efforts!!
@DamoBird36518 күн бұрын
Cheers Stefan 👍
@nerdimmunity767218 күн бұрын
Quick question. I am a recruiter. I receive CVs in all different styles and fonts and layouts. Is there a way that I can automatically rewrite CVs so that the CVs I receive are in the standard format (font, font size and layout) that I use?
@DamoBird36518 күн бұрын
You might be able to use the likes of gpt to extract key information and then apply it to a template in word. I’ve a video on using gpt4o on receipt images. But note that generative AI is non deterministic and is therefore creative by design. Try having a conversation with gpt with a sample cv and see if it can consistently extract the features you are looking for. Then you could look at automating it.
@creatonstudios571219 күн бұрын
Can a chart be embedded as a linked object (ie not a static image file), so when the underlying data changes in Excel the word doc shows the updated chart?
@DamoBird36519 күн бұрын
I’ve seen this in PowerPoint but otherwise I am not sure.
@saschahaselbauer423621 күн бұрын
Hi, when i try to restore my flow a receive an error (409) that a associated workflow (workflowEntityId) allready exists. I can't find out, what these workflowEntityId means. Do you have an advise for me? Thx, Sascha
@DamoBird36521 күн бұрын
You can now restore natively without PowerShell. I am not familiar with the error you mention unfortunately.
@saschahaselbauer423621 күн бұрын
@@DamoBird365 The error appears with the powershell and also when i try to restore with the power automate flow "Respore Deleted Flow as Admin (V2)". But thank you for your quick response.
@hammadyounas268821 күн бұрын
How to use it for pdf data extraction?
@DamoBird36519 күн бұрын
I’m not sure right now but you could check Two options for Invoice Processing in Power Platform | AI Builder or Azure Document Intelligence kzbin.info/www/bejne/nH2rnnitmMxrgNE 👍
@hammadyounas268819 күн бұрын
@@DamoBird365 But i have the pdf which is basically a resume. I want to give the pdf file to chatgpt to give the summary of skills and years of experience and degree. Can you provide a tutorial on it.
@hammadyounas268819 күн бұрын
@@DamoBird365 do you have any idea or code for this idea?
@DamoBird36519 күн бұрын
You could use OCR with either low code/pro code and then send the text to an LLM. But I’ll note your request for the multimodal LLM 👍
@hammadyounas268819 күн бұрын
@@DamoBird365 how to code in power automate? I means do you have flow for that?
@cydmansg197922 күн бұрын
fantastic demo! thanks! it really helps me man!
@Summane22 күн бұрын
Thank you ! I was able to create my flow with the same logic 💯
@davidclay71723 күн бұрын
Thank you for the video, works great. Any chance you'd do one on comparing 2 lists on multi person fields?
@DamoBird36519 күн бұрын
I'll take a note but maybe one to ask on the forum meanwhile powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums
@bhartijaybhay975623 күн бұрын
HI @DamoBird365 want to generate Pie chart from Power Apps or SharePoint. How can we do that? Instead of Excel SharePoint can we use?
@DamoBird36519 күн бұрын
check out quick charts api as an option maybe?
@pallavigampala23 күн бұрын
Hi, thanks for the great video, Is there any way to add an attachment while sending the invite?
@DamoBird36519 күн бұрын
Maybe one to ask on the forum if the docs are not clear? powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums
@m.k.t.797123 күн бұрын
This is the great video! I followed your instructions to create flow to collect all the feedback from multiple approvers and record all feedback to a SharePoint list column 'ProcessComments'. Instead of an approval for approve/reject, I use a 'custom-first to respond' approval for only 'Feedback' option. The approvers' emails are dynamically selected from another SharePoint list with 'Course' and 'ContactEmail' ('Course' could be multi-selected). My issue is that the 'Responses' only capture the first response without combine all responses. Could you please help advice how to improve the flow? Thank you so much!
@DamoBird36519 күн бұрын
maybe one to ask on the forum powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums
@TheBeast-gu9td24 күн бұрын
Hi, does this flow check the cases of a single app having more than one key or password credentials, if not, how to correct it? Please help
@DamoBird36524 күн бұрын
I don’t think it will as the keys will be in a nested array. So you would need to consider an apply to each or use xpath as seen in this demo: Boost Your Power Automate Skills with Complex Arrays, Select, XML, and Join Techniques kzbin.info/www/bejne/l5fUp3p3l5djetk
@TheBeast-gu9td23 күн бұрын
@@DamoBird365 hey , I think it covers the case, because initially we are extracting all the passwordCredentials and keyCredentials, which will include the case of an app having many secrets or certificates. Although I don't think this video's flow would cover an app registration having multiple owners... please correct me if I'm wrong...
@michaelpaterson297024 күн бұрын
Nicely put together video, and really appreciate the depth of explanation regarding expression interactions of the dynamic outputs.
@sunnybuttdog24 күн бұрын
SO HELPFUL! Thank you so much!!!
@AshBonarski24 күн бұрын
Thank you for making this video! This helped me start to wrap my brain around html development. Question - would it be possible to use this same flow to be triggered when there is a new form completed and to only send the new response? I still want it to reference the excel table as I have the file auto assigning file numbers.
@DamoBird36524 күн бұрын
Are you writing the new response to excel and then querying it? My worry would be that excel can take up to 6 mins to update. A list would give you more reliable outcomes.
@AshBonarski24 күн бұрын
I included a delay of 30 seconds after the response is submitted to work around the issue. It’s working perfectly, other than sending out a table of every response to everyone who has ever submitted😅
@AshBonarski24 күн бұрын
But yes, I am creating a new excel row for every portion of the response in another flow, then querying it in this flow with the delay to notify the requestor of the automatically assigned number in the excel file. Just can’t figure out the last step of only including the newest response.