- 108
- 307 713
Jibbs Automations
United States
เข้าร่วมเมื่อ 23 ก.ค. 2022
Start your learning journey in Power Automate!
I also feature tutorials in other M365 applications, such as Power BI, Excel, OneNote, and more!
I also feature tutorials in other M365 applications, such as Power BI, Excel, OneNote, and more!
Power Automate - Pass File Name to Child Flow (Excel/SharePoint)
Pass a file name from one Power Automate cloud flow to a child flow.
🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html
✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html
🔗 Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden
🌐 For consulting and additional resources, visit: www.jeremybarden.com/
Power Automate, Microsoft Power Automate, SharePoint Excel file, pass file name to child flow, Power Automate cloud flow, Power Automate child flow, Excel file automation, automate Excel files, Power Automate SharePoint integration, file name transfer, Microsoft Flow, Power Automate tutorial, automate file handling, SharePoint and Power Automate, cloud flows in Power Automate, pass variables to child flow, Excel automation in Power Automate, Power Automate workflow, file name in child flow, SharePoint file handling, Power Automate for Excel, Office 365 automation, Power Automate file management, Excel files in Power Automate, Power Automate step-by-step, cloud automation, dynamic file name passing, automate file transfers, Microsoft Power Automate guide, file handling with child flows.
🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html
✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html
🔗 Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden
🌐 For consulting and additional resources, visit: www.jeremybarden.com/
Power Automate, Microsoft Power Automate, SharePoint Excel file, pass file name to child flow, Power Automate cloud flow, Power Automate child flow, Excel file automation, automate Excel files, Power Automate SharePoint integration, file name transfer, Microsoft Flow, Power Automate tutorial, automate file handling, SharePoint and Power Automate, cloud flows in Power Automate, pass variables to child flow, Excel automation in Power Automate, Power Automate workflow, file name in child flow, SharePoint file handling, Power Automate for Excel, Office 365 automation, Power Automate file management, Excel files in Power Automate, Power Automate step-by-step, cloud automation, dynamic file name passing, automate file transfers, Microsoft Power Automate guide, file handling with child flows.
มุมมอง: 181
วีดีโอ
Power Automate - Create SharePoint Folder Directory Based on File Name!
มุมมอง 61728 วันที่ผ่านมา
Use Power Automate to create a SharePoint folder directory and move files into the folders based on their file name. If the folder doesn't exist, the flow will create a new folder based values in the file name. Expression used: concat(split(body('Get_file_properties')?['{Name}'],'_')[4], '_', split(body('Get_file_properties')?['{Name}'],'_')[6]) 🚀 More Power Automate videos here: th-cam.com/pla...
Power Automate - ChatGPT vs Microsoft CoPilot
มุมมอง 240หลายเดือนก่อน
For fixing or improving your Power Automate cloud flows, which AI is the better choice: ChatGPT or Microsoft CoPilot? This video demonstrates a basic outcome we want to achieve, and which AI is better equipped to handle our prompts. 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYI...
Power Automate - Child Flow Errors and Solutions!
มุมมอง 239หลายเดือนก่อน
Three common errors you see when working with child flows in Power Automate - and how to FIX THEM. The three error messages are: "Update the child flow for action 'Run_a_Child_Flow' to end with a response action" "Update the child flow for action 'Run_a_Child_Flow' to not use 'run-only user' connections." "Failed to retrieve dynamic inputs. Error details: 'Parameter "workflowReferenceName" cann...
Power Automate - Get Planner Task Assignee Details!
มุมมอง 194หลายเดือนก่อน
This tutorial will show you how to get assignee details from a task in Planner using Power Automate. 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html 🔗 Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden 🌐 For consulting and additional resourc...
Power Automate Feature - Pin an Action
มุมมอง 123หลายเดือนก่อน
How to pin an action in Power Automate. 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html 🔗 Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden 🌐 For consulting and additional resources, visit: www.jeremybarden.com/ Power Automate, Microsoft Po...
Power Automate - Create Planner Task from SharePoint List!
มุมมอง 1.2K2 หลายเดือนก่อน
Use Power Automate to generate Planner tasks for specific users from a SharePoint list. Additionally, learn how to tie in the user's Planner Id by including user's Planner URLs on your SharePoint list. 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html 🔗 C...
Power Automate - Move File to SharePoint Folder!
มุมมอง 2.6K2 หลายเดือนก่อน
Learn how to move SharePoint files from one folder to another, based on the file name, using Power Automate. Additionally, if the folder does not exist, this flow will create the folder and move the file into it. Expression used: split(triggerBody()?['{Name}'],'_')[2] 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow ...
Power Automate - 2 Planner Task Trigger Conditions: Task Title and Assignee ID
มุมมอง 3632 หลายเดือนก่อน
Learn how to add conditions to your Planner trigger 'When a task is completed' so that your Power Automate flows only run when the title equals x or the assignee ID equals x. Expression for task title: @equals(triggerOutputs()?['body/title'], 'Task Title') Second expression: @contains(string(triggerOutputs()?['body/assignments']), 'User ID') 🚀 More Power Automate videos here: th-cam.com/play/PL...
Power Automate - Get Planner Task Attachments!
มุมมอง 9102 หลายเดือนก่อน
This tutorial will show you how to get attachments from a task in Planner using Power Automate. 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html 🔗 Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden 🌐 For consulting and additional resources, v...
Power Automate - Create New SharePoint Folder!
มุมมอง 3K3 หลายเดือนก่อน
Follow along to create a new folder in SharePoint with the current date in the file name! 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html 🔗 Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden 🌐 For consulting and additional resources, visit: ...
Power Automate Expressions - Split and Integer
มุมมอง 1523 หลายเดือนก่อน
Expressions in Power Automate help us achieve desired outcomes. Learn about the expressions Split and Int - and then start using them in your flows today. 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html 🔗 Connect with me on LinkedIn: www.linkedin.com/in...
Power Automate - AI Builder Email to JSON to URL
มุมมอง 3193 หลายเดือนก่อน
Use AI Builder in Power Automate to extract values from an email body into JSON output. This opens the door to pass those JSON values into other areas, creating endless integration possibilities. In this example we pass those values into Salesforce records, creating a link to an opportunity inside the details on a case record. 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeD...
Power Automate - JSON tips for Adaptive Cards in Teams (featuring ChatGPT)
มุมมอง 7223 หลายเดือนก่อน
Learn how to format JSON for adaptive cards in Power Automate for cloud flows. Use ChatGPT to assist with supplying the JSON code! 🚀 More Power Automate videos here: th-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: th-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html 🔗 Connect with me on LinkedIn: www.linkedin.com/in/jeremy-barden 🌐 For con...
Power Automate - Close Case from Teams - Final Flow Adjustments
มุมมอง 713 หลายเดือนก่อน
Power Automate - Close Case from Teams - Final Flow Adjustments
Power Automate Solutions (Intro Series Part 10)
มุมมอง 1294 หลายเดือนก่อน
Power Automate Solutions (Intro Series Part 10)
Power Automate - Close Salesforce Case from Teams!
มุมมอง 1834 หลายเดือนก่อน
Power Automate - Close Salesforce Case from Teams!
Power Automate - Create Salesforce Case from Teams (featuring AI Builder)!
มุมมอง 3514 หลายเดือนก่อน
Power Automate - Create Salesforce Case from Teams (featuring AI Builder)!
Power Automate - Failed Action Notifications (Intro Series Part 10)
มุมมอง 1095 หลายเดือนก่อน
Power Automate - Failed Action Notifications (Intro Series Part 10)
Power Automate + Salesforce - Query Objects with Missing Field Values
มุมมอง 3295 หลายเดือนก่อน
Power Automate Salesforce - Query Objects with Missing Field Values
Power Automate - AI Extract Data from Receipts! (AI Builder Series)
มุมมอง 1.2K5 หลายเดือนก่อน
Power Automate - AI Extract Data from Receipts! (AI Builder Series)
Power Automate - Adaptive Cards for Teams Part 2 - Writing Your Condition
มุมมอง 4115 หลายเดือนก่อน
Power Automate - Adaptive Cards for Teams Part 2 - Writing Your Condition
Power Automate - Adaptive Cards for Teams!
มุมมอง 2.6K6 หลายเดือนก่อน
Power Automate - Adaptive Cards for Teams!
Power Automate - Send Salesforce High Priority Case Alerts to Teams!
มุมมอง 1.1K6 หลายเดือนก่อน
Power Automate - Send Salesforce High Priority Case Alerts to Teams!
Power Automate - Summarize Teams Posts with AI Builder!
มุมมอง 9337 หลายเดือนก่อน
Power Automate - Summarize Teams Posts with AI Builder!
Power Automate - Create New Excel Files in SharePoint (with Tables!)
มุมมอง 6K7 หลายเดือนก่อน
Power Automate - Create New Excel Files in SharePoint (with Tables!)
Power Automate - Connecting to Excel Tables the RIGHT WAY!
มุมมอง 1.3K7 หลายเดือนก่อน
Power Automate - Connecting to Excel Tables the RIGHT WAY!
Power Automate - Manual Trigger INPUTS (Featuring Salesforce IDs)
มุมมอง 1.2K8 หลายเดือนก่อน
Power Automate - Manual Trigger INPUTS (Featuring Salesforce IDs)
Power Automate Cloud Flows - Eliminating Redundancies and Streamlining Flows (Intro Series Part 9)
มุมมอง 1418 หลายเดือนก่อน
Power Automate Cloud Flows - Eliminating Redundancies and Streamlining Flows (Intro Series Part 9)
Is there anyway to get a hold of you bewsides linked in? I don't have a premium linked in account so it won't let me message you.
With the year coming to a close, a more valuable example would be to list all folders in a library, then add the new year subfolder.
I can definitely see how that would be useful, and I am creating more content around SharePoint soon!
This is perfect. Thank you so much
On the other hand, if one is searching for a validation of true or false based on condition of a string presence in email body, afer the first compose, one can use a function like - contains(body('Html_to_text'),'search string') . This returns true when the search string is present. Like in my case I wanted to create a task in planner if there was a string in the text for specific subject from specfici sender.
Hello.. great guide. May I know if I have Microsoft form, for them to upload file in xlsx format and I want to automate this file to csv whenever a form is received. Is it possible?
I need a trigger for both created and modified. Can you add both "when a record is created" and "when a record is modified" trggiers to a single flow?
Hi, as you can't use two triggers in one flow, you could have two flows that are just the trigger and the run child flow action, and a third flow that is your child flow which houses all of your primary actions. Hope this helps and all the best!
this cater my need
Your videos are simple and easy to understand. Thanks so much! Do you have a video where I can get the file attached in Microsoft Form and send the notification mail with that file as an attachment? Thanks again!
Hi, thanks for posting. I don't have a tutorial specific to that, but Forms usually stores files in a particular folder which is always the same, so you could retrieve them with Get Files action and then attach them to your email. I have a video about getting Planner attachments, so it may be something similar to that. All the best!
A departure from my usual tutorials. This is a sped up recording of a Power Automate cloud flow build. Just for fun:)
Why am I getting a Error "The response is not in a JSON format." ?
Could be an number of issues. I would suggest posting screenshots of the flow and error over in Community?
Thank you, this is EXACTLY what I needed !
Thank you so much
Hey Jeremy, great video! Thanks for uploading it. Is there a way to call these fields with missing values and update them using power automate?
I believe its possible, though I haven't done it myself. You can query whatever records you need, and then run a condition that checks the JSON output against the fields you expect to have values but dont (I think it wont show the field in the output at all if the field has no value), and then lastly run an Update Record action.
Expression used: concat(split(body('Get_file_properties')?['{Name}'],'_')[4], '_', split(body('Get_file_properties')?['{Name}'],'_')[6])
this is great thanks
The three error messages mentioned in this video are: "Update the child flow for action 'Run_a_Child_Flow' to end with a response action" "Update the child flow for action 'Run_a_Child_Flow' to not use 'run-only user' connections." "Failed to retrieve dynamic inputs. Error details: 'Parameter "workflowReferenceName" cannot be found for this operation'"
Hi Jibbs, I hope you're doing well! Apologies for bringing this up here, but my team is currently facing an issue with adding an SSL certificate in .p12 format on power automation desktop. We're in the process of automating a REST web service that requires SSL authentication, and we're encountering some challenges. Could you please share any suggestions or guidance on how to resolve this? Your expertise would be greatly appreciated! Thanks in advance!
Hi @tabbarezmokashi1344, thanks for reaching out. I don't have enough expertise in desktop PA, as my focus is cloud. I would recommend checking out Anders Jensen's channel, as his primary focus is Power Automate Desktop. Hope you're able to get a resolution and if you ever need support for cloud flows, feel free to reach out.
Hello Jibs, Thanks for the video. Great information. I have a question. How can I add a confirmation screen for the user to confirm and edit the data if necessary? How can I prompt the user to add a note to the table?
Hi, thanks for posting. You could add an approval action that sends to the user and instructs them to review and confirm and add notes before clicking approve.
thank you for this video! your puppy is sooo cute😍 I'm starting my role as an Operations Manager soon, so it was great to have an overview of what it feels like
When I select the table name, for some reason I am not getting the prompt to map the headers. Can anybody help me with this please. I have tried everything I could but can't seem to fix this issue
My goal is to make the bucket id dynamic based on a value from the list. I followed your steps except for in the filter query I set the value it is equal to a dynamic field from the list that contains only the bucket value options from the planner. But when I run the test all the steps say they were successful with a run time of 0, but nothing appears in the planner. Any thoughts?
Hi, that's a tough one. Would need to see screenshots of your flow to know for sure. I suggest posting in Community if you haven't already. All the best!
Thank you for this video. It really helped me with my work.
On my Power Automate, there is no option to use an AI Builder.
AI Builder is a premium connector so that might be why you don't see it. I would suggest to check with your admin. All the best!
If the object is not showing in the dropdown list, is there a way to write an expression for a custom object?
Looking for the same content helped me a lot in my workplace, thank you!
Just what i needed, thank you. I get a lot of emails with .doc or .pdf attachments. Is there a way to grab those files and save them to a OneDrive folder?
Is there a way to trigger a flow when an opportunity reaches a specific stage?
Thanks for the video, but this could be certainly be improved by actually filling in the Excel file with data instead of just talking about it. Like that is the literal reason why everyone is here, to see a Excel file full of data, not just some column headers.
Hi, I appreciate your video, but I don't understand how to set up dynamic pathing for folders. I need to move a large number of folders from one library to another. Rather that create a program that moves one folder at a time, I'd like to create a flow that moves the contents of the folders to the corresponding folder in our archive library. Copy Team A/Project 5 & Team B/Project 5 to Archive/Project 5. Same for projects 1-4... This is all so confusing!
Hi! Have you found a solution? I don't have a tutorial similar to what youre looking for, and moving folders using Power Automate is something I haven't yet explored myself. Hopefully you'll discover something!
Thank you for sharing this, how about multiple attachments
Thank you <3
Hi Jibbs , thanks for this tutorial . One question though, when I create a new plan from a source plan the attachments are linked for some reason. Is there a way to use power automate create a new plan from a source plan with attachments not linked to each other. Hope you can help with a new video on that.
This helped to fill in a gap for me. Thanks!
How do i use these text in creating a new record(Lead).? /leads(output) - getting error as Bad error query syntax (output) - URL not parsed due to an OData.
Somehow I'm getting an error in the 3rd compose action and I don't know why.. Error: Unable to process template language expressions in action 'Verfassen_2' inputs at line '0' and column '0': 'The template function 'output' is not defined or not valid.'.
it woud be great if I could add today() to the file name in my flow when the file is created. Woudl you hav something on that?
Can you show me how to get the link for a shared folder on sharepoint?
Hi, do you want to use Power Automate to get a link for a shared SharePoint folder?
fantastic video, have been looking for this for a long time. thanks
Thanks so much for this - it all works as shown in the video!
Hi, thanks for sharing this! From my side, the flow only creates a first file and then does not work anymore. Afterwards, the flow fails because it states it detects a duplicate, even though i am using utcnow as unique identifier. Any ideas how to fix this? This is the error in the body for the failed create file action: "{ "status": 400, "message": "The list item could not be added or updated because duplicate values were found in one or more fields in the list. clientRequestId: 8d531802-c90c-4615-a842-72220faf1f4f serviceRequestId: d78351a1-5034-9000-e1a6-d1f13e0d67c2" }"
Need help implementing this flow? Let’s connect! www.jeremybarden.com/automation-consulting
Need help implementing this flow? Let’s connect! www.jeremybarden.com/automation-consulting
What if I want to include a message before approving
I was successful getting emails into planner tasks but cannot get the contents in the description. I know I’m going to need to do attachments as well. I’m not sure why my flow is not working. I’ve tried tried changing my content from HTML font before my condition and after (because my task is based off a specific subject line). Any clue where I’m going wrong? Help!!! Lol
Hi Jibb. Thanks for the video. Wher did you get the record ID for the first "Get Record" action?
Hi! You can get a record ID from the salesforce URL. Your URL might look something like yoursite.lightning.force. com/lightning/r/SBQQ__Subscription__c/a6BUn000001uLcIMAU/view. The record ID is always found after the API name of the record object, in this URL example it is the string of letters and numbers following the 'SBQQ__Subscription__c'. Hope this helps!
❤Thanks
Thank you SO MUCH!!! it was much easier than the other tutorial I saw.... thank youuuuu!!!!
When isave the flow. There is a warning message "Your flow was saved, but could not be enabled because it contains connectors to applications which are not compatible with the Gmail connector used in this flow." I investigated and found out that the incompatible action is "html to text" is there any resolutions to this issue?
Hi, I'm not sure why the html to text would give you such an error, and I've never seen that error before on any flows. If you haven't already, try posting your flow with error over on Community.
Thanks for posting such awesome video. I do have a question though, I have a file coming in email attachment and I need to save them in the share point folder with table format. Keep in mind, the attachment contains excel sheet with multiple tabs (sheets). How can I achieve my goal? Thank you!
Hi, thanks for posting. That should be doable. Your trigger should be when new email arrives, and then you'll save the attachment in SharePoint. From there add the Compose and Create file actions from this video. If you need more detailed support, try posting what you have set up so far over in Community.
Can you do this with a To-Do Task rather than planner?
Great question! It all depends on how To-Do stores attachments. If it stores them in SharePoint like Planner does, you could probably create a very similar flow to this one.