1 year latrer, dude i cant tell you how many times ive used this to acomplish tasks, build issue trackers and track info etc. This was of one the most important things ive ever learned., Thank you for me teaching me.
We're about to start an office 365/exchange migration for 3000 people and you've just taught me how to track all their issues, get all the info we need to fix said issues and then follow up with them in 2 sweet moves. i f'ing love you, bro. thanks so much for this.
@@JonJLevesque you have a no idea bro, I just pinned the newly created list to tab in our migration channel in teams so its visible for the team for assignments and BAM were setup. . i'm a god in here right now, all thanks to you man.
Always insightful Jon! I especially appreciate you answering questions before we can ask them (e.g. "why use single line of text for date") and highlighting the benefit of automation allowing for higher value work.
Super video! Tons of food for thought here and everything well explained. Thank you so much for sharing. I am new to lists and power automate and therefore I found the video even more helpful. I am wondering if you or one of the readers here can answer my question. Instead of creating a new item can changing a singular field or column trigger an action, too? I have a column 'Description' and one 'Date of Description'. I want to capture the date when a description was entered into the field. I hope it makes sense. Many thanks
Hey hey - love to watch your videos! I would love to know your thoughts, but I would have done the initial email in the first flow along with setting the 15 day date and then a time based trigger every day on the second flow to trawl the list for any emails to send that day where today's date matches the 15 day column. Reason would be if you needed to change the second email because of a broken link, spelling mistake or what ever. You now can't modify the flow on hold and therefore any changes will need to wait for 15 days before anyone sees them.
This is very informative. I've watch different version and yours is easy to follow along. If you need idea for your next video, perhaps create an Approval Flow that when someone submit a form with a 2 Outcome (Approve / Reject). Then have the 'Outcome' (If it is Approve) Post to LIST, next send an email to both the requestor and approvers. Looking forward to it!
Awesome video, my question is if I have multiple lists, say a customer list and a site visit list. If I'm setting this flow up for new site visit entry how do I insert my relational client data such as name and billing
Hey Jon - Excellent video. I would like to create a flow that once initiated, it will have multiple steps to be completed by different users one after another. How do I achieve that with power automate using SharePoint list?
Just subscribed because I liked your style and explanations. Totally and I mean totally new at this. I can see value in my workplace adopting better ways of working. We receive thousands of emails per day which are currently filtered in Outlook and rules applied to move to relevant holding folders. My dream is to automate this and be able to filter the emails and content (attached is usually an excel sheet) to the teams who have to action it. Is this feasible/workable with such high volumes and where would you start. I can pay in Krispy Kreme donuts 😁
Thank you for this video! Can we create notifications for new entries that are specific? For example, depending on the managers name that is entered on a form, an email will trigger to only that person so they know they have a new entry specifically for them.
Can you add conditions to the follow up email? Such as if you have completed the process you send and email asking how the experience was, but it is still incomplete you send an email to the department manager to ensure the price is moving along.
Hi. What if I would like information from the new (or changed) row in lists to be sent in a PDF to myself/my team, presenting the data in an easy to read, reporty way? Is it impossible to create a word-document (or PPT slide or whatever) to be converted to a PDF and sent out, or is it just not mainstream and therefore not on RU-vid?
Hi Jon, do we have a predefined template to send the whole column values (record) to an email inbox when a field value changed for that record? Lets say a record's STATUS FIELD is changed to COMPLETED ca we have all tha record details send to an email group? Thank you.
Hi Jon, perfect video. Was answering some questions on the compose part. Thanks for showing the feature how to split w/o conditions. Short question - I guess it is possible to set up a similar process for an approval flow if the status did not change for X days to remind the receiver...
Hey Jon, I made an automated documents sequential approval program for my org for documents & invoices approval with Teams & MS Forms integration and reminders. I want to help others too to achieve the sequential approval and how this can be used on Teams as well. If you have spare time from your important and busy schedule I can send those flows to check and feedback.
This is great and I look forward to diving in. Does it matter if you use this in teams or online? It appears there are different options on teams itself than online.
Hey Jon, well done step by step video. Appreciate the thoroughness! MS List is only available to me within Teams (currently). I'm posing a challenge to create outlook contact from MS List item. Is that something power automate can do? Do you know if anything like that exist? Appreciate the response!
Hi John - do you by chance have a video about Power Apps > Customize Forms? I am attempting to replace our InfoPath forms with Power Apps Customized forms and am struggling.
Thanks for a very informative and helpful video Jon. A quick question... if you have created a list in My lists, then share it later or move it to a different location, will any attached flows automatically follow, or will certain aspects of the flow need to be updated? (Sorry, I'm a newbie with this stuff).
Thanks for this very informative video. Question that I couldn't find anywhere answered: Using Forms, how do you pull and existing item on your List and update it's existing columns based on a Form response? i.e. I want to change the status of an existing Item on list called Kitchen Project and change it's 'Status' column from Pending to Completed using Forms?
@@JonJLevesque Yes, that's what i meant what would be the expression in PowerAppts to call existing Items from the List and update it's column base on subsequent Form responses. Thanks again.
Hi Jon, I have a quick question. I am creating a SharePoint list using PowerApps and Power Automate, I'm able to create my columns in SharePoint, but then I want to populate those SharePoint columns with items that are store in an excel table, how can I import those items to the SharePoint list if the list is created dynamically from PowerApps? Step one: PowerApps prompts from the name, last name, and email of a person. Step two: A flow is initiated and creates a SharePoint list using the name of the person that Power Apps passes to the flow. Step three: Create all the columns in the newly created SharePoint list. Step four: export the content of the excel table to this SharePoint list. (this part is what is not working) in order to create the flow, I need to have the name of list already created. How can the flow find the name of the newly created list and use it to export the excel table?
@@moth_la sorry should have elaborated. From the point of view that I would not have to create additional reminder flows to handle this. Efficient in terms of effort for me.
Greate video! But what about the flag to avoid 15 days count email send if the user answers the first one? And after the first 15 days send, another one will be sent after 15 days more? Thanks!
Forgive my newbie question but how do you create an approval flow that allows the approver to make additional selections? I have created an invoice approval flow against a Microsoft list. However I need the approver to also enter or select the Gl account the invoice is charged to along with the approval. I have the GL accounts in another list. I can’t figure out how to allow this entry? Help??
I have a problem, i have no permission to use forms in my company (IT'S RESTRICTED), then i'm using lists, but when trying to combine it with flow, i neither can use this forms connectors, wich other connectors could i use instead of those of forms to complete these actions??
I wish you'd address when things DON'T go as intended. ie: I enter dynamic parameters in 'create item', but they all change to addresses (r520f3a6...). Why?? It's impossible to find why this is happening and what to do about it.
I've created a survey to send out to employees and need them to respond within a week. How do I create a flow that will send out reminders to those that don't respond?
Hi there! I have a video about it titled “create automated email follow ups” for some reason my phone won’t let me post it but if you search, promise it’s there.
Here is a template that creates a planner task after a form submission and posts to teams. You can modify the template to suite your needs: us.flow.microsoft.com/en-us/galleries/public/templates/f06e6f8fbd3e49d5984858b3b54709b2/create-a-task-in-planner-from-microsoft-forms-and-post-message-in-teams/
Hi Jon, thanks for your videos which are very helpful. I have created my first Microsoft List and am trying to create my first flow, but I have created the List in My Lists and I can't find how to move it to the SharePoint site. Can you let me know how to do this as I have been searching online for a long time but can't seem to find an answer. Thanks so much, Nicole
Hello! My team has recently transferred our workflow to SPO Lists, and we need to paste in information regularly. They are moving so slowly that they are not usable (it is taking thirty minutes to paste in several rows of information). This is the case for all members of my team, so it is not an individual internet issue. Do you have any ideas of how to address this?
HI... I want to send an email using Flows to the SharePoint Group and Users which I m maintaining in SharePoint List (People Picker Column). Is it possible?
John, I used this flow to create a Leave Time Request Form to an Approval, and then to create an event in Outlook if approved. Everything works great EXCEPT, all of the appointments created are off by one day in the past. I request the 13th through the 17th, and it makes a calendar event for the 12th through the 16th. HELP!?! I think it has something to do with time conversion, but your steps I used to convert time did not work.
I followed your steps, but got “Actions in this flow may result in an infinite trigger loop. Please ensure you add appropriate conditional checks to prevent this flow from triggering itself.” How can I exclude it?
Jon! Nice video, I have been looking material to do this for a process at work. Think this is the foundation for making it happen, however I'm running into a problem where the Form is not working in the Flow. I mounted everything from a MS Teams Group; SharePoint, SharePoint List and the Form is created in the same MS Teams Group. What are the common errors, on this example? BTW looking this video at 1.20x is dope.
Thanks for replying. The Form works fine, it is that while testing in Flows, the icon keeps rolling, and test is never finished. I have noticed that this f the Form is hanging from my list of Forms, it will work, however if it is hanging from the SharePoint I created for that Process, the test fails, and I never get to write the info in the List (also hanging from that specific SharePoint).
Hello Jon, i have a question regarding calculated columns or user defined columns in lists, normally you can get the sum of the numbers of a column by using the "number" type for a column and selecting the sum option by clicking on the column name, but if you make a column manually with your rules or formula then you dont have that option anymore, how can i still count the sum of the numbers inside that column? i have been told that its possible with power automate but i have no clue which function should i use or how? thanks
And here is that other video I promised ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uEgJLLHBlZU.html This one automatically organizes music album files into their respective and automatically created folder. And it does this for all the alubms. So amazing to see it execute and do it all automatically. Hopefully I have this walk through video for other users and anyone who is interested in Windows Automation. Let me know if you get any questinos I can help with.
Great video, Jon - great pace and very clear instruction. Being completely new to Sharepoint Lists and Microsoft Lists, but having used other platforms before, it does strike me a little strange / sad that: a) The Forms system can't write the data directly into Microsoft Lists without using the Flows, and b) The List can't automatically add the "Date Added" and "Follow Up" dates If just feels like there are too many components involved, that could result in Flows not running correctly and data being incorrect. Will this functionality be added soon, do you think, and will the interface become more GUI and less reliant on knowing how to write the queries? I have some bid Lists I'm building for work, and at the moment I achieve what I want to so much easier with a combination of #Jotform and #Airtable, for example!
Hi Jon, great video! Do you think it is possible(or it is a good idea) to use MS Lists as a data repository(DB)? Asking that because we have a hard time to get licenses to CDS or SQL regarding costs.
4 года назад
Hi Jon, I like to follow your channel I can learn a lot about Power Automate in real life scenarios. My question and also my challenge is to get the link to Microsoft List Item BUT not pointing to SharePoint but to the list item embedded into TAB inside Microsoft Teams. Since I trigger a Flow bot notification with an adaptive card where I would like to have this Link to that Item inside my Teams channel tab. :) Do you have idea how to automate that?
Hey community: Need a helping hand - How do I get this "consent msg" when email + names are captured 11:41 ? Would be a massive help! Thanks in advance :)
Thanks... but WHYYYY Microsoft - yet another similar thing to the other things you do - SharePoint modern, SharePoint old - so a whole new, fragmented system for people to learn. Ultimately more bugs, confusion and mix of features. Ideally just make one thing that works for everyone