WebHook in Power Automate Flow

 

Synchronous Power Automate Flow

As we all know Power automate flow is an asynchronous execution mode.

There is the question though can we execute Power Automate Flow Synchronously?

The answer is yes.

It will need a little bit of reworking and thinking.

The idea is to create a Flow that we can control when to trigger it.

What if we create a Web Hook and trigger the Synchronously.

I have created a sample Power Automate Flow for this experimentation

1. Create a Flow with HTTP Request Action

2. Once you have saved the flow Copy the URL

3. Open Plugin Registration Tool

4. Register New Web Hook

5. 
   
   

   
   

6. Register a new Step, I want this to execute on update of Account Entity on change of Description fiel

Happy Coding 

Dp-900 notes

 There's 3 type of Relational data SQL:

DDL (Data Definition Language) CREATE, DROP, ALTER, RENAME, COMMENT AND TRUNCATE. DML (Data Manipulatión Language) SELECT, INSERT INTO, DELETE, UPDATE. DCL (Data Control Language) REVOKE & GRANT. TCL (Transaccional Control Language) COMMIT & ROLLBACK

Which storage solution supports access control lists (ACLs) at the file and folder level?

•  Azure Data Lake Storage

 

How to Call an Action through Power Automate(MS Flow)

Introduction

As Microsoft is providing us more flexibility with Power Automate (MS Flow), recently we found that now we can call the Action through Power Automate (MS Flow) directly. Previously we used to call an Action through HTTP request, but now we can directly call an Action through the Power Automate (flow) steps.

Before that take a short look at what are Bound and Unbound Action?

Bound Action are targeted to the entity and Unbound Action are not bound to the any entity, they are Global.

To get the Bound and Unbound actions in Power Automate (MS Flow) follow the steps given below:

1. Create a solution in https://make.powerapps.com/ where you have to add your Power Automate (Ms Flow) which we are going to use to call Actions.

2. In the solution click on new button & select Flow as shown in below image. Apparently it will redirect you to Power Automate (MS Flow) window as shown in the following image.

3. Now we have to Search for Common Data Service Trigger point in our newly created Flow & from the search result select the Common Data Service (Current Environment).
Select the trigger conditions as per requirements such as Create, Create or update, Delete, Update etc.

4. Now in the next step we have to search for the action & select the Common Data Service (Current Environment). You will get many new action points in the results from that we have to select Bound/Unbound Action.

For the bound action you will see the Action step as shown in below image. In my case I have selected the QualifyLead action which is bounded with the Lead entity.

And for unbound step you will get to see the below window in which you can call your global action or the action which is not bounded with the any entity which will be listed in the unbound action.

Note: – You will find this Bound & Unbound action trigger steps when you create a Power Automate (MS flow) from the https://make.powerapps.com/ platform.

Conclusion

As illustrated above, you can now directly call an Action through Power Automate (MS Flow).

Stored procedures

 Stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.

You can also pass parameters to a stored procedure, so that the stored procedure can act based on the parameter value(s) that is passed.

CREATE PROCEDURE SelectAllCustomers
AS
SELECT * FROM Customers
GO;

EXEC SelectAllCustomers;

CREATE PROCEDURE SelectAllCustomers @City nvarchar(30), @PostalCode nvarchar(10)
AS
SELECT * FROM Customers WHERE City = @City AND PostalCode = @PostalCode
GO;

EXEC SelectAllCustomers @City = 'London', @PostalCode = 'WA1 1DP';

Errors in powers automate : The 'inputs.parameters' of workflow operation 'Add_a_new_row' of type 'OpenApiConnection' is not valid. Error details: input parameter

 

Here the input formula or the filed value is not in the expected format. 

Here the Flow is expecting either a String value or Date-time value. 

You can declare a string at beginning of flow and use append to string to store and pass the value. 

or use formula to convert it into specific date format by using the below formula : 

addDays('01/01/1900',sub(int(items('Apply_to_each_2')?['Date field name']),2),'dd/MM/yyyy')

Another Error : 

The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected Integer but got String.'.

Sometime the flow may give this error after a long time or when it is run by other user: 

Just duplicate the flow and make it as main flow fixed this issue. 

Plural name in Power automate flows and currency entity

 We need to enter the plural name in Power automate flows. 

Top 10 Features of – Microsoft Dynamics 365 and the Power Platform

 

Our Top 10 Features of – Microsoft Dynamics 365 and the Power Platform

As 2023 draws to a close, we wanted to highlight our top features across Dynamics 365 and the Power Platform. With some major changes taking place over the last year, we have once again been impressed by the features and functionality that Microsoft continues to develop. Take a look below to see our top 10 picks of the year, some old and some new!

Top Features Microsoft Dynamics 365

1. Microsoft launched Dynamics 365 Copilot

