Пікірлер
@aceco4431
@aceco4431 Күн бұрын
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
@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.
@pasfins
@pasfins 3 күн бұрын
Followed the steps. Worked for about 10 documents and now all the documents are corrupted. Any ideas ? Thanks a lot!
@DamoBird365
@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
@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
@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 👍
@zachbean9589
@zachbean9589 3 күн бұрын
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!
@NouradineMahamatArabi
@NouradineMahamatArabi 4 күн бұрын
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
@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.
@TechSkater777
@TechSkater777 4 күн бұрын
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-s6x
@NatalieBarker-s6x 4 күн бұрын
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-Wolf
@JorgePorter-Wolf 4 күн бұрын
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
@thasfun
@thasfun 5 күн бұрын
Omg!!! Just what I was looking for. ❤
@arunkaggarwal1962
@arunkaggarwal1962 5 күн бұрын
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
@iraitzgoikoetxea9021
@iraitzgoikoetxea9021 5 күн бұрын
I am trying to replicate same for each trick but it creates blank entries in my sharepoint list
@berniceleong9148
@berniceleong9148 6 күн бұрын
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.
@DamoBird365
@DamoBird365 6 күн бұрын
@@berniceleong9148 take a look at learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#sort
@richardhedley6751
@richardhedley6751 6 күн бұрын
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.
@ankitsharma1943
@ankitsharma1943 7 күн бұрын
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.m
@thanura.m 7 күн бұрын
great video as always, nicely technically explained. cheers!
@DamoBird365
@DamoBird365 7 күн бұрын
Thank you! Cheers!
@PatriciaMarielaMunozMartinez
@PatriciaMarielaMunozMartinez 7 күн бұрын
is there anyway to make this flow export more than 200 thousand of rows?
@TheCarter117Gaming
@TheCarter117Gaming 7 күн бұрын
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.
@DamoBird365
@DamoBird365 7 күн бұрын
@@TheCarter117Gaming hello 👋 would that be get items? I reckon xpath would be your best bet maybe?
@TheCarter117Gaming
@TheCarter117Gaming 7 күн бұрын
@@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” }, {…} ]
@prajaktaagte8382
@prajaktaagte8382 7 күн бұрын
amazing video :) A great help
@Sese29yt
@Sese29yt 8 күн бұрын
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
@allrise4
@allrise4 9 күн бұрын
This was fantastic. Thank you so much.
@nadafathi8221
@nadafathi8221 9 күн бұрын
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
@JWatCOH
@JWatCOH 10 күн бұрын
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!
@DamoBird365
@DamoBird365 10 күн бұрын
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.
@seang2012
@seang2012 11 күн бұрын
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?
@DamoBird365
@DamoBird365 10 күн бұрын
You might have to batch it. You could explore the chunk expression. I’ve not worked with volumes larger than this.
@melvinnadar8
@melvinnadar8 11 күн бұрын
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
@DamoBird365
@DamoBird365 10 күн бұрын
I would have 6 filters and 6 batch writes with graph or offices scripts. kzbin.info/www/bejne/naXPnJ-wnpuAesksi=IwzQYxyuvuIwKOtY
@MrRajkumarsekar
@MrRajkumarsekar 12 күн бұрын
Should the shared mailbox be on Office 365 exchange server? Or can do this on older versions of exchange server
@DamoBird365
@DamoBird365 10 күн бұрын
It would need to be office 365.
@glendhingra8206
@glendhingra8206 13 күн бұрын
Putting the plural "s" in logical name is so weird I was stuck on it for 5+ hours. Thank you for this!
@rsb8653
@rsb8653 14 күн бұрын
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
@DamoBird365
@DamoBird365 14 күн бұрын
Interesting use case. Do you want to drop me a note through contact me on my blog with more details. I can’t promise.
@alanjwells
@alanjwells 14 күн бұрын
Excellent, I was scratching my head on this one for a while.
@Sunshines999
@Sunshines999 14 күн бұрын
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 ?
@DamoBird365
@DamoBird365 10 күн бұрын
You could look at office scripts? kzbin.info/aero/PLzq6d1ITy6c2_qM_ocYDtEaENrqi92YmM&si=PszCV42wvJU74lBn
@stuntd89
@stuntd89 14 күн бұрын
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.
@justcalm187
@justcalm187 15 күн бұрын
Would it be possible to have 100 questions then shuffle and select a random 25. Then keep track of historical pass % on each question?
@DamoBird365
@DamoBird365 15 күн бұрын
Yes, absolutely 👍
@notorioussamurai1671
@notorioussamurai1671 16 күн бұрын
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....
@DamoBird365
@DamoBird365 10 күн бұрын
I’m note sure. Worth exploring 👍
@aaronalbers7280
@aaronalbers7280 17 күн бұрын
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()"
@DamoBird365
@DamoBird365 10 күн бұрын
It does indeed. 👍
@kumarirakhi75
@kumarirakhi75 17 күн бұрын
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
@DamoBird365 17 күн бұрын
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.
@kumarirakhi75
@kumarirakhi75 16 күн бұрын
@@DamoBird365 Thanks a lot, sure! will jump into that. Thanks a lot for your videos <3 It's really helpful and useful!
@S0ulH0und
@S0ulH0und 17 күн бұрын
Would it be possible to feed chatgpt inside power automate both jpeg and pdf for it to extract data from?
@DamoBird365
@DamoBird365 10 күн бұрын
I don’t believe pdf can be ingested directly but you could convert to text via ocr first.
@billypham3024
@billypham3024 17 күн бұрын
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.
@DamoBird365
@DamoBird365 10 күн бұрын
You can use your own data with copilot studio. Could you build a flow?
@stefankirst3234
@stefankirst3234 18 күн бұрын
Another excellent tutorial. Thanks a lot for your efforts!!
@DamoBird365
@DamoBird365 18 күн бұрын
Cheers Stefan 👍
@nerdimmunity7672
@nerdimmunity7672 18 күн бұрын
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?
@DamoBird365
@DamoBird365 18 күн бұрын
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.
@creatonstudios5712
@creatonstudios5712 19 күн бұрын
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?
@DamoBird365
@DamoBird365 19 күн бұрын
I’ve seen this in PowerPoint but otherwise I am not sure.
@saschahaselbauer4236
@saschahaselbauer4236 21 күн бұрын
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
@DamoBird365
@DamoBird365 21 күн бұрын
You can now restore natively without PowerShell. I am not familiar with the error you mention unfortunately.
@saschahaselbauer4236
@saschahaselbauer4236 21 күн бұрын
@@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.
@hammadyounas2688
@hammadyounas2688 21 күн бұрын
How to use it for pdf data extraction?
@DamoBird365
@DamoBird365 19 күн бұрын
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 👍
@hammadyounas2688
@hammadyounas2688 19 күн бұрын
@@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.
@hammadyounas2688
@hammadyounas2688 19 күн бұрын
@@DamoBird365 do you have any idea or code for this idea?
@DamoBird365
@DamoBird365 19 күн бұрын
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 👍
@hammadyounas2688
@hammadyounas2688 19 күн бұрын
@@DamoBird365 how to code in power automate? I means do you have flow for that?
@cydmansg1979
@cydmansg1979 22 күн бұрын
fantastic demo! thanks! it really helps me man!
@Summane
@Summane 22 күн бұрын
Thank you ! I was able to create my flow with the same logic 💯
@davidclay717
@davidclay717 23 күн бұрын
Thank you for the video, works great. Any chance you'd do one on comparing 2 lists on multi person fields?
@DamoBird365
@DamoBird365 19 күн бұрын
I'll take a note but maybe one to ask on the forum meanwhile powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums
@bhartijaybhay9756
@bhartijaybhay9756 23 күн бұрын
HI @DamoBird365 want to generate Pie chart from Power Apps or SharePoint. How can we do that? Instead of Excel SharePoint can we use?
@DamoBird365
@DamoBird365 19 күн бұрын
check out quick charts api as an option maybe?
@pallavigampala
@pallavigampala 23 күн бұрын
Hi, thanks for the great video, Is there any way to add an attachment while sending the invite?
@DamoBird365
@DamoBird365 19 күн бұрын
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.7971
@m.k.t.7971 23 күн бұрын
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!
@DamoBird365
@DamoBird365 19 күн бұрын
maybe one to ask on the forum powerusers.microsoft.com/t5/Forums/ct-p/FL_Comm_Forums
@TheBeast-gu9td
@TheBeast-gu9td 24 күн бұрын
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
@DamoBird365
@DamoBird365 24 күн бұрын
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-gu9td
@TheBeast-gu9td 23 күн бұрын
@@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...
@michaelpaterson2970
@michaelpaterson2970 24 күн бұрын
Nicely put together video, and really appreciate the depth of explanation regarding expression interactions of the dynamic outputs.
@sunnybuttdog
@sunnybuttdog 24 күн бұрын
SO HELPFUL! Thank you so much!!!
@AshBonarski
@AshBonarski 24 күн бұрын
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.
@DamoBird365
@DamoBird365 24 күн бұрын
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.
@AshBonarski
@AshBonarski 24 күн бұрын
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😅
@AshBonarski
@AshBonarski 24 күн бұрын
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.