Get Dynamic 365 field metadata in a canvas app using DataSourceinfo function.

 

Gallery and Forms are used to work with Common Data Service Entities data from Dynamics 365 like Accounts, Contacts and Opportunities.

We can retrieve Some of the common field level metadata info like MinValue, MaxValue and MaxLength of a field.

We can leverage DataSourceInfo function to enrich your Common Data Service form in a Canvas Power App by showing some metadata about fields. Something like below screen shot.




DataSourceInfo function:

DataSourceInfo is a function that provides some information about the DataSource itself or the columns present in the Data Source.

In this article, I’m trying to show some metadata fields values from Dynamics 365 using CDS Data Source.

I have create a sample canvas app and added few labels to show these values.


MaxLength

MaxLength is used to show the maximum allowed capacity of a field. Most useful to show the maximum length of fields such as a Multi-line Text Field in Dynamics 365 CRM.



I have placed maxLen label below the Description field and added formula in Text() function.


In the above formula, in Text() function, I have written

DataSourceInfo is the formula that will take arguments like Data Source, DataSourceInfo.<Function> & Column name.

Accounts is the Data Source itself since it is connected to Accounts entity in Dynamics 365.

MaxLength is the attribute which will tell us the Maximum allowed length for the field we will enter next.

"description" denotes the name of the column in double-quotes of which we want to know the MaxLength.

 

MinValue & MaxValue

MaxValue & MinValue are used to show the minimum & maximum value allowed in the fields in Dynamics 365 CRM.

Let’s have Shares Outstanding is a custom field which is Whole Number.



I have placed minVal and maxVal labels below Shares Outstanding field in the Canvas Power App.




In the above formula, in Text() function, I have written

DataSourceInfo is the formula that will take arguments like Data Source, DataSourceInfo. <Function> & Column name.

Accounts is the Data Source itself since it is connected to Accounts entity in Dynamics 365.

MinValue and MaxValue are the attributes which will tell us Minimum & Maximum allowed data values for the field user can enter in the field in the next parameter.

"Shares Outstanding" denotes the name of the column in double-quotes of which we want to know the Minimum and Maximum allowed Value.





Comments

Post a Comment

Popular posts from this blog

How to implement approval in Teams using Adaptive Cards

Image
  Adaptive Cards are self-contained user interface components that transcend platform boundaries. Crafted in JSON format, these snippets of UI can be seamlessly exchanged between applications. Upon reaching a particular application, the JSON content is dynamically rendered into native UI elements, seamlessly blending with the app's aesthetic. This approach facilitates the creation and seamless integration of lightweight UI elements across diverse platforms and frameworks. User Story: We're preparing to implement a leave approval workflow in Teams utilizing adaptive cards. Employees will submit their leave requests, and line managers will receive notifications within Teams. Step 1 – Design the Adaptive Card Prior to establishing the flow, let's initiate the card design process using the designer tool to ensure readiness. Visit https://adaptivecards.io/designer/   to access the designer interface and adjust the 'host app' setting to Microsoft Teams – Light /...
Read more

Open canvas app with Customize the command bar using command designer

Image
  This topic guides you through creating and editing modern commands using the command designer and Power Fx. Create a new model-driven app using modern app designer 1.      Sign into  Power Apps 2.      On the left navigation pane, select  Solutions  and then open or create a solution to contain the new model-driven app. 3.      Select  New  >  App  >  Model-driven app 4.      Select  Modern app designer , and then select  Create .    Enter a  Name  for your app, and then select  Create . More information:  Create a model-driven app that has an account table page 1.      On the left navigation pane, select  Solutions , and then open the solution containing the existing model-driven app. 2.      Select the model-driven app, and then select --  >  Edit ...
Read more

HTTP Request Methods

Image
  1. 𝗚𝗘𝗧 : GET Method is used to request information from a website, Server or from API. Example: GET/api/employee/{employee-id}   2. 𝗣𝗢𝗦𝗧 : POST Method is used to create a new resource in server. We can send data to the server in the request body. Example: POST/api/employee/department   3. 𝗣𝗨𝗧 : PUT Method is used to update an existing record by sending the updated data as the content to request body to the server. Example: POST/api/employee/55445   4. 𝗗𝗘𝗟𝗘𝗧𝗘 : DELETE Method is used to remove resources from the server. Example: DELETE/api/employee/55445   5. 𝗣𝗔𝗧𝗖𝗛 : PATCH and PUT are similar use to updates a resource, but it will update data partially but not fully. Example: PATCH/api/employee/55445{"Name: Employee Name"}   6. 𝗛𝗘𝗔𝗗 : HEAD Method is like the GET but it doesn't have any response body. Example: HEAD/api/employee   7. 𝗢𝗣𝗧𝗜𝗢𝗡𝗦 : OPTIONS Method is used to get the informatio...
Read more

Create email templates in dynamic 365 and send email using Power Automate

Image
We can utilize email templates with Power Automate to send emails. Follow these steps to use email templates with Power Automate. ·         Create Email Template in dynamic 365. ·         Configure Power Automate to Email Template. Create Email Template in dynamic 365: Navigate to Power Platform admin center, navigate to the Environments tab, and select your environment you wish to create email template refer below screen short. Click on setting and look for Templets and click on Email Template. Click on new on tool bar. The Email Template Type dialog box will open. Select the desired entity and then click OK. On the template form, provide a name for your email template and, if desired, add a description. Note that the email template name and description will not be visible to the recipient. Enter the text you want to send in the message. Use the formatting toolbar to edit and style your...
Read more

Duplicate Detection in Dynamics 365 using power apps.

Image
  User Case: When setting up a contact in Dynamics 365, verify if a contact with the same email address already exists. If it does, prompt an error message indicating a duplicate email address. Step 1 :  Navigate to make.powerapps.com, screen 1 à Create a Blank Canvas App à Connect with Dynamics 365 Data Source à Connect Contact Entity as Dataset (You can connect other entity also as per your requirement) Step 2:   Screen 2 - Insert a new Blank Screen to show Duplicate Detection Dialog Step 3:   Add few Text Input and Button Controls in Screen 1 or design as per your need. Step 4:  Add below formula on Button Control (onSelect property) to find Duplicate Record. If ( IsBlank ( LookUp ( Contacts , emailaddress1 = Emailaddress_Text . Text )), UpdateContext ({ result: "Duplicates Record not found" }), Navigate ( DuplicateDetectionDailogbox , ScreenTransition . CoverRight ) ) ; You can use following formula also on Button Control (onSelect property...
Read more