Introduction We need to register Dynamics 365 app in Microsoft Entra ID to enable secure authentication and authorization when connecting Dynamics 365 with other applications or services.It allows the app to get a Client ID and Secret, which are used to securely access D365 APIs without using user credentials. Steps: Go to Microsoft Entra admin... Continue Reading →
Update createdon field of existing records in Dataverse
Introduction Dataverse (formerly the Common Data Service) provides powerful capabilities for managing data within Microsoft Power Platform. One of the important metadata fields in every table is CreatedOn (or createdon in the backend), which stores the date and time when a record was created. However, what if you need to update or backdate the CreatedOn... Continue Reading →
Error: Guest user access is restricted in the organization
Issue: After a recent Microsoft update, guest users are unable to log in to the Dynamics system, receiving the error message: "Guest user access is restricted in the organization." Solution: This issue is occurring because Microsoft has recently introduced a new Public Preview feature called "Block guest user access" within the Identity and Access Security... Continue Reading →
Merge Related Table Rows Text Column in Power BI
Scenario: In the Power BI report, we aim to display all technology names associated with the current project using a card or any other visualization. The technologies are stored as a sub-grid within the Project form, with a many-to-many (N:N) relationship between Project and Technology, implemented through the bit_technology_project table. Issue: In Power BI, the... Continue Reading →
‘Attachment is Not a Valid Type or Too Large’ Error When Creating Notes
Issue: When attempting to attach a file in Notes of Dynamics 365 record, the following error occurs: "The attachment is either not a valid type or is too large. It cannot be uploaded or downloaded." This prevents users from successfully uploading or downloading the attachment. Solution: This issue typically occurs due to file size limitations... Continue Reading →
Canvas Apps Functionality with Code View
Feature: The Code View feature in Power Apps allows users to interact with the source code of their canvas apps in a readable and manageable format, making it easier to work with components, customize functionality, and create reusable templates. Below are detailed points on how this feature works and what it offers: Feature Details: This... Continue Reading →
Moving Power Portal Records
Problem Statement: In today's digital age, organizations are constantly seeking ways to streamline their processes, enhance user experiences, and make data management more efficient. One area where this need is particularly evident is in the realm of customer and partner interactions, often facilitated through web portals. Microsoft Power Apps Portals, a component of the Power... Continue Reading →
Delete disabled/deleted AAD users from Dynamics
Problem Statement: Microsoft Dataverse disables users when we delete user from Azure Active Directory or the Microsoft 365 admin center. However, these disabled users still occupy space and holds historical records. To overcome this issue, Dataverse offers a feature that enables the removal of disabled users. Solution: Microsoft has introduced new feature to delete disabled... Continue Reading →