- 111
- 332 291
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 - Create Private Channel in Teams!
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}"
},
{
"@odata.type": "#microsoft.graph.aadUserConversationMember",
"roles": ["member"],
"user@odata.bind": "graph.microsoft.com/v1.0/users/{userID}"
}
]
}
🚀 More Power Automate videos here: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html
✨ Intro to Power Automate Cloud Flow series: ua-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, create private Teams channel, Power Automate Teams integration, Teams channel automation, automate Microsoft Teams, private channel in Teams, Power Automate tutorial, Microsoft Teams automation, workflow automation, Office 365 Power Automate, Power Automate cloud flow, Power Automate Teams connector, automate Teams management, create Teams private channel, Power Automate advanced tutorial, Microsoft Flow, Teams channel creation, Power Automate use cases, automate workflows in Teams, Office 365 Teams integration, Teams channel automation flow, Power Automate step by step, automate private Teams channels, Power Automate guide, Power Automate for Teams, Microsoft Power Automate tips, Teams private channel workflow, automate Microsoft Teams with Power Automate.
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}"
},
{
"@odata.type": "#microsoft.graph.aadUserConversationMember",
"roles": ["member"],
"user@odata.bind": "graph.microsoft.com/v1.0/users/{userID}"
}
]
}
🚀 More Power Automate videos here: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html
✨ Intro to Power Automate Cloud Flow series: ua-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, create private Teams channel, Power Automate Teams integration, Teams channel automation, automate Microsoft Teams, private channel in Teams, Power Automate tutorial, Microsoft Teams automation, workflow automation, Office 365 Power Automate, Power Automate cloud flow, Power Automate Teams connector, automate Teams management, create Teams private channel, Power Automate advanced tutorial, Microsoft Flow, Teams channel creation, Power Automate use cases, automate workflows in Teams, Office 365 Teams integration, Teams channel automation flow, Power Automate step by step, automate private Teams channels, Power Automate guide, Power Automate for Teams, Microsoft Power Automate tips, Teams private channel workflow, automate Microsoft Teams with Power Automate.
Переглядів: 43
Відео
2024 in Review - Get Ready for More in 2025!
Переглядів 3321 годину тому
🚀 More Power Automate videos here: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: ua-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!
Переглядів 24428 днів тому
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)
Переглядів 271Місяць тому
Pass a file name from one Power Automate cloud flow to a child flow. 🚀 More Power Automate videos here: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: ua-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,4 тис.2 місяці тому
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: ua-cam.com/pla...
Power Automate - ChatGPT vs Microsoft CoPilot
Переглядів 2882 місяці тому
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: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: ua-cam.com/play/PLZCyV9DvoYI...
Power Automate - Child Flow Errors and Solutions!
Переглядів 3432 місяці тому
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!
Переглядів 3513 місяці тому
This tutorial will show you how to get assignee details from a task in Planner using Power Automate. 🚀 More Power Automate videos here: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: ua-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
Переглядів 1533 місяці тому
How to pin an action in Power Automate. 🚀 More Power Automate videos here: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: ua-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,8 тис.3 місяці тому
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: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: ua-cam.com/play/PLZCyV9DvoYIKPDknpNBMJ5RPKrWgNTK4d.html 🔗 C...
Power Automate - Move File to SharePoint Folder!
Переглядів 3,8 тис.3 місяці тому
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: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow ...
Power Automate - 2 Planner Task Trigger Conditions: Task Title and Assignee ID
Переглядів 5234 місяці тому
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: ua-cam.com/play/PL...
Power Automate - Get Planner Task Attachments!
Переглядів 1,2 тис.4 місяці тому
This tutorial will show you how to get attachments from a task in Planner using Power Automate. 🚀 More Power Automate videos here: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: ua-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!
Переглядів 4,5 тис.4 місяці тому
Follow along to create a new folder in SharePoint with the current date in the file name! 🚀 More Power Automate videos here: ua-cam.com/play/PLZCyV9DvoYIIfIeDr1jFOhqiYS_m0wqmc.html ✨ Intro to Power Automate Cloud Flow series: ua-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
Переглядів 1894 місяці тому
Power Automate Expressions - Split and Integer
Power Automate - AI Builder Email to JSON to URL
Переглядів 3964 місяці тому
Power Automate - AI Builder Email to JSON to URL
Power Automate - JSON tips for Adaptive Cards in Teams (featuring ChatGPT)
Переглядів 9015 місяців тому
Power Automate - JSON tips for Adaptive Cards in Teams (featuring ChatGPT)
Power Automate - Close Case from Teams - Final Flow Adjustments
Переглядів 785 місяців тому
Power Automate - Close Case from Teams - Final Flow Adjustments
Power Automate Solutions (Intro Series Part 10)
Переглядів 1505 місяців тому
Power Automate Solutions (Intro Series Part 10)
Power Automate - Close Salesforce Case from Teams!
Переглядів 2275 місяців тому
Power Automate - Close Salesforce Case from Teams!
Power Automate - Create Salesforce Case from Teams (featuring AI Builder)!
Переглядів 4255 місяців тому
Power Automate - Create Salesforce Case from Teams (featuring AI Builder)!
Power Automate - Failed Action Notifications (Intro Series Part 10)
Переглядів 1356 місяців тому
Power Automate - Failed Action Notifications (Intro Series Part 10)
Power Automate + Salesforce - Query Objects with Missing Field Values
Переглядів 4166 місяців тому
Power Automate Salesforce - Query Objects with Missing Field Values
Power Automate - AI Extract Data from Receipts! (AI Builder Series)
Переглядів 1,4 тис.7 місяців тому
Power Automate - AI Extract Data from Receipts! (AI Builder Series)
Power Automate - Adaptive Cards for Teams Part 2 - Writing Your Condition
Переглядів 4657 місяців тому
Power Automate - Adaptive Cards for Teams Part 2 - Writing Your Condition
Power Automate - Adaptive Cards for Teams!
Переглядів 2,9 тис.7 місяців тому
Power Automate - Adaptive Cards for Teams!
Power Automate - Send Salesforce High Priority Case Alerts to Teams!
Переглядів 1,2 тис.8 місяців тому
Power Automate - Send Salesforce High Priority Case Alerts to Teams!
Power Automate - Summarize Teams Posts with AI Builder!
Переглядів 1 тис.8 місяців тому
Power Automate - Summarize Teams Posts with AI Builder!
Power Automate - Create New Excel Files in SharePoint (with Tables!)
Переглядів 7 тис.9 місяців тому
Power Automate - Create New Excel Files in SharePoint (with Tables!)
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.
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!
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!