WeTechCareOfYou

This tutorial shows to how to create a Birthday App using Microsoft Teams, SharePoint and Power Automate. The app will post a message into the Team 7 days before a birthday is coming up and will also post another message in the Team on the day of the Birthday. In the Team is also a Calendar view populated with your birthdays and also a tab to add new birthdays to the calendar. Microsoft Teams Birthday App 2/2 - addon to automatically copy birthdays to next year https://youtu.be/M9HimavxMbM Commands Used: formatDateTime(items('Apply_to_each')?['Birthday'], 'yyyy-MM-dd') formatDateTime(addDays(utcNow(),+7), 'yyyy-MM-dd') formatDateTime(items('Apply_to_each')?['Birthday'], 'yyyy-MM-dd') formatDateTime(utcNow(), 'yyyy-MM-dd') Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

Microsoft Teams Birthday App 2/2 - addon to automatically copy birthdays to next year Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to create a Power Automate flow to send an email on the 1st business day of every month. ERROR FIX HERE --- https://www.youtube.com/watch?v=V4wd3XVQ-F8&feature=youtu.be 👉Birthday App Video here - https://youtu.be/rQ29PmEOBKQ Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

Hello, in our previous video to calculate business day, there was a slight issue which caused the flow to fail. This video shows a solution to this issue. 👉 Previous video link - https://youtu.be/7NCNGHPHqXo 👉Birthday App Video here - https://youtu.be/rQ29PmEOBKQ 👉Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to use the "Move File" SharePoint step in Power Automate flow, in the demo we will move a word document from one SharePoint document library to another SharePoint document library. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows a solution to the PowerApps error "Could not create solution. Failed to load publishers." when trying to create a new solution. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to use the "Copy File" SharePoint step in Power Automate flow, in the demo we will copy a word document from one SharePoint document library to another SharePoint document library. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

How to remove the "Request sign-off" option from the automate dropdown in a SharePoint List or Document Library. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

Enable Geospatial Controls in your Environment - Power Platform Admin Center Documentation: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/geospatial-overview Related Video - Settings button missing on selected Environment - Power Platform Admin Center - https://www.youtube.com/watch?v=DHc9FX5g2_A&list=UULFPfY5p0726h8CAL8EibJn-A&index=9 Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to hide a button in PowerApps if the logged in user is not part of a Microsoft 365 Security Group. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

How to fix the error "Invalid type. Expected String but got Null" in Power Automate flow when parsing JSON. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to update the language of your browser in Chrome to change the format of the dates showing in Microsoft Forms. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to change the theme for Microsoft Outlook on Desktop. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to get the Sum of all rows in a number column in a SharePoint list. Code used: Sum('Test Vendors', Orders) Connect to SharePoint Datesource Video here : https://youtu.be/IFJJEqy_xFg Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to fix the PowerShell issue: Import-Module : File "" cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170 The link to the documentation shown in the video is here: https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_execution_policies?view=powershell-7.4 The scripts used in the video are here: Get-ExecutionPolicy Set-ExecutionPolicy RemoteSigned Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to create a flow which loops through all SharePoint list items comparing a date field value against the current date. The formulas used in the video are here: formatDateTime(body('Current_time'), 'dd-MM-yyyy') formatDateTime(items('Apply_to_each')?['date'], 'dd-MM-yyyy') Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to change a URL path of a SharePoint site by renaming the site path in the SharePoint Admin Center. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/... ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/... *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows you how to fix the error when trying to add a new term set in your SharePoint Admin Center. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/

Hello, in our previous video to calculate business day, there was a slight issue which caused the flow to fail. This video shows a solution to this issue. 👉Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to get the selected label from a choice column in Dataverse using Power Automate flow. Expression Used: triggerOutputs()?['body/_new_choicecolumn_label'] Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

When you run your PowerApp and your Form shows "No item to display" do this. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to install the Microsoft Office suite onto your laptop or computer if your Microsoft 365 license includes it. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

If the "Settings" button is not showing on your selected Environment, try this solution. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

In this video I will show you how to populate your dropdown or combobox with concatentated values so you can display more than one field in the dropdown results. Code Used: Straight in the dropdown: SortByColumns(AddColumns('Test Vendors', "FullDescription", Concatenate(Title, " - ", Department.Value, " - ", 'Contact Email')),"Title") Creating from a collection: ClearCollect(ItemCollectionCol, AddColumns('Test Vendors', "FullDescription", Concatenate(Title, " - ", Department.Value))) Links mentioned in this video PowerApps Invoice Generator which automatically creates PDF invoice - App Demo / Overview - https://www.youtube.com/watch?v=K8I9Q4d0n0c&t=35s&ab_channel=WeTechCareOfYou PowerApps - Clean Design Template for Form - https://www.youtube.com/watch?v=ct6MpU35Qm8&t=30s&ab_channel=WeTechCareOfYou Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙

This video shows how to mention a user in Microsoft Teams using Power Automate flow. Hey welcome to WeTechCareOfYou! If you are a returning subscriber we wish to say thankyou! If you are new to the channel, please subscribe as we release a new video every week. If you have any questions around our videos please just leave a comment and we will get back to you. If you would like to discuss a project or require set hours for development, support or maintenance then please email Admin@WeTechCareOfYou.com or complete a form here: https://wetechcareofyou.com/contact/ We're also happy to introduce you to a selection of products that have been instrumental in transforming and optimizing our business. As a valued visitor/member of our network, we believe these tools could greatly benefit you too. We've joined the affiliate program to provide you with access and potential discounts: ✅Express VPN - Get a 30-Day Money Back Guarantee with our link. A VPN (virtual private network) is the easiest and most effective way for people to protect their internet traffic and keep their identities private online. When Express VPN is switched on, your internet traffic goes through an encrypted tunnel that nobody can see into, including hackers, governments, and your internet service provider: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=907611.6&type=1&subid=0 ✅Microsoft 365 Business Basic - This license is perfect if you are starting from scratch, with low costs you can have Teams, OneDrive, SharePoint and Exchange to fully operate with communication, collaboration and storage: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.36&type=3&subid=0 ✅Microsoft 365 Business Standard - This license is the next step up from Business Basic and gives access to a lot more Microsoft 365 apps including the Microsoft suite of Word, Excel and PowerPoint: 👉 https://click.linksynergy.com/fs-bin/click?id=hPnKNOblu9k&offerid=1321193.12&type=3&subid=0 *Please note the above links provided are affiliate links, which means we may earn a commission from any purchases. We have personally selected these products based on their value to WeTechCareOfYou, and we believe they can benefit you as well. Kind Regards, The WeTechCareOfYou Team 💙