Our first top pick, which will come as no surprise, is Dynamics 365 Copilot. This recent addition to D365 fully embraces the advantages that artificial intelligence (AI) can bring to organisations. The Copilot functionality has been seamlessly integrated across all Dynamics 365 applications – sales, customer insights, customer service, field service, and customer voice and is directly accessible within the systems.

These new AI features make it easier than ever for your teams to collaborate, be productive, and drive growth across your business. You can find out more about the Dynamics 365 Copilot here.

2. Real-time marketing capabilities

Our Technical Delivery Lead, Nick, has chosen the real-time marketing capabilities as his top feature of 2023. This year marked a significant shift in Microsoft’s strategy towards real-time marketing, underpinned by the announcement of combining Dynamics 365 Marketing and Customer Insights.

This strategic move places focus on providing marketers with the tools they need to interact with customers at precisely the right moments. Key features enabling this include real-time customer journeys, live push notifications, and comprehensive, individual-based insights.

3. New pipeline view in Dynamics 365 Sales

First released in April of this year, the new pipeline view brings with it a host of benefits, the most significant one – being able to gain an intuitive view of all opportunities at the click of a button. This streamlined experience swiftly allows sellers to discern where sales efforts should be directed, ultimately increasing conversion rates.

4. AI-generated Summaries

As mentioned earlier, Microsoft has introduced AI across various Dynamics 365 applications. We’d like to highlight a noteworthy addition: AI-generated summaries.

These summaries are now available in Dynamics 365 Sales, Customer Insights, and Customer Service. They offer users a swift and simple way to gain a thorough overview of leads, opportunities, meetings, cases, and more. Have a look at what this could look like below:

Video Player

00:00

00:24

5. Dynamics 365 and Outlook Integration

Even though this feature was initially launched in 2022, Microsoft continues to improve the experience between Dynamics 365 and Outlook. Because of this, we have decided to include it in our summary of 2023.

The seamless integration between these two applications makes it possible for employees to quickly gain a comprehensive overview of all email communications sent to a customer. This ensures that everyone within your team is on the same page, increasing productivity and collaboration in the long run.

Top Features of the Power Platform

1. Copilot makes low-code development easier than ever

Like Dynamics 365, Microsoft has launched Copilot across the Power Platform with the aim of providing more support for users across applications, ensuring quick and efficient low-code development.

Copilot in Power Apps

Functioning as an AI companion, Copilot in Power Apps guides users through all stages of the app creation process – from creating and importing data tables to sharing the application and everything in between. Microsoft has achieved significant success with this addition, with a remarkable 65% increase in overall user satisfaction.

Video Player

00:00

00:38

Copilot in Power BI

With Copilot in Power BI, generating reports, crafting DAX calculations, summarising data, making inquiries about your data etc. is simple. Just state your needs in conversational language, and let Copilot handle the rest.

Copilot in Power Pages

Use Copilot as an assistant in Power Pages, letting it create parts of your web pages by giving natural language instructions. This makes creating new websites or making changes to existing ones faster and easier.

Copilot in Power Automate

Increase the success of your Power Automate flows with Copilot. Simply ask any questions regarding improvements, problems or other queries to Copilot, and it will assist you throughout.

Copilot Studio

Microsoft recently launched Copilot Studio, which will replace Power Virtual Agents. This new application enables users to effortlessly create or modify Copilots, ensuring they align precisely with an organisation’s requirements.

It’s worth noting that Copilot Studio has moved away from being part of the Power Platform and will now stand independently.

2. Launch of Power Pages

Earlier in the year, Microsoft introduced Power Pages, an evolution of Power Apps Portals. Various changes came with this announcement, but our Head of Managed Service, James Dilley, particularly found the new user interface to be much better.

Additionally, the option to make the Power Pages solution aware has streamlined the deployment of pages and increased overall efficiency.

3. Microsoft Fabric and Power BI

Microsoft Fabric is an all-in-one data analysis platform that brings together data movement, data science, real-time analytics, and business intelligence. Our Solution Architect, Aqib, highlights that this integrated platform enables users to enjoy an experience that fulfils all their data analytics needs.

Power BI is an integral part of Microsoft Fabric, and for customers with premium Power BI licences, access to this platform comes at no additional cost. For those without Power BI premium, rest assured – existing customers can continue to utilise Power BI just as they did before.

4. Refreshed look and feel for model-driven Power Apps

Model-driven Power Apps now have an updated user interface, introducing new themes, colours, fonts, layouts, shadows, and more. This change aligns the user interface with the latest Microsoft Fluent Design System and makes these apps easier to use and more efficient.

5. Coauthor in the modern model-driven app designer

In June, Microsoft announced the ability for both pro and citizen developers to make changes across modern model-driven apps at the same time and see these changes in real time. This significantly improves the ability of teams to innovate and create together, driving what low-code development can do further than ever before.