Posts

How To Convert Floating Point Number to Nearest Integer & also Round Up || Down By Power Automate

Image
 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

Image
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

Image
  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

Display Dataverse Table Data In Power Pages by Using liquid Language

 Display Dataverse Table Data In Power Pages by Using liquid Language Display Dataverse Table Data In Power Pages by Using liquid Language CSS CODE:   /* styles.css */ /* Apply basic styles to the outer container */ .col-md-12.columnBlockLayout {     padding : 16px ;     margin : 60px 0 ;     min-height : 200px ;     background-color : #f5f5f5 ;     border : 1px solid #ddd ;     border-radius : 5px ; } /* Style the table */ .table {     width : 100% ;     border-collapse : collapse ;     background-color : #fff ; } /* Style the table header */ .table th {     background-color : #007bff ;     color : #fff ;     text-align : left ;     padding : 10px ; } /* Style the table rows */ .table td , .table th {     border : 1px solid #ddd ;     padding : 8px ; } /* Apply alternate row background color for better readability */ .table tbody tr:nth-child (even) {     background-color : #f2f2f2 ; } /* Style the button within the table cell */ .table button {     background-color :

Fetch XML For Dataverse Table

Image
 Fetch XML For Dataverse Table In D365 & Power Apps Youtube Video Link   Step 1 1. Click On Gear Icon 2. Go to the Advanced Setting In Power Apps Or In D365 3.  Click on Advanced Find.          New Window Will Pop-Up. 4.  Select The Table As Shown. 5.  Click On Download Fetch XML. Thank You Everyone. Keep Learning  Keep Growing Keep Exploring ✨ 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 hear your thoughts! Drop a comment below with your questions, ideas, or feedback—let’s get the conversation started! 🔗 Let’s connect and grow together! Follow me, Ravindra Jad

Enhanced Component Properties In Canvas Apps

Image
 Enhanced Component Properties In Canvas Apps Properties are still input or output properties, you can still define arguments. There are four types of properties available to makers: Data properties:      Data properties pertain to data, like a color or text value. A Data property can be set to be Input or Output, which indicates if the component provides data to the app (Output) or the app provides data to the component (Input). Data properties are the only properties that participate in app data flow. Function properties:      Function properties are related to logic, such as performing a calculation based on specific parameters or altering text. A Function property can be set to be Input or Output, which indicates if the component provides a function the app can call (Output), or the app provides a function the component can call (Input). Function properties do not participate in an app's data flow, and cannot use component or app variables. Action properties:      Action proper

Top 10 Considerations for creating Canvas App

Image
 Considerations for Creating Canvas App Before creating a Canvas PowerApps, there are several things to consider to ensure that the app meets your requirements and is efficient: Purpose:  Define the intention of your app, including what it should accomplish, who will be using it, and what data will be displayed. Data sources:  Determine the data sources that will be used to populate the app's content. This includes understanding the data structure, formatting, and access permissions. User interface:  Decide on the user interface design that will be used, including the layout, controls, and navigation. Functionality:  Identify the functions that will be required in the app, such as data input, data display, filtering, and reporting. Integration:  Determine whether the app will need to integrate with other applications or services, and what APIs or connectors will be required to enable this integration. Security:  Consider the security requirements of your app, including user authent