Відео

This has been helpful. However, I am running into the issue where my sharepoint field is returning as UTC. If I add a convert the sharepoint time to MM-dd-YYYY format I cant seem to set it up any advice?

Thank you for this, it has helped us out a lot. Is there a way to set the flow to branch off with an email that sends the user a message that all there task are complete?

Hey, is there a much basic way to do this? I only have 2 columns in my excel file the id and the information column. I want to input the id in the virtual agent, and it will return the result of information coming from the excel file. just the basic function.

Didn't follow the entire thing but it had something for everyone I guess to take up from.

How do you currently automate creating Planner tasks? Let me know down below! 👇👇👇 Want to learn how to quickly add email attachments to a Planner Task? Check out this YT Tutorial: ua-cam.com/video/42U1r9hpCFM/v-deo.html

I´ve tried to follow your guide from the step regarding the attachments (19:21) but it ends up me getting the text [{"name":"Background-Nuclear-blast-min-407668770_Roger Ehrstedt 7.jpg","link":"eskilstunakommun-my.sharepoint.com/personal/roger_ehrstedt_eskilstuna_se/Documents/Appar/Microsoft%20Forms/Nyregistrering%20av%20best%C3%A4llning%20eller%20felanm%C3%A4lan/Fr%C3%A5ga/Background-Nuclear-blast-min-407668770_Roger%20Ehrstedt%207.jpg","id":"01ITABWGQEKIBM3LAKBFDL3533OEMQ5JGD","type":null,"size":234009,"referenceId":"01ITABWGSTGHRR4OL2HVDK6CPO2YICI7JF","driveId":"b!rvGk72477EGDnp2IRU3Oqlp5BjFkv4tGnpsh93iaDRC7knQdmlbIQaPAha3SZvJ0","status":1,"uploadSessionUrl":null}] in the notes field of the planner task card. Any idea what I have done wrong? In my flow, I have a switch that points to different plans based on a how the responder answers. Could that cause any problems? I can create the planner task but the attachments doesn´t work, I only manage to get them in an email to the team-group members.

Thanks!

Great video, i made this but the emails gets repeated 3 times in a row, how to fix it?

Can you do tutorial on a Requisition Management System for approval and disapproval. Automated Form > SP List to email.

Interesting

Hello, excellent tutorial. Is there a way to create a table in Excel recording the exact time an email arrives in the inbox, only the emails that indicate the start/end of the shift, and create a mark control?

Great tutorial! Thank You! Is there option to start that automation rule globally - for every user and every mailbox in organisation?

can you add photo column in InDesign ? which has a file path to the directory to an image file in computer folder, so that you can use and add to each slide a photo ?

Is it possible to add bulk speaker notes to ppt output by any of these methods ? Feeding from like excel.

I HATE the new layout they rolled out on me.... all in a straight horizontal line. I want the old stacks back!

Nice video, everything works except when I try to open the sent attachments it says that the files are corrupted and do not open them. Any idea why?

hello thank you very much for the great video. i have a flow in which i can't get any further. it's also about a multiline person field. let's say i create an entry and enter 3 people at the beginning. these should receive a notification. now i edit the field and enter 2 new people. now only the 2 new people should be notified. can you please help me here?

Pretty nice viceo and everything seemed to work out quite nicely for me. However when I try to get the file path straight from a "file created" from one drive it gives me an error of file not found, even though the input it is exaclty the same thing as when I try to rerun the flow, but selecting the already created file from the folder. Does anyone know if there's any isue with dynamic inputs from onedrive for any reason? Besides, if any one is having to download the output of the 'list rows' action, be aware to get only the 'value' part of the content as it'll be presented with the 'body' of it and the flow will give an error. Thanks!

Your video was a lifesaver!!

Nice description, thanks! Only one thing is unclear: How do I find out the table index in an array? (2:05 in this video). If I have multiple sheets with multiple tables each, does PowerAutomate sort them in the same order as I see the sheets in my file? Is it 1) left to right and 2) top to bottom within one sheet?

