Posts

Showing posts from October, 2023

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