Ravindra

Find The Unmatched and Match Records in 2 Array  by using power Automate  Create Different Types of Joint In Power Automate 1. Challenge: Handling and comparing two arrays based on a unique column in Power Automate without using the 'Apply to Each' action. 2. Objective: Find matching and non-matching records across two arrays. 3. Goal: Perform various types of joins on the arrays, including inner join, outer join, union, and others, using this approach. For More info 👇 https://youtu.be/s-cySUJixfI video ✨ Thanks for reading! ✨ I hope you found this blog on the Microsoft Power Platform helpful! From Power Apps, Power Automate (Cloud & Desktop), Canvas Apps, Model-driven Apps, Power BI, Power Pages, SharePoint, Dynamics 365 (D365), Azure, and more, I cover a wide range of topics to help you harness these powerful tools. Don’t miss out on future tips, tutorials, and insights—hit that subscribe button to get the latest posts right to your inbox. 💌 💬 I’d love to h

 Power Automate OData filter query in SharePoint Get Item In Power Automate, the OData filter query helps to retrieve only the data that matches specific criteria. Below is an example of how to write it in a flow. Example 1: Filtering SharePoint list items where Status is Approved Let’s assume you have a SharePoint list with a column called Status and you want to filter items where the Status is Approved . Filter Query: Status eq 'Approved' Status : The internal name of the SharePoint column. eq : OData operator for "equals." 'Approved' : The value you are filtering by. Example 2: Filtering records based on dates and another field Suppose you want to filter records where Status is Approved and the Created date is after 2023-01-01 . Filter Query: Status eq 'Approved' and Created gt '2023-01-01T00:00:00Z' and : Logical operator to combine multiple conditions. gt : OData operator for "greater than." '2023-01-01T00:00:00Z'

 Schedule, Dealy & Dealy Until In Microsoft Power Automate, "Recurrence," "Delay," and "Delay Until" are functionalities used to control the timing of your flows, but they serve different purposes and are used in different contexts within a flow. Here's a detailed explanation of each: 1. Recurrence Type: Trigger Purpose: Starts a flow on a scheduled, repeating basis. Usage: Scheduling Flows: The Recurrence trigger is used at the very beginning of a flow to specify when and how often the flow should run automatically. Configuration Options: Frequency: You can set the flow to run every minute, hour, day, week, or month. Interval: Specifies how often the flow runs within the chosen frequency (e.g., every 2 hours). Advanced Options: You can set specific start times, time zones, and even create complex schedules using cron expressions. Example: A flow that runs every day at 9 AM to send a daily report. Disadvantages: Fixed Schedule: The recu

 How To Convert Floating Point Number to Nearest Integer & also Round Up || Down By Power Automate How to Round (Up; Down) Decimal in Power Automate Decimal numeric Round-off is a renowned Math operation, that will always be a necessity while working with numbers irrespective of their complexity. When it comes to the Canvas app, we have multiple built-in methods available for Rounding a decimal namely  Round ,  RoundDown  and  RoundUp . Round ( Number ,  DecimalPlaces ) RoundDown ( Number ,  DecimalPlaces ) RoundUp ( Number ,  DecimalPlaces ) We also have scenarios to round off the decimal values in Power Automate. But, to our surprise, Microsoft has no specific function provided in the expressions, instead, we will have to use an action named “ Format Number ” under the “ Number Functions ” category. Format number only does a Round function in a traditional way by rounding up if the decimal digit is 5 or higher. Otherwise, this function rounds down. For Instance: 1.1 to 1, 1.5 t

how to add multiple choices in Dataverse using Power Automate through power Apps  Data Structure: Ensure your Dataverse table has a choice column with choices defined by labels and value. Power Apps: Utilize Power Apps to create a user-friendly interface for inputting and selecting choices, where users can easily understand the number-to-choice mapping. Power Automate: Build a flow in Power Automate that triggers the addition of a row in Dataverse. Mapping Values: In your flow, when adding a row to Dataverse, make sure to map the user's choice (number) from Power Apps to the Dataverse choice column that uses numbers ✨ Thanks for reading! ✨ I hope you found this blog on the Microsoft Power Platform helpful! From Power Apps, Power Automate (Cloud & Desktop), Canvas Apps, Model-driven Apps, Power BI, Power Pages, SharePoint, Dynamics 365 (D365), Azure, and more, I cover a wide range of topics to help you harness these powerful tools. Don’t miss out on future tips, tutorials, an

  Convert Multiple Excel Sheets Into Table Dynamically by Power Automate #PowerAutomate #powerplatform #excel #table #easy Converting Multiple Excel Sheets Into Table Convert Excel Data Into Table Format by Using Power Automate Dynamically https://youtu.be/jeceaMWDUPI?si=JTeiHVVqblgx-XjO 0:00 How to Convert Multiple Excel Sheets Into Table Dynamically 2:40 Convert Excel Data Into Table Format by Using Power Automate Dynamically Problem Explain 9:30 Create Table In Excel 14:30 Error Handling In Power Automate syntaxs- File Name Expression - triggerBody()['File']['Name'] URL of Request Of http Connector https://graph.microsoft.com/v1.0/me/drive/root:/[addNameOffFile]:/workbook/worksheets('[SheetName]')/usedRange [addNameOffFile] & [SheetName]Select Form Dynamic Content For More Information Connect On Different Platforms- https://linktr.ee/jadhav_ravi_oo7 ✨ Thanks for reading! ✨ I hope you found this blog on the Microsoft Power Pl

 Use Case  To automatically export Dataverse Custom Tables daily to Excel and save those backups versions in OneDrive. Those tables include Lookup columns and Choices columns. We will use those backups as a second backup in addition to the Power Platform Environment system backups. In case of Data Loss, or Corruption, we can Bulk Delete the Dataverse Tables records and use Dataflows to load the data from the Backup Excel Files. Create The Table In Microsoft Dataverse                                                                                                                                                                                                                                                                                              Data In this blog, we are only going to create a scheduled backup for one table in Dataverse, and it's called RavindraTable .   Power Automate Scheduled Cloud Flow: tart by creating a Power Automate Scheduled Cloud Flow in the same Dataver