“The Power Automate flow works if I use a date formatted SharePoint column, but I need a reminder based on a calculated date from another date column.” “The field ‘CalculatedDate’ of type ‘Calculated’ cannot be used in the query filter expression.” When you calculate a date or a number of days in SharePoint, you might not want to end there. Sure, it’s nice to display the date/number of… READ MORE
Enhance your organization’s productivity by automating repetitive tasks and simplifying business workflows using Microsoft Power Automate (formerly Microsoft Flow) Download Chapter 13 – Working with Microsoft Forms. You will learn how to create a basic form using Microsoft Forms. Purchase the full eBook here Already a member? Log in here
Real-life business processes require the generation of documents like quotes, reports, contracts, emails and many more. Use dox42 to ignite the potential of SharePoint, the Power Platform and Dynamics 365 by automatically generating these documents with data from all your sources!
I know SharePoint Groups are not fashion any more, and a lot of people prefer using Sharing links to grant access to specific people, but I still find the SharePoint Groups very useful to centralize access to multiple SharePoint artefacts. I thought this would be quite simple using the SharePoint HTTP Request action but, something… READ MORE
Introduction With the introduction of SharePoint V2 REST API for Managed Metadata services, it has become very easy to create a term in term store using REST API. But what if we would like to automate things? In such cases we can use the help of Power Automate. In the automation, we would create a simple… READ MORE
If you are using Graph API in your Flows, you may want to safeguard client secret as it will be shown in plain text when you store the client secret value in a variable, its value will show up in the Flow history. This blog assumes that you have already created Graph API, app registration… READ MORE
This is part one of a complete solution that I will post on how to use Power Automate custom connectors with CDS. Power Automate is getting more and more part of the daily processes of Dynamics CRM, with the ability to use hundreds of connectors to get and send data across platforms. Recently I had… READ MORE
I recently encountered a scenario at work where responses to a Microsoft Form should be sent to different people via email based on a value selected as part of one of the questions. Basically, if a person selects Option 1, send an email to a group of people, if he selects Option 2 send it… READ MORE
Controls are a blessing and a curse at the same time. They are right there in the app and provide us with tools to perform actions quickly, but if you’re not careful, the screen is full of controls. The trick is to hide what you don’t need the user to see. As a side note,… READ MORE
Here we will see how to Create, Configure and Consume the Custom Connector to query a M365 group members as a paged result using the M365 Graph api. Register an Application with a Delegated Group.Read.All permission First, Register an application for the PowerPlatform Custom connector with the Delegated permission to read the groups. Create a… READ MORE
