- Видео 86
- Просмотров 912 415
John Day Q&A
Великобритания
Добавлен 30 ноя 2011
Hi, I'm John Day, a Microsoft 365 Principal Specialist. My RUclips channel is all about responding to questions, problems, and requests raised by you. It started as a place to answer questions posed by my classroom delegates. A colleague of mine said "you should do RUclips videos more often." So, in 2020, I began to focus on this channel and offer more support. It's kept me busy, but helping people is the best bit!
With over 30 years of experience and many accreditations to my name, I cover a wide range of apps and services from understanding computers, working with Office applications through to programming with VB, VBA, JavaScript and more.
What can I help you with?
- Computers and operating systems like Windows as an end-user.
- The Microsoft Power Platform and general development techniques.
- Microsoft Office 365.
- SharePoint (best selling courseware in UK)
- Document Management (it's my speciality)
- VB.VBA, VBS, HTML, CSS, XML, JavaScript, JSON, Python.
With over 30 years of experience and many accreditations to my name, I cover a wide range of apps and services from understanding computers, working with Office applications through to programming with VB, VBA, JavaScript and more.
What can I help you with?
- Computers and operating systems like Windows as an end-user.
- The Microsoft Power Platform and general development techniques.
- Microsoft Office 365.
- SharePoint (best selling courseware in UK)
- Document Management (it's my speciality)
- VB.VBA, VBS, HTML, CSS, XML, JavaScript, JSON, Python.
New Microsoft Edge for XBOX - Finally connect to Team meetings & play 1,000s of games
The old Edge browser on the XBOX was a real disappointment. Just as families started to rely on it to connect to Teams for remote learning and work under lockdown, Microsoft made updates that prevented it working.
With covid cases on the rise again in Europe, I look at the new Microsoft Edge browser, and see just what we can do now, that we couldn't do before. If we face a lockdown, will the new Microsoft Edge give some families an option to remote learn and work from home?
I take a look at:
03:33 - Environment & settings
04:37 - Office Productivity
06:43 - Online Gaming
08:12 - Online Game Streaming Services
08:30 - Online Entertainment (RUclips, Plex, Netflix, etc.)
With covid cases on the rise again in Europe, I look at the new Microsoft Edge browser, and see just what we can do now, that we couldn't do before. If we face a lockdown, will the new Microsoft Edge give some families an option to remote learn and work from home?
I take a look at:
03:33 - Environment & settings
04:37 - Office Productivity
06:43 - Online Gaming
08:12 - Online Game Streaming Services
08:30 - Online Entertainment (RUclips, Plex, Netflix, etc.)
Просмотров: 9 814
Видео
Combine the power of Doodly with PowerPoint
Просмотров 10 тыс.3 года назад
At this point in time Doodly gets a bit lost animating photos. It wasn't designed to cater for them, it is a hand-drawn animation tool. Secondly animating two or more things at once is not possible. After all you only have one drawing hand. So I let Doodly work its magic and combined it with the animation power of PowerPoint 365. In this video I show you some basic steps to add a more professio...
Making Doodly come to life with PowerPoint
Просмотров 2,4 тыс.3 года назад
This is a short demonstration of a Doodly animation brought into PowerPoint to bring a fuller feel to the screen than on just a plain background. Tutorial will follow soon, I promise !!
Power Automate: Rename SharePoint Files - a great intro to "Send HTTP Request"
Просмотров 38 тыс.3 года назад
There is no rename file action in the SharePoint data connection, so how are your getting Power Automate to rename your files? If you are creating a new file from the existing one, you are failing on fundamental document management policy and compliance. In this video I introduce HTTP requests using file renaming as an example. We will rename the current file so you do not lose version and audi...
Sign up for a FREE text-to-speech tool
Просмотров 3 тыс.3 года назад
Do not pay $$$$ for Speechelo or Talkia when Microsoft offer more functionality per month for FREE!! I will show you how to subscribe and create your speech rseource in MINUTES ! You get 5 millions characters for standard voices free each month, 0.5 million for neural voices, and it costs no more than a few dollars for any additional million you use. With over 100 voices, it is a no brainer !!!...
How Text-to-speech works, what you are REALLY paying for, how to get better for FREE!
Просмотров 2,9 тыс.3 года назад
Have you recently purchased a Text to Speech product such as Speechelo or Talkia? Are you thinking about it? DON'T! Did you know you can get more content and functionality for FREE? In this video I will show you how these products work, what you are really paying for, and how to "cut out the middle ma!" and get this service for free! IN THIS VIDEO 02:57 - How TTS software works 05:43 - What are...
Access company templates & images anywhere with Office 365
Просмотров 10 тыс.3 года назад
Users can access company templates and assets from anywhere, including working from home, using desktop or online apps. This video will show you how to add your templates and assets to the "Content Delivery Network" allowing fast access to templates, logos, pictures and other and branding assets. No more struggling with Network shared drives, synced libraries, or emailing templates between user...
Add Excel Form data into SharePoint columns
Просмотров 12 тыс.3 года назад
In this video I will show you how to grab the data from your Excel forms and add them to SharePoint columns. Excel forms are a thing of the past. Microsoft provides so many resources to take your forms management into modern technology and be accessed from any device. Realistically you want to learn the Power Platform. But the problem for many is finding the time to learn these tools. Meanwhile...
Power Automate: Infinite Trigger Loops
Просмотров 8 тыс.3 года назад
Ever had a Power Automate Flow trigger itself and run on and on and on? Annoying isn’t it? Here I will show you a couple of methods you can try to break the loop, how to build trigger condition expressions with the intellisense tools, and how to manage some of your flows with a service account “without paying a monthly subscription.” In this video 01:53 Trigger Conditions 03:45 Create a Flow wi...
Power Automate: Error 400 - file locked for shared use
Просмотров 16 тыс.3 года назад
One of a number of issues you get when you are updating data between data connections connecting to the same file resource, is one connector locks out the other. The most common we see is when you grab data using the Excel Online data connector, and updating the SharePoint columns of the same file. If you are not comfortable working with the http request, there are some great ways to resolve th...
Windows 11 Requirements Demystified for Windows Insiders
Просмотров 2,1 тыс.3 года назад
Many user have spent the weekend scratching their heads wondering why their high-spec computer is not recommended for the Windows 11 upgrade. Microsoft have changed the specs numerous times, and now the "Hard Floor" and "Soft Floor" distinction has disappeared, with just one Hard floor. The truth is the Windows 11 preview that comes out soon, is aimed at "Windows Insiders." The "Hard Floor" req...
Add and embed custom fonts in online documents
Просмотров 11 тыс.3 года назад
When you apply attractive fonts to your documents and share them, can others see the fonts? How do you add custom fonts to documents using the Office online tools? What do you really know about custom fonts and cloud fonts? This video clears up the confusion as to why you cannot add custom fonts using the office online apps, and why others cannot see custom fonts you apply. I will show you in m...
Automatically convert multiple office documents into PDF
Просмотров 4,2 тыс.3 года назад
This video is a combination of questions on a similar theme about batch converting a bunch of documents to PDF without having to sit there and do it manualy. There are a number of points covered in this video to answer many questions. Hopefully I have covered everyone, but ultimately it shows how you can automate this process using various kinds of Power Automate flows. In this video: 00:00 - W...
Turn a photo into animated Doodly artwork
Просмотров 28 тыс.3 года назад
It's 3am in the morning, it's dark and I have just completed this 6 hour tutorial video showing how to convert a photo into a painting or drawing and then animating it in Doodly as an artistic piece. It was a drawn out process, but really fun. Now I need sleep. In the video I will take you through some Doodly animation tips and tricks that will bring the artist hand to life and really bring out...
A Photo converted to an artists impression and animated in Doodly
Просмотров 1,7 тыс.3 года назад
A Photo converted to an artists impression and animated in Doodly
SharePoint 2010: Users, groups and permissions (part 4)
Просмотров 3543 года назад
SharePoint 2010: Users, groups and permissions (part 4)
SharePoint 2010: Users, Groups and Permissions (part 3)
Просмотров 3253 года назад
SharePoint 2010: Users, Groups and Permissions (part 3)
Manage which users can create Microsoft Teams
Просмотров 9 тыс.3 года назад
Manage which users can create Microsoft Teams
Mastering Power Automate: Module 10 - Team Flows
Просмотров 253 года назад
Mastering Power Automate: Module 10 - Team Flows
Mastering Power Automate: Module 09 - Flow Trigger and Action Properties
Просмотров 273 года назад
Mastering Power Automate: Module 09 - Flow Trigger and Action Properties
Mastering Power Automate: Module 08 - Data Operations
Просмотров 313 года назад
Mastering Power Automate: Module 08 - Data Operations
Mastering Power Automate: Module 07 - Advanced Controls
Просмотров 253 года назад
Mastering Power Automate: Module 07 - Advanced Controls
Mastering Power Automate: Module 06 - Schedule Triggers and Actions
Просмотров 283 года назад
Mastering Power Automate: Module 06 - Schedule Triggers and Actions
Mastering Power Automate: Module 05 - Saving and Reusing Flows
Просмотров 653 года назад
Mastering Power Automate: Module 05 - Saving and Reusing Flows
Mastering power Automate: Module 04 - Flow Button Triggers
Просмотров 493 года назад
Mastering power Automate: Module 04 - Flow Button Triggers
Mastering Power Automate: Module 03 - Variable and Expressions
Просмотров 633 года назад
Mastering Power Automate: Module 03 - Variable and Expressions
Mastering Power Automate: Module 02 - Debugging a Flow
Просмотров 2533 года назад
Mastering Power Automate: Module 02 - Debugging a Flow
Mastering Power Automate: Module 01 - Excel Data Connections
Просмотров 1373 года назад
Mastering Power Automate: Module 01 - Excel Data Connections
SharePoint 2010: Users, Groups and Permissions (part 1)
Просмотров 6223 года назад
SharePoint 2010: Users, Groups and Permissions (part 1)
SharePoint 2010: Users Groups and Permissions (part 2)
Просмотров 3273 года назад
SharePoint 2010: Users Groups and Permissions (part 2)
As it was said: Excellent video!
It was a small adventure so to setup everything, but it worked with MS Office 14 (2010) + Win7 Pro 64bit Retail. Read as PDF, it’s pointless because at Microsoft Office 2010, MS-Word this still blocking images review. Opening at Firefox ESR this works nicely, from there you may print in PDF by the use of PDFCreator / eDoc Printer. Tried to disable the pop-up, and this killed the MACRO functionality. I did setup everything again by reinstalling the macro again. At first installation the MACRO worked right away, and then Outlook started to complain about security settings, I was forced to disable security. Best regards from Greece.
Realme phons saport or not??
thank you ! i was looking for this, lost already two hours on microsoft's website and finally found your video which is very clear
After two years. I can still come back to this and say it’s always useful ❤
So helpful thank you!!
When I plug in a device using an HDMI to USB C cable it just mirrors the screen. It doesn't give me the windows style launcher, and everything is still scaled to the phone screen. (Way too big) Is there a way to improve that situation?
Super useful and still working 4 years after this video was released! Superb
Great detailed explanation. Thanks!
Great 👍
Thank you "ขอบคุณครับ"
I have spent so long trying to do this. Your explanation was perfect. Thank you for going into detail and showing how this can be done. Amazing job!
Was stuck for a few days and thanks a lot for your solution. Please continue with your videos..
Hello there! thank you so much, my automate cant change the name of the file but is possible to change everything else, can someone know why?
Excellent just what I needed 🙂
Hi John, thank you this is really helpful. I know this could be a noob question, but I'm a noob in Power Automate so I'm just wondering if you can explain how to do it to a file that was generated in the same flow with the action "Copy File" since I'm having a lot of problems to get the "ID" in the action "Get File Properties" to generate the name of the file based on the file properties. 😅
This is amazing. Exactly what I wanted and works like a dream.
It’s a shame you don’t seem to post any more John, content like yours is rare and incredibly useful, thank you.
Fantastic tutorial, very clear, no jumping around and perfectly understandable verbiage. Excellent guidance, thank you for assisting with this deliverable.
Great instructive video. Excelent job, Sr. Very much appreciate your time and knowledge
Great video! Thanks for sharing
You are a legend John, this method also works for renaming folders 👏👏👏
Hi John, Thanks for video...once number number update then i want to share eamil to team...please help me for the same
Fantastic. Amazing. Exactly what I required to provide a customised numbering system not starting at 1 for a document request list we have recently migrated from on-prem ishare to SharePoint online. Thank you!
Thank you so much, I needed this
thanks so much!! it helps me !
Thanks man, solved my problem perfectly
Excel files are locked for at least 6 minutes when uploaded or modified via Power Automate. Just add a 6 minute delay to solve the issue. Hope this helps!.
HI John, really helpfull video, is there a way to move a file using a HTTP request as well?
its 20 origins at least now it is, how do i know they have location1 - location20 as possible registry folders oh mb that for personal template paths im not sure about the sharepoint/corporal templates since both are on different branches -.- oh and dont forget to enable show them in new tab or they just wont show up, and make the locations trusted, also make it safe the file somewhere else also the outchecked temp file or your template location get littered with .tmp´s i hate it so much
thank you!!!
I know this video is 4 years old now, but hey it still really cool, and really helpful. I tried it on the latest MS 365 and was able to follow it successfully, so thank you very much. I would like to add the same AutoNumber to a library, but struggling to see if this is even possible.
Hi! thank you. However, I have the same exact adapter, which I then connected as shown in your video, but nothing shows. My Dell monitor says no connection. Am using Samsung A12 with Android version 13. Please help! Why is it not working?
Missleading title stpd
incredible stuff, thank you
Absolutely amazing demonstration. You have no idea how deep I searched for an understandable code example to make this happen.
Thanks, really well explained. Super helpful!
Someone please tell me Do u have to connect Cable with CPU? Or just with lCD
This is really helpful, however I'm getting a bit stuck trying to use the new designer when I get to the power automate step. Any chance you have updated guidance on what to do there? Thank you!
Great video!
Awesome I just subscribed
BRUH, "that didn't take long" 🤣🤣🤣🤣🤣🤣🤣🤣
well done, thanks!!!
This was very helpful and works great. My challenge is I want it to update the filename "when a file is created or modified". Thought it was working awesome until I looked at the run history. Every time it processes the HTTP post action, SharePoint sees that as yet another "modification" and re-triggers the flow. A vicious loop. Any ideas? Ony thing I can come up with is at start of the flow, have it check the modification date/time and if it is less than x-minutes old, terminate the flow.
Thank you 💋
Why does the first Action have to be “Properties only”? I want the trigger to happen when a file’s contents are modified, not its properties. Also, why does this Flow trigger every time I open the Document Library? It’s Locking files that I’m not even opening.
wow thank you so much for the tutor! but what if the sharepoint list hit by more than 10 person in same time john? will the booking number got duplicated?
How can I play my phone apps on my computer screen how can I play like my Pluto Prime video RUclips from my phone to my monitor?
i don't have an options button.
You left out a lot of info.