Power Automate - Compare current date against date value from SharePoint list
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 💙
-
3:10
WeTechCareOfYou
10 months agoPower Automate Get Value of Dataverse Choice Column
64 -
11:58
WeTechCareOfYou
5 months agoPower Automate Calculate First Business Day of Month
9 -
28:22
ExcelForFreelancers
3 months agoVBA Basics: Say Goodbye To Date Issues In Excel
4 -
3:12
IvorF
1 year agoGet More Time Back in Your Day with this App for your Service Business
7 -
51:52
Excel For Freelancers
3 years agoHow To Create A Dynamic Timeclock Report in Excel Today [Employee Manager Pt. 19]
54 -
26:25
Excel For Freelancers
5 months agoExcel Named Ranges: Everything You Need To Know In Less Than 30 Minutes
50 -
12:24
Dexcelo
1 year agoCalculate dates difference in Excel | Excel Practice Case #17
8 -
1:20:57
Excel For Freelancers
2 months ago $0.11 earnedThe Last Excel Date Picker You Will Ever Need + FREE DOWNLOAD
107 -
25:33
joshschonert
3 years agoHow To Use Automation To Clean Your List | GetResponse Automation
2 -
1:00:25
Excel For Freelancers
3 years agoLearn How To Preview Attachments, Filter By Date & Remove HTML in the Excel Email Manager Part 3
50