- 113
- 348 540
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 - Track Expiring Azure App Client Secrets in SharePoint
Use SharePoint lists to track your Azure App client secret expirations. This set up runs on a schedule and will catch any rows where your expiration date column is 30 days from current date.
🚀 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 list tracking, Azure App client secret, client secret expiration tracking, automate Azure App monitoring, Power Automate schedule flow, expiration date automation, track Azure secrets, Power Automate SharePoint integration, workflow automation, Office 365 Power Automate, Power Automate cloud flow, SharePoint for Azure apps, automate expiration alerts, Microsoft Flow, Power Automate step by step, schedule-based automation, 30-day expiration check, automate Azure app management, Power Automate for Office 365, expiration tracking automation, Power Automate use cases, SharePoint list automation, client secret monitoring, Power Automate for Azure, expiration alerts in Power Automate, automate workflows, Microsoft Power Automate guide.
🚀 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 list tracking, Azure App client secret, client secret expiration tracking, automate Azure App monitoring, Power Automate schedule flow, expiration date automation, track Azure secrets, Power Automate SharePoint integration, workflow automation, Office 365 Power Automate, Power Automate cloud flow, SharePoint for Azure apps, automate expiration alerts, Microsoft Flow, Power Automate step by step, schedule-based automation, 30-day expiration check, automate Azure app management, Power Automate for Office 365, expiration tracking automation, Power Automate use cases, SharePoint list automation, client secret monitoring, Power Automate for Azure, expiration alerts in Power Automate, automate workflows, Microsoft Power Automate guide.
มุมมอง: 77
วีดีโอ
Power Automate - Turn OFF flow from SharePoint List
มุมมอง 9214 วันที่ผ่านมา
This flow allows you to turn off a flow based on SharePoint list information. @equals(triggerOutputs()?['body/Status/Value'], 'OFF') 🚀 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 c...
Power Automate - Create Private Channel in Teams!
มุมมอง 16521 วันที่ผ่านมา
Use Power Automate to create a private channel in Teams! HTTP URI: graph.microsoft.com/v1.0/teams/{teamID}/channels HTTP Request Body: { "@odata.type": "#Microsoft.Graph.channel", "membershipType": "private", "displayName": "{Channel Name}", "members": [ { "@odata.type": "#microsoft.graph.aadUserConversationMember", "roles": ["owner"], "user@odata.bind": "graph.microsoft.com/v1.0/users/{userID}...
2024 in Review - Get Ready for More in 2025!
มุมมอง 3821 วันที่ผ่านมา
🚀 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 - Create SharePoint Tab in Teams Channel!
มุมมอง 342หลายเดือนก่อน
There is no native connector action in Power Automate that allows us to add a tab to a Teams Channel, but there is a work around as presented in this tutorial. Follow along to add your SharePoint folder to a tab in your Teams Channel. Access Token HTTP Action URI: login.microsoftonline.com/{Tenant_ID}/oauth2/v2.0/token Headers: Enter key: Content-Type Enter value: application/x-www-form-urlenco...
Power Automate - Pass File Name to Child Flow (Excel/SharePoint)
มุมมอง 3162 หลายเดือนก่อน
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 - Create SharePoint Folder Directory Based on File Name!
มุมมอง 1.8K2 หลายเดือนก่อน
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
มุมมอง 3183 หลายเดือนก่อน
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!
มุมมอง 4043 หลายเดือนก่อน
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!
มุมมอง 4873 หลายเดือนก่อน
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
มุมมอง 1743 หลายเดือนก่อน
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!
มุมมอง 2.2K4 หลายเดือนก่อน
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!
มุมมอง 4.6K4 หลายเดือนก่อน
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
มุมมอง 6054 หลายเดือนก่อน
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!
มุมมอง 1.4K4 หลายเดือนก่อน
Power Automate - Get Planner Task Attachments!
Power Automate - Create New SharePoint Folder!
มุมมอง 5K5 หลายเดือนก่อน
Power Automate - Create New SharePoint Folder!
Power Automate Expressions - Split and Integer
มุมมอง 2145 หลายเดือนก่อน
Power Automate Expressions - Split and Integer
Power Automate - AI Builder Email to JSON to URL
มุมมอง 4345 หลายเดือนก่อน
Power Automate - AI Builder Email to JSON to URL
Power Automate - JSON tips for Adaptive Cards in Teams (featuring ChatGPT)
มุมมอง 1K5 หลายเดือนก่อน
Power Automate - JSON tips for Adaptive Cards in Teams (featuring ChatGPT)
Power Automate - Close Case from Teams - Final Flow Adjustments
มุมมอง 815 หลายเดือนก่อน
Power Automate - Close Case from Teams - Final Flow Adjustments
Power Automate Solutions (Intro Series Part 10)
มุมมอง 1616 หลายเดือนก่อน
Power Automate Solutions (Intro Series Part 10)
Power Automate - Close Salesforce Case from Teams!
มุมมอง 2426 หลายเดือนก่อน
Power Automate - Close Salesforce Case from Teams!
Power Automate - Create Salesforce Case from Teams (featuring AI Builder)!
มุมมอง 4536 หลายเดือนก่อน
Power Automate - Create Salesforce Case from Teams (featuring AI Builder)!
Power Automate - Failed Action Notifications (Intro Series Part 10)
มุมมอง 1657 หลายเดือนก่อน
Power Automate - Failed Action Notifications (Intro Series Part 10)
Power Automate + Salesforce - Query Objects with Missing Field Values
มุมมอง 4647 หลายเดือนก่อน
Power Automate Salesforce - Query Objects with Missing Field Values
Power Automate - AI Extract Data from Receipts! (AI Builder Series)
มุมมอง 1.6K7 หลายเดือนก่อน
Power Automate - AI Extract Data from Receipts! (AI Builder Series)
Power Automate - Adaptive Cards for Teams Part 2 - Writing Your Condition
มุมมอง 4957 หลายเดือนก่อน
Power Automate - Adaptive Cards for Teams Part 2 - Writing Your Condition
Power Automate - Adaptive Cards for Teams!
มุมมอง 3.1K7 หลายเดือนก่อน
Power Automate - Adaptive Cards for Teams!
Power Automate - Send Salesforce High Priority Case Alerts to Teams!
มุมมอง 1.2K8 หลายเดือนก่อน
Power Automate - Send Salesforce High Priority Case Alerts to Teams!
I all the things I learned in this video. Looking forward to becoming an expert! How long did it take you? I'm sure you're always learning and what was your background before?
Buddy you saved me so much time with this video. Can’t thank you enough. I was beating my head against a wall trying to figure this out.
Thank you so much for your videos, they are great! Could you make one explaining how to sync libraries in different locations?
Is it possible to popluate data from Excel into dropdown list on MS forms? If yes, how to do it?
Worked like a charm! Thank you!
Can you add to this a flow to grab the attachments from emails and then create all these folders?
Great tutorial! But, how i can implementing this flow for an e-mail with two or more attachments? In this vídeo power automate send two e-mails for wich attachment. I wanna one e-mail for two or more attachments! Is this possible?
Thank you! Great vid! What if I'm moving multiple files to multiple folders? How do I use the 'apply to each' or conditions to do multiple files to different folders? Right now, I just used your video to create 20 different flows! 😭
Hi! You may want to explore condition that checks the file name, and if contains, moves into appropriate folder. Hope you can find a good one-flow solution. All the best!
How easily way that you solve and elaborate the solution thanks lots.my mind was so exhausted to finding solution with others tutorial.
Great tutorial, does this only create the channel? I dont get any file areas
Hi! This creates the channel, and by default the channel includes two tabs, Post and Files, where Files is the SharePoint folder of the user (the SharePoint site gets automatically created anytime a new channel is created).
was there a role before this that led you to this position? Or was it something you aimed for with a degree?
Hi! I was an international student advisor in higher ed before this and during the last two years as an advisor, I began to transition into more system admin for the CRM we used. I was able to get them to change my role to Advisor and System Specialist, and that helped get me out of higher ed and into a corporate job working in a training department. I was able to make the change without having a related degree.
Can I copy part of flow to create or revise exist flow?
With this action it copies the full flow. I believe the only way to copy part of a flow is to put the part you want into a scope, and then copy the scope. Hope this helps!
The expression - last(split(outputs('Split_Body_Text')[6],': ')) works great for pulling single lines, but how could you setup an expression to pull multiple line. For example, if line 6 was a section from an automated order email containing notes and the information could be anywhere from 1 line to 4 lines. Thank you for the help!
Fantastic job!!! Worked the first time we ran it ! You are Great teacher as well.
Any tips on copying (duplicating files etc) a SharePoint site etc to a new Teams Channel?
@ Can you elaborate a bit more on what you are trying to achieve?
I have learned so much from watching your tutorials. Keep up the good work! Have a great year....Love to see if you have any uses for Virtual Assistant with incoming emails to eliminate redundant requests 🙂
Thank you! I've not explored Virtual Assistant but I'd be curious to learn more! Which application is that?
@@jibbsautomations I mistyped, I meant Virtual Agent using the connector. We are trying to automate emails for a shared email box eliminating common inquiries using the agent as a bot. We envision the flow will answer the email based of of key words> send the sender an email asking a series of possible answers they are seeking and giving out that support Info based off the answer. If the answer is not there it will then release the email into a support folder in the shared box in a categorized folder. I would love to see your take on this
When I open up the outputs of the split body text in the history, it only shows me the expression not the email text.
Thanks for the great videos Jeremy, happy new year!
Thank you! Happy New Year!
Love the videos. I noticed you use a child flow. Can this done as a parent?
Yes, I believe so!
Thanks so much for this. I've been trying and failing for about a week trying to do this!
This flow is perfect but fails at the parse JSON. I am unable to use the text as the content, it automatically defaults to the body/response. Can you help with this?
Hey, i need few records from my salesforce object to be displayed in copilot. any idea
Ohhh, it took me ages with Claude and ChatGPT, both did not have the faintest idea how to explain this.
Thanks for sharing this but isn't this something that can be added to a teams channel as a tab with a few clicks. I'm not sure what the point of this flow would be unless I'm missing something.
@@banihas22 hi, thanks for reaching out. You're correct that adding a tab to a Teams channel can be done in a few clicks. This flow is to automate those few clicks, as Power Automate doesn't currently have a native connector to create a tab. Thanks for watching!
This is perfect! Thank you so much for this excellent Power Automate flow. I’ll go over it a few times to make sure I fully understand and appreciate it.
You're a GOD thanks !!! you have solved a longtime problem for me!
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.
@@timothyroberts80 hi! That's odd, LinkedIn should let you message anyone without premium. You can reach me at Jeremy@jeremybarden.com.
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.
Did this work for you? I’ve been trying to do the same thing, but instead of returning “true” it just returns the function I typed in the input.
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
Hi, sorry for the late reply. Did you get this sorted out? Did you try switching to classic designer? Sometimes that solves buggy things with power automate.
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!