Dataverse Column Types

Dataverse Column Types
Column Type Description / Use Example Limitations / Notes
Single Line of Text Stores text up to 4000 characters Employee Name: "John Doe" Max 4000 chars; no formatting (rich text limited to 100k if enabled)
Multiple Lines of Text Longer text, supports multiple lines Description, Notes Max 1,048,576 characters; can enable rich text formatting
Choice (Option Set) Predefined dropdown list of values Status: Active / Inactive Only allows values defined in option set; cannot add free text
MultiSelect Choice Multiple options from predefined set Skills: Java, C#, Python Max 150 selections; cannot be indexed for filtering efficiently
Whole Number Integer values Age: 25 Range depends on format; cannot store decimals
Decimal Number Decimal values Price: 99.99 Up to 5 decimal places by default; used for calculations
Currency Monetary values Salary: $50,000 Auto handles currency formatting; precision configurable
Date and Time Stores date/time Hire Date: 17-Aug-2025 Time zone dependent; can choose User Local / UTC / Date only
Yes/No (Two Options) Boolean field Is Manager: Yes/No Cannot store anything besides True/False; displayed as checkbox or toggle
Lookup (Relationship) Reference another table Employee → Department Must select from existing records; enforces referential integrity
Customer Lookup to Account or Contact Order.Customer Only one of Account or Contact can be selected; enforces polymorphic lookup
Owner Assigns record to User or Team Owner: Alice Required for all tables; defines record access by security roles
File / Image / Attachment Store documents, images, or files Employee Photo Max file size ~128MB; not suitable for large volume storage; counts against Dataverse storage
Calculated Column Values calculated from other columns TotalPrice = Quantity * Price Cannot reference columns in other tables; recalculated automatically
Rollup Column Aggregate data from related records Total Sales per Customer Recalculated asynchronously every hour by default; delay possible
Encrypted / Secured Column Stores sensitive data SSN, Bank Account Requires column-level security; adds overhead; cannot be exported without permission

Comments

Post a Comment

Popular posts from this blog

Step-by-Step Guide: Power Automate Custom Connector Using Graph API from Azure App Service

Image
Step 1: Open Power Automate, navigate to the Custom Connectors tab, and select Create from blank as shown in the image below. custom connector(click image for better resolution) Step 2: In the General tab, upload an icon (less than 1MB), add a description, select the correct scheme (in my case, HTTPS ), and provide the host name. For example, if your API URL is https://graph.microsoft.com/v1.0/users/{email} , the host name will be the highlighted part — graph.microsoft.com . Step 3: Go to the Security tab. Here, you need to select the authentication method. Choose OAuth 2.0 as the authentication type, as shown in the image below. Step 4: Select the Identity Provider as Azure Active Directory . Check the box Enable Service Principal Support . This option allows you to create a connection using a Client ID and Client Secret instead of using the user's own authentication. Next, provide the Client ID , Client Secret , Tenant ID , and other required details as shown in t...
Read more

Calling Microsoft Graph API from Power Automate Using Azure App Services – Step-by-Step Guide

Image
Step 1: You should have an Azure subscription, or if you have access to the Microsoft Entra Admin Center, you can create an app from there. This app can then be used in Power Automate to connect to Microsoft Graph API. Step 2: Click on "New registration" , provide a name for your app, assign the required API permissions (such as Microsoft Graph permissions), and then click "Register" to complete the app registration process. Step 3: After registration, you'll be redirected to the app's overview page. From there, navigate to the API permissions tab and click "Add a permission" to assign the necessary Microsoft Graph API permissions. Step 4: Select Microsoft Graph as the API, and based on your requirements, choose the appropriate permissions. In my case, I selected Application permissions , which do not require user sign-in and are suitable for background services or automation. Step 5: Select the required Microsoft Graph API permissions. Yo...
Read more

Step-by-Step: Give Unique Permissions to OneDrive Files Using Power Automate and Graph API (No Premium License Needed)

Image
We are uploading files through Power Apps using the Attachment control. In the backend, a Power Automate flow uploads these files to OneDrive and assigns unique permissions . Since Power Automate does not have a built-in connector to directly assign unique permissions in OneDrive, we are handling this through the Microsoft Graph API (without using a custom connector). Step 1: Create a Blank Power Apps Application Open Power Apps Studio. Select New app > Start with a page design as shown below. Step 2 :  select Blank Canvas  Step 3: Add an Attachment Control In Power Apps, the Attachment control is not available directly from the standard controls list. To get the Attachment control: Add an Edit Form to your app. Connect the form to a SharePoint list . Once connected, the form will automatically include the Attachments field. You can then use this Attachment control to upload files. Step 4: Keep Only the Attachment Control Since we only need th...
Read more