Welcome to my RU-vid channel. Here you'll find a variety of video content which an emphasis on Microsoft/Office 365 apps/services like Microsoft Forms, SharePoint, Power Automate and Power Apps. Because I don't spend ALL of my time working, you'll also find some videos about grilling/smoking, Dutch oven and other forms of indoor and outdoor cooking.
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?
@@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.
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.
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?
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.
@@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.
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.
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.
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.
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).
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.
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BL7a5PmgZoc.htmlsi=lqQPUbgJ2aq03xq7
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.
This is not something I can help you with directly, especially not via a RU-vid 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.
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?
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.
@@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.
@@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.
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.
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!
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.
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.
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!
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.
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
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).
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.
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.
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...😁
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?
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"
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.
@@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.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-W2pJTThAHHk.html
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!
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 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.
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
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.
@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
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.
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?
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.
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.
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.
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.
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.
@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'.
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.
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
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.
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
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).
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" } } } }
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" 😡