This is AWESOME! Thanks. Can we have a link for each item in the email?

⌨

Thanks a lot for these videos!! My flow is working fine except when I remove the Filter Query on the Get items. I want the flow to scan the whole list for the real task. Then my item count fall to "0" like there is no "today date" item.. but my test item is still on the list, the same list. If I put back the filter to only my test item , then the flow work, the item count show an "1" and an email is sent. any ideas?

Hi, how to automatically add email ID in SP list

⌨

thank you so much

hello! very helpful! however, why does my trigger always trigger twice? it's almost simultaneously triggering :/

Hi Thank you very much for the video!! My problem is that if I now want to assign a task to a third person in the person field, only the third person should receive an e-mail notification.

Keyboard emoji in email

This video along with many of your other videos has been very helpful! I am 100% new to Power Automate and no nothing about code. I have used Chat GPT to help flow ideas but the execution is difficult. Your examples, cadence, and pace are excellent and have improved from your earlier videos. You are Da Boom! I would love to see more videos on summing, averaging, or anything with math through List or approval responses. Anyways, you are freaking awesome "A Creative Opinion" and have made learning Power Automate easier 🙂

High quality content! Thorough, yet concise as possible.

As of 8/2024, something has changed. My flow will run, but the steps within apply to each for getting attachment and creating file are backlit and do not initiate during the flow, so attachment is not saved as a file.

Hi ! do you think I can easily transform my CSV from { "body": [ "1010007, I WANT ", "1010007,TO CONCAT ", "1010007,INTO ONE ROW ", "1099999,AND WHY NOT ", "1099999,THIS ONE ALSO " . . . ] } into { "body": [ "1010007, I WANT TO CONCAT INTO ON ROW ", "1099999, AND WHY NOT THIS ONE ASLO ", . . . ] } I can't figure out how to do that and this is the final step I need ! thanks !!

The output email recipient is not sending to the email. The flow fails up to the point where the email is supposed to be sent. What is being done wrong?

Very helpful tip around the Filer Array to generate the Trigger code - so slick - thank you; that has worked perfectly.

Hi my source is excel and when Im doing compose it doesn't have any option to select Body

hi again, I did this and worked it out using single file, however, i must have left something out because my file format is not coming across correctly! SOS!

hi, great video, thanks. You mention if a file already exists int he folder with the saem name the flow will overwrite the existing file..... I have this problem with my flow now. I wish for it not to overwrite, do you have a video on how to stop it overwriting?

How do I trigger this when an element is created?

This is great! I am having trouble with the content though. The email contains the two expected attachments but both files have the content of the first file. What am I missing/doing wrong here?

Thank you-that was super helpful! I am trying to create the same flow, and all the columns are working except one that contains a type currency value from Excel. I also have my SharePoint list for that column as type currency. The flow runs successfully; it just leaves that column blank. Is there anything else I would need to do to pass through a type currency from Excel to SharePoint?

I can't create the HTML table, keep on getting an error message about the body/value not existing but that's the only thing I can see to select. What am I doing wrong? Keep on getting an InvalidTemplate error message

Nice

​⌨

Really thank you. Do you know how to fix error that 'skip to main content' when space is entered as seperator in split function?

Can you make a guide on how to automate creating a folder structure for Teams channels default Files Tab / SharePoint Documents with custom permissions using SharePoint Groups or Domain Groups?

Hello! If you can make a video on this idea you are the master. I get emails from people everyday at 3PM with an excel list of items to be delivered the next day. I compile the multiple excel documents sent in from each person. Once compiled, I email the lost out as a consolidated excel. This is killing me doing this everyday. Is there any way to automate this process? Lol I'll pay you if you make this video.

Just wowwwww❤️❤️

Hi this tutorial is super helpful however in step 3:11 - Compose section name. My section name is in text and not in date format. What expression should I use to get to the next steps?

Thanks for the explanation, I would like to ask if there is a way to compress or resize attachments, especially when there are images.