Import Excel File Data to Sharepoint that Contains Lookups, Choice Set Options, Multi-Currency & Text Fields
High level resolution steps Detailed resolution steps Step 1: Store the excel sheet in OneDrive and get it into Power Automate with a Manual Trigger or use an action called “List Rows present in Table”.In my case I have used it in the following way: Step 2: Get the lookup SharePoint List in the next […]
How to get Summation of Columns from Sharepoint or Dataverse into Invoices in Power Automate
In Dataverse/Sharepoint or any other dataset you cannot directly add a formula column and populate the summation of column into invoices High level resolution steps To achieve this, we have make use of Power Automate, where we Initialize/set a temp variable and global variable. Detailed resolution steps Step 1: Have a list of quantity/Unit column […]
Video blog: Convert Uploaded File into Base64 and View it as well
To convert an uploaded file into Base64 without staging the data in any cloud storage. High level resolution steps Detailed resolution steps Step 1: Develop a Power Automate flow and add it into the solution and add it into the app as well: Step 2: Add an attachment control using “Edit Form” as there is […]
D365 F&O to Dataverse Sync Job with the Help of Data Events Using Power Automate
To sync the data from D365 FinOps to Dataverse we can make use of Power Automate to getdata events logic. High level resolution steps Detailed resolution stepsStep 1: Activate Data events in D365 F&O for the desired entity in the location as shown below: Step 2: Create a Power Automate Flow for the Virtual entity […]
How to Enable Sample Data in Dynamics CRM
High level resolution steps Detailed resolution steps Step 1: Go to Power Platform Admin Center >> Environments Step 2: Select any environment and go to settings. Step 3: Go to Data management under settings >> and select Sample Data Output Sample Data will be added to all the entities listed in the environment.
Video blog: Number Sequence & Serial Number Generation in Canvas App
To generate a serial number in collections there is no direct way to get it apart from sequencecode. High level resolution steps Detailed resolution steps Step 1: In the onstart property of the app, give the below code: ClearCollect( Vehicles, { Year: 2016, Make: “Hyundai”, Model: “i10” }, { Year: 2016, Make: “Hyundai”, Model: “i20” […]
Send a Group Chat Notifications Dynamically in D365 CRM
How to Send a Group Chat Notifications Dynamically in D365 CRM High level resolution steps Detailed resolution steps Step 1: Go to your desired team, right click anywhere inside the teams and click on copy link as shown below: Step 2: Copy just the highlighted text from the URL you just copied from the above […]
Convert Base64 to URL & Consume in PowerApps
To Convert a Base64 string to PDF or any other image file >> there is no direct way to convert in PowerApps. High level resolution steps Detailed resolution steps Step 1: Use a manual trigger flow and pass the bas64 string.Step 2: Add a compose action and use the formula as shown in the below […]
How To OData Filter For Multi Relationship Levels For Dataverse Data
OData Filter For Multi Relationship Levels For Dataverse Data: High level resolution steps Detailed resolution steps Step 1: Trigger a flow using any method to get to know the unique row id.Refer to my other blog to get to know on how to call a power automate flow on click of a button in Model […]
Video Blog: Part2 Azure Token Generation and store the token for certain time using timer control in Canvas
To reload the Azure Authentication Token that has already been produced at the time you specify.The process of confirming the identity of users, apps, and services that communicate with Microsoft Azure resources is known as “Azure authentication.” It guarantees that data and services on Azure can only be accessed by authorized parties. A timer control […]