Posts

Syncing Power Automate Approval Status Across Teams, Outlook, and Apps

Image
Syncing Power Automate Approval Status Across Teams, Outlook, and Apps Introduction Power Automate provides robust approval workflows that integrate seamlessly with Microsoft Teams, Outlook, and custom applications. However, synchronizing approval statuses across these platforms remains a challenge. This blog will discuss a practical solution to ensure that approvals made from one platform reflect across all others without relying on Microsoft Graph API (which is currently in preview) or complex Azure AD app registrations. The Challenge A user receives approval requests via: Microsoft Teams Outlook A direct link to the app If a user approves the request from the app, it should also reflect as approved in Teams and Outlook. However, Power Automate lacks a built-in feature to achieve this easily. Microsoft Graph API can perform approval actions but remains in preview mode, making it unsuitable for production. Additionally, registering an app in Azure AD increases complexity and maintenan...
Post a Comment
Read more

Extracting Email Address from a PDF Using Power Automate and Dataverse Plugin Without Third-Party Paid Services

Image
Extracting Email Address from a PDF Using Power Automate and Dataverse Plugin Without Third-Party Paid Services In today’s world, automation plays a pivotal role in improving business efficiency. One such automation requirement is the need to extract email addresses from PDF attachments within emails. For many businesses, this task needs to be performed on a regular basis. In this blog, we will explore a solution for extracting the email address from the second-last page of a PDF using Power Automate, Dataverse plugin, and a custom integration, without relying on costly third-party paid services. The Challenge A business requirement emerged where every time an email with a PDF attachment was received, we needed to extract an email address from the second-last page of the PDF and forward the email to that specific address. Power Automate, while incredibly powerful, does not natively support text extraction from PDFs, making it difficult to directly handle this requirement. Using third-p...
Post a Comment
Read more

Embedding Canvas Apps in Model-Driven Forms Using Logical Names: A Solution to Deployment Challenges

Image
I would like to share knowledge related to embedding a Canvas app in a Model-driven form using the component with only the logical name. This blog will walk you through the challenges, problems, and a simplified solution for seamless deployments.  Challenge Embedding a Canvas app in a Model-driven form traditionally required the app's unique ID. However, this posed a challenge during deployments to different environments, as each deployment generated a new app ID. This forced developers to manually update the app ID in the form component, leading to unmanaged solution layers and additional effort. Problem Manually changing the app ID after every deployment not only consumed time but also introduced potential errors and inconsistencies across environments. This process disrupted smooth deployments and affected overall project efficiency. Solution A new, more efficient method has been identified: using the Canvas app's logical name instead of its app ID. By entering the logical n...
Post a Comment
Read more

Canvas App Text Input Runtime Validation

 Validating Text Input for Decimal Values in Canvas App Using a Slider Control Overview:   In Power Apps, ensuring that user inputs adhere to specific formats can be a challenge. One such scenario is limiting the number of decimal places a user can input in a text box. While the OnChange event in the Text Input control triggers only after focus is lost (when the user clicks outside the input box), we can enhance runtime validation by leveraging the Slider control to handle real-time typing. In this blog, I will show you how to use a Slider control to enforce that a user cannot enter more than two decimal places in a text box. Steps to Validate Decimal Input Using a Slider Power Apps text input controls don't always trigger validation during typing. Here's how you can implement real-time validation to restrict a user from entering more than two digits after the decimal point by using a Slider control. 1. Add Text Input and Slider Controls Insert a Text Input control ( TextInp...
Post a Comment
Read more

RSA Encryption with Power Platform Custom Connector

Image
  Introduction : I recently embarked on a mission to bring RSA encryption into the world of Power Platform. But it wasn't easy. The tools available just didn't fit the bill. The main problem? The C# code needed for encryption was outdated, leaving out crucial methods. Plus, there was no direct way to encrypt using the given key. So, I had to get creative. The Challenge: Picture this: I'm staring at a mountain of code, knowing I have to find a way to make it work within the limited environment of Power Platform. The biggest hurdle? I needed to extract specific parts from the public key – the exponent and modulus – to enable encryption. Solving the Encryption: Armed with the extracted components, I was ready to put the pieces together. With the exponent and modulus in hand, I could finally encrypt data within Power Platform. What once seemed like an impossible task was now within reach, thanks to perseverance and a little creativity. C# Code Part using Newtonsoft.Json.Linq; ...
Post a Comment
Read more