4 ай бұрын
4 ай бұрын
8 ай бұрын
9 ай бұрын
11 ай бұрын
Жыл бұрын
Жыл бұрын
Жыл бұрын
Жыл бұрын
Пікірлер
@RicardoCatherine-o6y 2 күн бұрын
Davis Timothy Johnson Carol Gonzalez Kimberly
@damir4624 3 күн бұрын
This is great, thank you! How can I copy other questions in my form as metadata for the document in the library?
@cvkealey 3 күн бұрын
You need to add the column and then use an Update File Properties action to set the value appropriately.
@automan25 4 күн бұрын
You're a life saver. Thanks.
@aducaale328 4 күн бұрын
Great tutorial that assisted me to understand hoe to build responsive app. Thanks 🙏🏽
@GOAFIL 4 күн бұрын
No dynamic content shows up for me when I create the "Select" function
@cvkealey 4 күн бұрын
You'll need to be more specific. Which field in the Select are you looking at (the "From" or the output)? What dynamic content are you expecting to see there?
@GOAFIL 4 күн бұрын
@@cvkealey Thanks for the response, Chad. After 4 hours of pain, I found out that the "New Designer" option of Power Automate restricts for some reason the Dynamic Content links, while in the "Old Designer" I was able to follow your guide.
@cvkealey 4 күн бұрын
What I've found is that it doesn't really restrict it, but it seems to "see" the structure of some kinds of dynamic differently. It's not consistent, though, so it's hard to know for sure. I end up switching back to the "old" editor a lot myself.
@JeremyWhitehill 4 күн бұрын
Chad, Great video and saved me tons of time. Almost everything is working great except for word wrapping on the PDF. I am creating the PDF in SharePoint and the long text responses were not displaying correct spacing so I added <pre>dynamicconent</pre> and that fixed the spacing between paragraphs but I am not getting the wrapping, the text just runs off the side of the page. Any Ideas?
@cvkealey 4 күн бұрын
The basic idea here is to compose the document in HTML then convert that to PDF. The "<pre>" tags are an old hack that the PDF converter probably isn't interpreting as you intend. To see if that's the problem, look at the HTML file that's created. If the text wraps normally there, then it's probably the converter. In that case, you'll need to find a way to format the text (in HTML) that the converter will accept. I kept the HTML very simple for this example, but you'll need to get a little more complicated to build a page layout (for example, using DIVs or Flexbox). Unfortunately, I can't really help you there.
@JeremyWhitehill 3 күн бұрын
@@cvkealey Thank you for the update and that gives me a direction to go. For the short term put a table in the html which fixed that problem for now. I appreciate your videos as they are extremely helpful. Have a great weekend.
@chelseajefferson4710 5 күн бұрын
Thank you, this is awesome!
@jeffyak7961 5 күн бұрын
Is there a way to fix the upload? When email is sent out, the picture (jpeg) won't upload.
@cvkealey 5 күн бұрын
Do you mean the image won't load/display? If so, be sure you're including the file extension. Without the .jpg or .png (or whatever format the image is), most email programs won't know what kind of file it is and won't display it.
@downrock.creative 9 күн бұрын
Why do the items in the Title column ("Management", "Operations", "Research") of the SharePoint list have small purple lines next to them? Is this some kind of dynamic content, or were they simply typed in manually? Mine don't look like that, and I don't believe it was shown how these were added in the video. Thanks.
@cvkealey 5 күн бұрын
Those lines are just indicating that the list items are "new". They appear for about 48 hours after an item or file is first created or uploaded, then go away. It's strictly a visual cue and doesn't have any functional impact at all.
@downrock.creative 5 күн бұрын
@@cvkealey Ah, got it. Thank you!
@joyan0001 10 күн бұрын
Hi Chad, If I don't want to use my account as the sender, what is the best option in this flow to use a generic sender "Microsoft Flow" instead?
@cvkealey 10 күн бұрын
There is a "Mail" connector with just one action ("Send an email notification (v#)" - the # was 3 the last time I used it, not sure if it's been updated since) that sends from a Microsoft-managed service account. If there's a chance people will respond to the email, you might want to look into using a shared mailbox. There's no license cost for a shared mailbox, you just need your M365 Exchange admins to create it for you (unless you are an Exchange admin).
@jawessome 11 күн бұрын
I've always struggled with placement of grouped controls. If you enter an X/Y formula of a group, PowerApps moves _everything_ inside that group to that one location instead of the grouped size box with everything relative to it's position in the group to one another.
@cvkealey 10 күн бұрын
I would suggest you stop using groups and start using containers. When you group controls, they're all still on the same "level", but are loosely connected. If you create a container and then put the controls inside of that, you can arrange things inside the container (according to the container type; responsive containers have different "rules" about placement of controls) and place the container wherever you'd like on the canvas. This video from Shane Young will show you the basics: kzbin.info/www/bejne/eH2akmiGosyNpcUsi=lqQPUbgJ2aq03xq7
@sheeajjajyothi6252 14 күн бұрын
Please help me to Send Reminder on teams. This is a friendly reminder that our survey is scheduled to be triggered automatically tomorrow, according to the "Survey Start Date" column in SharePoint. I wouldlike to send survey message heads-up to the team or individuals involved with the survey details on teams with using Power Automate.
@cvkealey 13 күн бұрын
This is not something I can help you with directly, especially not via a KZbin comment thread. I recommend you go to community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287 and post a message there with the details of what you want to do and what you've tried so far. The experts there won't do the work for you, but will help guide you.
@KFBradley 17 күн бұрын
Chad, your videos are invaluable in understanding obscure PowerAutomate tasks. Thank you. My question is, I want to move the files that were submitted via form THEN link to the new attachments in planner, but can't seem to Parse JSON from the Apply to Each > Create file. Any thoughts on this?
@cvkealey 17 күн бұрын
You shouldn't need to parse anything, you just need the link to the file in its new location. This video goes into more detail on the planner attachment part.
@KFBradley 3 күн бұрын
@@cvkealeySorry, I feel like I'm missing something here. After doing an Apply The Each to Create Files, how am I then getting back each if the new links? I've looked through a bunch of your videos and can't find what I need. I seen to be able to move the attached files OR attach them to planner, but not move THEN attach.
@cvkealey 3 күн бұрын
@@KFBradley I don't know exactly what your flow is doing, but if there's an action that's moving a file or creating a file, that action will have (in it's output of "dynamic content") data like the location or identifier for the file which you could then use to perform additional operations (like link to it from a Planner task). What I would do in this case is initialize an array variable at the start of the flow ("varTaskAttachments") and then append the necessary information to that for each of the files that's created. AFTER that loop completes (to create all the files), you can plug that variable into the "Attachments" field on the "Update task details" action. It's really important to remember that those "attachments" in Planner are nothing more than links to files or locations. It's a bit simpler than other "attachment" scenarios (like emails or list item attachments) in Power Automate.
@cvkealey 3 күн бұрын
PS: If you're still having issues, it would be a lot easier to help with some additional details or context on what your flow does. I would suggest posting a message in the Power Automate community (community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287) with those details and maybe some screenshots.
@afga998 18 күн бұрын
Thanks for the video! Just wondering, once I share the flow to a colleague, can I then turn the flow off from my instance of power automate? I need the flow to run on my colleagues account and not mine. Appreciate it!
@cvkealey 18 күн бұрын
It depends what the flow does. I have a few that I use for sending files from my OneDrive to a SharePoint site that I've sent to others who had the same need. But, if you're "handing off" a flow and don't want the original to run any more, you should turn it off or just delete it.
@johntendresse9055 22 күн бұрын
Thank you Chad. This video saved my deliverable! I don't know why MS made it so hard.
@raulsandoval9606 23 күн бұрын
Thank you so much, this help to me a lot, I was looking this scenario for some days and all videos is talking about dynamics list(2 SharePoint lists in same page using webparts). finally I found dynamic hyperlink, again thank you so much.
@houseoftandy 25 күн бұрын
Fantastic video. I too was getting stumped by the trigger of the old form ID still working. Perhaps it's related to part of the ID string that's encoded as there seems to be similar characters early on in the string? You explained it very well though and this helped me!
@Franaman 25 күн бұрын
Great video, but what if I want to select multiple labels and push to Planner, I simply cannot find a video on this?
@cvkealey 25 күн бұрын
I actually do show how to apply multiple labels in this video. After trying many different question types, I found that a multi select choice question worked best for this purpose.
@Franaman 25 күн бұрын
@@cvkealey You are right :P I overlooked the beginning of video, ok epic video!!!
@cvkealey 24 күн бұрын
Yeah, I tend to over-explain a bit, so I don't fault people for skipping ahead.
@alejandrorey7986 26 күн бұрын
Hi Chad, sorry how do you set your flow because when I try to run the flow and error tab appears, I’m sure it’s because I do not create the correct type of flow on P Automate
@cvkealey 26 күн бұрын
This method only works with two triggers from the SharePoint connector: "For a selected item" (in a SharePoint list) and "For a selected file" (in a SharePoint library).
@cvkealey 26 күн бұрын
Check the links in the video description for more details and information.
@FreelancerArafat-ey3hr 29 күн бұрын
Your video quality is very good. Thumbnails are eye-catching. But there is some problem with your channel. Update the video tags section and complete SEO. Only then your video views and subscriptions will increase. If you want I can tell you more about this and guide you in growing your channel.
@juxingjiejie Ай бұрын
I know now. Ignore my comment.
@juxingjiejie Ай бұрын
How did you get the "List of response notifications Response Id"? I cannot see this option in my flow.
@cvkealey Ай бұрын
Microsoft actually fixed this issue in the forms trigger a few months ago.
@spitsparrow Ай бұрын
how to actually add that column to the library though?
@cvkealey 27 күн бұрын
You need to go to the library settings to add it.
@milinkhabya8309 Ай бұрын
Hi Chad in the filter array part I am getting option of body/value instead of body which is causing issue in further steps can you please help?
@cvkealey Ай бұрын
The terminology changed a bit from the "old" designer to the "new" one. The input for the filter array action should be the "body/value" (which would be just "value" in the old designer). Or, switch the interface to use the old designer and things will look like they do in the video.
@assatataylor3238 Ай бұрын
You are the MAN!!!!!! thank you so much for this one!
@shubhabratadey Ай бұрын
In spite of been 3 years old, this is by far the best video on this topic. I have been searching for so long and all the flows following other videos would give me errors. This worked flawlessly. Many thanks Chad...😁
@assatataylor3238 Ай бұрын
Can you help me accomplish the following: Trigger is when a list is created in SharePoint to set up a new hire The list has a multiple choice field where the Mgr can select the type of apps to give the new hire. They often select more than one app to be installed of course. We need to email only the apps that are selected in the multi-choice field in ONE email to helpdesk to let them know which apps to setup for the user Right now every time I set up the email in PowerAutomate to send the field that holds the multiple choice items selected by the manager to give to the user, it automatically applies the "Apply to Each" function. I do not want that because it sends out an email for each app selected for the user, instead, I only want one email with all the apps that are selected for the user listed in the email. Can you demonstrate how to do that? I have tried several things but I always get tripped up when it gets to the part of trying to email it.. Can you do a step by step to show how this should be done?
@cvkealey Ай бұрын
The data in a multi-select choice column are stored as an array. The key to putting that data into a single email message is "merging" it in some way. The simplest option would be using a Join action (or expression) to combine the array of values into a single string value. The Join action has an Input, which should be set to the dynamic content with just the column name. So, if you're column is named "Applications", select the entry from Dynamic content that's just "Applications" (NOT "Applications Item" or "Applications Value"). The action also requires a separator/delimiter which can be whatever you'd like, but a comma is probably the most logical. Finally, in your email, you'll add in the output of that Join action. So, if the column contains values of "Word", "Excel" and "Outlook" and you use a comma as the separator, that output will have the string "Word, Excel, Outlook"
@assatataylor3238 Ай бұрын
@@cvkealey Do I use a compose with the join or just the join?
@cvkealey Ай бұрын
Usually I'll use a Compose action with the "join" expression, at least while developing the flow. Once I've tested and am sure it's working as expected, I'll just copy that expression from the Compose into wherever I need the data (e.g.: in the email body) to eliminate the need for a separate action. For people unfamiliar with compose or expressions, the Join action is a little easier to follow conceptually. That's the only reason I mention it. I mean, it's totally valid and a good action to know about, but I came up using Compose a LOT, so that's my instinct.
@assatataylor3238 Ай бұрын
@@cvkealey Not sure what I am doing wrong but its not working. Either is doesn't bring forward the unique selections at all or it Wants to automatically do an apply to each which is what I cannot have because it spends off too many emails. Thanks anyway I guess.
@cvkealey Ай бұрын
I'm sorry...I was forgetting a step in there. You want to first use a "Select" action to convert the data from an array of objects to an array of strings, THEN you can use join on that array to combine them. See kzbin.info/www/bejne/jWPTe4eKnaZ7fs0
@janicemendoza376 Ай бұрын
Hi Chad! Great video! I have to set up a reminder for multiple approvers in sequence though. If approver 1 approved, approver 2 is taking 2 days, reminder should be sent. Reminders with respondlink is best. How would that look like? Thanks in advance for your help!
@cvkealey Ай бұрын
You just need to repeat the steps for each "level" of approval.
@TracyWork Ай бұрын
Great video. I am trying to do the same thing but with multiple choice fields and then putting it into a Create HTML table. What would you select in the Value column of the create HTML action? I am always getting the whole odata string.
@cvkealey Ай бұрын
It would be the "Value" property for the column. So, if the column is called "Colors", you would select "Colors Value" from the dynamic content.
@TracyWork Ай бұрын
@@cvkealey I don't see that option in dynamic content. Using your example, I only see "Colors" I don't see any other options that contain "Colors"? I did try to type this in the expression item()?['Business_x0020_Apps/Value'] but it returns all empty values.
@cvkealey Ай бұрын
Did you click "See More"? The dynamic content panel doesn't show ALL of the fields, but tries to show the ones that are most relevant to where you're using them. See more shows you everything, and there, you should see a field called "Business Apps Value". If you don't, I'd suggest posting a message (with some screenshots) to the Power Automate Community: community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287
@TracyWork Ай бұрын
@@cvkealey I do not have a "see more". I believe all options are displaying. I did post to the community. Thank you.
@lachmankrishen Ай бұрын
Is it possible to send data(a record id) to the flow when triggering the flow from sharepoint.
@lachmankrishen Ай бұрын
I only found the possibility to triger any flow using the identifier, but I don't see any possibility to send some data to the trigger.
@cvkealey Ай бұрын
What do you mean by "record id"? If you mean a value that's stored in a column/field in the item, you can use the "Get item" action to retrieve the selected item using the list item ID that's passed by the trigger.
@lachmankrishen Ай бұрын
@cvkealey I am using the 'manually triger a flow' triger, I want to start this flow from sharepoint using the button in a record. When the flow triggeres it should send also some information for example the title
@lachmankrishen Ай бұрын
I was trying to send some data with the action param from sharepoint, but the flow does not get the information
@cvkealey Ай бұрын
@lachmankrishen you need to use the "for a selected item" trigger.
@Rostaman1 Ай бұрын
You are amazing. I tried everything on the internet and yours was the only one that worked. Subscribed!
@jamesfulton1284 Ай бұрын
Hey Chad - I completed this but am only receiving one file in the email that is generated. What could that be?
@cvkealey Ай бұрын
Is your "send email" action inside an "apply to each" loop?
@luistapasco2698 Ай бұрын
Thank you so much! With a few minutes of video I was able to find the solution I had been trying to find all morning.
@wrm8460 Ай бұрын
Cool.
@BahadurAli-lj5ou Ай бұрын
Habiluddin(governor).s/o.abdulkarim.2no.balarchar.bngn
@amberschiffer3844 Ай бұрын
Aaaaaaaaaah You have NO IDEA how much I appreciate you right now. Looked for exactly this the whole day yesterday & went to sleep so defeated. And the whole time this was all I needed.
@normanstiegler1275 Ай бұрын
Great video, thanks!
@Masoom36 Ай бұрын
This is great! Thanks!
@NewAge-by5mf Ай бұрын
Hello Chad, thanks for the great Video. I replicated your flow, however in my example in the body from compose I receive dates that are delayed by 2 hours vs those I have in bookings. It does not provide a proper time zone. Do you have any idea how to fix it?
@cvkealey Ай бұрын
The times returned in Power automate are always going to be in UTC. Unless that is your home time zone, you'll need to convert them to your local time either using a "Convert time" action or the "convertFromUtc" expression/function. See learn.microsoft.com/en-us/power-automate/convert-time-zone for more information.
@mgoku1 Ай бұрын
Awesome Video. Helped me alot!!!! Thanks :)
@wendomania Ай бұрын
Your videos are great. I add a ‘Send an email’ action to my approval flows that includes details of the request back to the requestor as well as the approver. I don’t get the buttons for Approve or Reject. Is there a way to embed them into the email? Right now I just have a hyperlink to the approvals area and I don’t like that.
@cvkealey Ай бұрын
When you use either "Create an approval" or "Start and wait for approval" actions, an Approval email is (by default) sent automatically. That is an actionable message and includes (when opened in a supported version of Outlook) the Approve and Reject buttons. Even though the "Create an approval" action provides an output of "Actionable card content", you can't simply insert that into an email message. I've been hoping/waiting for MS to add an action for Outlook that would allow sending that data, but have not seen it yet.
@wendomania Ай бұрын
Your videos are so great. This one is a bit more advanced than I need. I am very new to Power Automate and my scenario is pretty simple and maybe that’s why I can’t find the answer. I basically have a form that user’s submit for approval. Based on the department selected the approval email will route to the correct supervisor of that department for approve or reject. I tried your Approval Matrix List idea but can’t figure out what to put in the email To: field so it sends to the correct supervisor from the list.
@cvkealey Ай бұрын
If the "approver" column in your list is a person field, you need the "Email" attribute. So, let's say the column name is "Approver". In the dynamic content, you'll find a field called "Approver Email" - that's what you need to use. If that column allows multiple selections (ie: there are multiple approvers for a department), then it gets a bit more complicated, but for a single approver scenario, just getting the "<column-name> Email" value should do the trick.
@superiorreporter6721 Ай бұрын
You are a Cherry Lifesaver! Thank you, thank you, THANK YOU!
@kirtichopra2551 Ай бұрын
@cvkealey Hi..Thank you for your help but I am getting some error in update flow. The error is Input parameter 'item/FolderCreated is required to be of type 'string/ date time'.
@cvkealey Ай бұрын
You have some kind of data mismatch. It's impossible to be more specific than that without seeing how your flow is configured. I would suggest posting a message in the Power Automate community (community.powerplatform.com/forums/thread/?groupid=46ce02a3-e1a7-4176-81fc-d93a4001d287) with some screenshots of your flow.
@RobertAyala-w4s Ай бұрын
Awesome video. Unfortunately, it's failing for me. I am new to Power Automate so bare with me. In the Source List, the person may no longer exist so it fails in the Create Item for the second list with a status 404 (Message: The Specified user could not be found. How do I continue to copy the entry from the Source List without the user that cannot be found? Thank you
@cvkealey Ай бұрын
Hmmm...that could be tricky, but I believe there is a way. There is an action in the SharePoint connector called (I think) "Resolve person" which checks if a particular person (using their email or UPN) resolves to a user in your directory. You would need an apply to each loop with the array of data from that field in your first list as the input. For each person, try to resolve them; if successful, append them to an array variable, if it fails, do not. You can use the "run after" settings to achieve this last part. Basically, have an "append to array variable" action which runs only if the resolve person action succeeds.
@wendomania Ай бұрын
Great video. I love all the details. I am new to using a List to look up a response to a form. I am using this for approvals. The list has 2 columns: Department and approver and the user selects their department from the form and then the approval flow generates an email to the approver so they can approve or reject the request. Your tutorial ends with creating an item so I am a little stuck with where to insert where and how to insert the outputs of looking up the department expression to then send an email to the corresponding approver. I will keep hunting around for this piece. Thanks so much
@cvkealey Ай бұрын
I think the details you seek might be found here: kzbin.info/www/bejne/aqW5XpSqrrSsqtEsi=i52yzkm0v7VKOXNS
@juxingjiejie Ай бұрын
Why you need the scope function?
@cvkealey Ай бұрын
Technically, you don't NEED the scopes, but they're useful for 1) keeping the flow readable and 2) error handling. Unfortunately, the new editor (last I checked) does not allow copying/pasting scopes, but in the classic editor, that can be a real time saver when you have similar blocks/steps of your flow (create the actions in a scope, then copy/paste it and adjust as needed).
@zenlasurfer Ай бұрын
Hey good job!! how the bloody heck did I not see that it said encoded .
@DavidSeal-pu5ej Ай бұрын
Hi @cvkealey we have updated our planner licence from basic to premium via teams but it has broken this workflow. I'm getting a forbidden error at 'Create a task' how do I fix this please? See below output error. If I revert back to basic the workflow then works. { "statusCode": 403, "headers": { "Cache-Control": "no-cache", "Transfer-Encoding": "chunked", "Vary": "Accept-Encoding", "Strict-Transport-Security": "max-age=31536000", "request-id": "0f254521-7288-4e7b-bc75-4b3f1ccfd31a", "client-request-id": "0f254521-7288-4e7b-bc75-4b3f1ccfd31a", "x-ms-ags-diagnostic": "{\"ServerInfo\":{\"DataCenter\":\"UK South\",\"Slice\":\"E\",\"Ring\":\"5\",\"ScaleUnit\":\"001\",\"RoleInstance\":\"LN2PEPF000114DD\"}}", "X-ProxyCluster": "weu-001.tasks.osi.office.net", "X-OfficeCluster": "weu-001.tasks.osi.office.net", "X-Tasks-CorrelationId": "35d7701d-b127-4890-a25e-615728a93956", "Timing-Allow-Origin": "*", "x-ms-apihub-cached-response": "true", "x-ms-apihub-obo": "false", "Date": "Thu, 11 Jul 2024 18:28:08 GMT", "Content-Type": "application/json", "Content-Length": "317" }, "body": { "error": { "code": "ArchivedEntityCanNotBeUpdated", "message": "Archived entity can't be modified.", "innerError": { "date": "2024-07-11T18:28:09", "request-id": "0f254521-7288-4e7b-bc75-4b3f1ccfd31a", "client-request-id": "0f254521-7288-4e7b-bc75-4b3f1ccfd31a" } } } }
@Vaesive 2 ай бұрын
I'm losing my mind over here! Was an update pushed to Power Automate or something?! Anytime I perform the "Select" bit it automatically wraps it in a "Apply to each". I'm using the same Person field. From: Person Map: Claims Value: Person Claims As SOON as I put "Person" into the From field it wraps it in an "Apply to each" 😡
@cvkealey 2 ай бұрын
It happens in the "modern" editor. You should be able to just drag it out of that apply to each then delete the loop.
@Vaesive 2 ай бұрын
@@cvkealey Wouldn't let me do it; unfortunately. So I just ended up using variables to get it to work :(