With Microsoft providing us more flexibility with Power Automate (MS Flow), we can now retrieve working days and holiday details of the CRM Service Calendar directly within Power Automate flows. Previously we used Plugins or JavaScript to get Calendar’s working days and holiday details, but now they can be directly retrieved through the Power Automate (flow) as well.
Recently, we got a requirement to check whether a specific date is a business/working day considering weekends and public holidays defined in the Service calendar of CRM.
Below are the workdays defined in the CRM:
Below is the list of holidays defined in the CRM which are observed:
Given a specific date, we were supposed to check whether it is a working day considering the weekends and public holidays defined above.
The Power Automate Flow steps to get Working Days per week
Step 1: Retrieve Calendar (Customer Service Type)
First, add the ‘List Records’ step to retrieve the ‘Customer Service’ type Calendar. Use a…
Source link
More About This Author
-
Inogic is one of the leading Microsoft Dynamics 365 ISV since 10+ years. Its flagship product Maplytics™ is a market leading certified (CfMD) geo-analytical mapping app. Maplytics empowers Dynamics CRM users across industries with the power of geographical data visualization, route optimization and along the route search with turn-by-turn directions, appointment planner, locational search by radius and shapes with drill-down filters and color-coded pushpins, heat maps, shape layers & territory management.
Inogic is renowned for its high quality and low-cost offshore development services and productivity apps like InoLink: QuickBooks + Dynamics CRM, User Adoption Monitor, Attach2Dynamics, Alerts4Dynamics Click2Export, Click2Clone, Kanban Board, SharePoint Security Sync, Lead Automation & Distribution, Map My Relationships, Auto Tax Calculator, Subscription and Recurring Billing and Marketing4Dynamics.
Array
Dyn365CE3 May 2024Webinar: Connect Mailchimp with Dynamics 365 CRM to improve Marketing and Sales Collaboration!
Dyn365CE2 May 2024Exploring list view in the new mobile experience for Microsoft Dynamics 365 Field Service
Dyn365CE1 May 2024Utilizing Copilot for AI-Generated Text in Power Pages
Dyn365CE30 April 2024Maplytics earns the First-Ever ‘Certified Software’ Badge for Dynamics 365 CRM Maps Integration!
