Introduction: It is difficult to work with Dates, and there is no exception with PowerApps (Canvas App). Recently, I had to get the duration between two datetime value. Normally, this is a normal task to achieve and can be done quickly.... but you are wrong. Calculating the difference between two Date/Time in hour/minutes format is…
Set Default value of Two Options on New form in PowerApps
Introduction: In this blog, we will learn how to set Default Value of Two Options on New Form. Use Case: We have a requirement where there is a Field(Data Field: Two Options) on the form, which should show "NO" as Default value. The Field on the Form is a Combo Box Steps: This is the…
How to handle Excel Dates in Cloud Flows/Power Automate
Introduction: Working with Dates can be problematic sometimes, and there is no exclusion with Power Automate. Recently, I had to get all the rows present in the Excel table. You will think that this is totally normal task to achieve and can be done quickly.... but you are wrong. Everything will work except Date fields…
Convert Ticks(nanoseconds) to Milliseconds in Power Automate
Introduction: Converting Date Time is one of the important functionality which is used in Power Automate. There are some scenarios where the user might need to convert date into millisecond's or get the same result of JavaScript's date.getTime() into flow. Note: getTime() method returns the number of milliseconds since midnight of January 1, 1970 and…
Lookup Field in form with multiple search column in PowerApps
Introduction: In this blog, we will learn how to set multiple search columns in a Lookup Field. Use Case: We have a requirement where there is a Field (Data Field: Lookup) on the form, which should search records according to multiple columns. The Field on the Form is a Combo Box Steps: 1.This is the…
Hide certain Field of the form depending on Security Role of the User using PowerApps.
Introduction: In this blog, we will learn how to hide fields from the form based on the Security Role of the Logged in User. Use Case: We have a requirement where there are some Fields in the form, which should be hidden to the users who does not have the Security Role as Manager. Steps:…
Delete file from SharePoint document library from Canvas Apps- PowerApps
Today, we will see how to delete documents from SharePoint document library through PowerApps. There are several demand where the user wants to delete document from SharePoint document library directly from PowerApps. To achieve this, I am going to use Cloud Flows “Delete File” action. Solution: 1. Pass the "ServerRelativeUrl" from the PowerApps to Cloud Flows.…
Upload file to SharePoint document library from Canvas Apps-PowerApps
Today, we will see how to upload documents in SharePoint document library through PowerApps. There are many requirement where the user wants to upload document in SharePoint document library directly from PowerApps. To achieve this, I am going to use Cloud Flows “Create File” action. And there are many other pre requisite steps that need…
Open SharePoint Files in Browser from Canvas App- PowerApps
Sometimes when you know some formulas should work but it doesn't. Here’s a scenario which I came across with an issue where the "Launch" function. I had a button which had Launch function which should have launched the SharePoint document in browser. But when I clicked on the button, it saves the document to my…
View SharePoint Documents in Canvas Apps using Power Automate/ Cloud flows
There are several demand for surfacing documents in sub grids or having the ability to access documents saved on SharePoint from Dataverse through Canvas Apps. To achieve this, I am going to use Cloud Flows “Send HTTP Request to SharePoint” action. Solution: 1.I have a button on PowerApps which we will call the flow and pass the Guid of the record. Call…
Triasha's Dynamics 365 Blog 