How to Show Notification in Model Driven App using C#

 Introduction:

In this blog, we will see how to show Notification in Model Driven App Using C#

Implementation steps:

For your function apps or console application once after the Organization service gets configured, call the below code to achieve the same

private static void SendInAppNotification(string subject, string description)
{
    Entity entity = new Entity("appnotification");
    entity.Attributes.Add("title", subject);
    entity.Attributes.Add("ownerid", new EntityReference("systemuser", USERGUID));
    entity.Attributes.Add("body", description);
    Service.Create(entity);
}

Conclusion:

Based on the above code we can easily achieve Notifications in Model Driven App

How to Clear Cache in Canvas PowerApps while working on Offline mode?

 Introduction

In this blog, we’ll look at how to clear cache in Canvas Apps when using the Power Apps mobile application, especially when the app behaves inconsistently.

Issue Faced

The app works perfectly in browsers like Edge, Chrome, and Firefox.
However, when running the same app on mobile:

• Sometimes it works

• Sometimes it doesn’t reflect recent changes

Troubleshooting Attempts

I tried the following steps:

• Created a new app → worked fine

• Tested in browser → worked fine

• Tested in mobile/tablet mode → worked fine

After making changes to the app:

• Browser version → worked fine

• Mobile version → did not reflect updates

I also tried clearing cache from mobile device settings, but that did not resolve the issue.

Solution (Fix)

The issue was resolved by clearing cache directly inside the Power Apps mobile application:

1. Open the Power Apps mobile app

2. Log in to your account

3. Tap your profile picture (top-left corner)

4. You will find a “Clear Cache” option

5. Tap it and confirm

Conclusion
Clearing cache from within the Power Apps mobile app ensures that the latest version of your Canvas App loads correctly and resolves inconsistent behavior.

How to Retrieve Security Role based on Access in Dataverse using FetchXML ?

 Introduction:

In tis blog, we will see how to Retrieve Security Role based on Access in Dataverse using FetchXML ?

Implementation Steps:

• Navigate to https://make.powerautomate.com
  
  
• Click New Flow
  
  
• Create an Instant Cloud flow
  
  
• Add Input Parameter as Name (to query what type of Access with Table Name)
  
  
• Same Formatting to pass as Input Parameter
  
  
• prv + AccessType + TableLogicalName
  
  • prv - Prefix
  • AccessType - What type of access?
    • Read
    • Write
    • Create
    • Append 
    • AppendTo
    • Share
    • Assign
  • TableName - Which table to query?
    • Account
    • Contact
    • etc
• Now Add List Rows
  • Add Table Name as Security Role
    
    

    <fetch> 
    <entity name="role"> <attribute name="name" /> 
    <attribute name="roleid" /> 
    <link-entity name="roleprivileges" from="roleid" to="roleid" alias="rp"> 
    <attribute name="privilegedepthmask" /> 
    <link-entity name="privilege" from="privilegeid" to="privilegeid"> 
    <filter> 
    <condition attribute="name" operator="eq" value="prvReadAccount" /> 
    </filter> 
    </link-entity> 
    </link-entity>
    </entity> 
    </fetch>

• In the above query am passing prvReadAccount
  • Am getting all security roles having Read Permission of Account
    
    
• Save and Run
  
  
• Sample image of Power Automate
  
  
• 
  
  
  
• Sample Output
  
  
  
  
  
• Output comes with Security Role Name and Privilege id as well
  
  Sample Privilege copied for ChatGPT
  
  
  
  
  

Conclusion:

That's it, try using this approach to quickly retrieve tables and their permission levels.

Strange Popup in Power Apps Confirm(): What’s Happening?

 Introduction:

In this blog we will see how to show New Confirm Pop up in canvas PowerApps

Implementation Steps:

• Navigate to https://make.powerapps.com
  
  
• Create a new App
  
  
• Change your App to New version
  
  
• Write Below Code
  
  
  • Confirm("Confirm Button Popup");
    
    
    • 
      
• You will see browser PopUp
  
  
• But this is not an Actual Canvas App Popup, Lets see how we can get new Canvas PowerApps Confirm()
  
  
  • Click Settings
  • Select Updates
  • Look for Modern controls and themes
    • Toggle it ON
  • Click Close
    
    
    
• Now Click the same button
  
  
• Now you will get the Confirm() canvas Pop Up
  
  
  
  
  

Conclusion:

By following above steps we can get rid of Browser Popup and get the new Canvas App popup.

Understanding the Confirm Function in Canvas Power Apps

 Introduction:

In this blog we will see how Confirm Function works in Canvas Power Apps.

Implementation Steps:

• Open https://make.powerapps.com
  
  
  
  
• Select Apps and Click New App and Select Start with a Page design
  
  
• Select Blank Canvas App and Click Create
  
  
  
  
• Once Page Opened, Verify the below PreRequisites
  
  
• Click Settings, select Support and make sure it is in Latest Version
  
  
  
  
  
• Once Selected Click Reload + apply version
  
  
• Save the App with Name
  
  
  
  
• Now Click Settings and Enable Modern Controls and themes
  
  
• Once App Loaded add a button 
  
  
• On Select of Button Write below Code
  
  
  • Confirm("Confirm Button Popup")
    
    
    
• Now Add below Code
  
  • Set(getSelectedOption,Confirm("Confirm Button Popup"));
    
    
• Add a label to form and provide Text as "getSelectedOption"
  
  
  • Now when user selects Confirm you will get response as True 
    
  • If User selects cancel you will get response as False
    
    
• Now Try below code for Title and SubTitle
  
  • Set(getSelectedOption,Confirm("Confirm Button Popup",{Title:"Header Title",Subtitle:"Sub Title"}));
    
    
    
    
• Now Try below code to update Confirm and Cancel Button text
  
  • Set(getSelectedOption,Confirm("Confirm Button Popup",{Title:"Header Title",Subtitle:"Sub Title",ConfirmButton:"Ok",CancelButton:"Ignore"}));
    
    
    
    
• Now try below Code​​​​​​​
  
  • If(Confirm("Confirm Button Popup",{Title:"Header Title",Subtitle:"Sub Title",ConfirmButton:"Ok",CancelButton:"Ignore"}),Notify("Confirmed"),Notify("Cancelled"));
    
    Based on selection it will show Popup if you Click Ok it will Notify as Confirmed else Cancelled
    
    

​​​​​​​Conclusion:

Going further we don't want to spend much time in Creating Popup :) by having simple command we can achieve this.

How to disable Form JavaScript Using URL in Model Driven app and MSCRM

 Introduction :

How to disable Form JavaScript Using URL in Model Driven app and MSCRM .

Implementation Steps:

• Navigate to your Environment
  
  
• Open the Form which is Broken in my Case it is CONTACT FORM
  
  
  
• Copy the URL and Put it in NotePad
  
  
  
• Append the Below Script in the URL
  
  &flags=DisableFormLibraries=true
  
  
• Final Output Will be
  
  
  
  
• Verify Form Loads Successfully
  
  
• Now if the Form Loads successfully it confirms that the issue is with Code
  
  
• Now you can open the form and add Debugger and Start your testing.
  
  

Conclusion:

Based on above steps you can easily find the issue either it is from JavaScript or Form issue.

How do I patch a Currency field value from a Canvas Power App to Dataverse?

 Introduction:

In this blog, we will see how to patch a Currency field value from a Canvas PowerApps to Dataverse or MSCRM

Implementation Steps:

1. Navigate to https://make.powerapps.com
   
   
2. Click On Apps
   
   
3. Click New and select Start from Page Design
   
   
   
4. Click Create
   
   
5. Now once the page opened Add a Datasource called Accounts
   
   
   
   
6. Now Add a Gallery and Select Items as Accounts
   
   
   
   
   
7. Now Add a Form and Select Items as Accounts and Gallery.Selected as Account
   
   
   
   
   
   
   ​​​​​​​
   
8. Add a Column Annual Revenue ( in my case am using account table as my DS)
   
   
9. Add a Submit Button
   
   
10. On select of Submit button add below code
    
    

    Patch(Accounts,
    LookUp(Accounts,Account = Gallery1.Selected.Account),
    {'Annual Revenue':Value(DataCardValue1.Text)})

Descrption about Code:

1. Patch - Save the record to DB
2. Account - Table Name
3. Lookup Query - Retrieve the record to Update
4. Annual Revenue - Column Name
5. Value - As Annual revenue is my Column to update it will expect Number 

Conclusion :

Using above code we can patch Currency field to Dataverse or MSCRM.

How to disable recently used records in lookup fields in CRM and Dataverse?

 Introduction:

In this blog we will see how to disable recently used records lookup field values in MSCRM or Dataverse




In my case, I want to hide the “Recently Used” section in the Parent Account lookup so that only recently created records are shown. Let’s see how we can achieve this.

Implementation Steps:

1. Navigate to https://make.powerapps.com
   
   
2.  Select Tables
   
   
3.  Look for Account Tables 
   
   
   
4. In the Account Tables select the Forms
   
   
   
5. Open Account Form
   
   
   
6. Once the Form Opened select the field PARENT ACCOUNT
   
   
7. At the right side you can see an Option to Select "Disable most recently used items"
   
   
8. Click Save and Pubish
   
   
9. Now open the Model Driven App and click the same field you cannot see the Recent Accounts
   
   
   
   
   

Conclusion:

By following above steps we can easily disable most recent records from Lookup.

How to Show/Hide Particular Views based on Security Role ?

 Introduction:

In this Blog, we will see how to show or hide particular views based on Security Role

Implementation Steps:

• Navigate to https://make.powerapps.com
  
  
• Click Tables
  
  
• Select the Tables you want to Restrict the views based on Security Roles
  
  
  
  
  
• In my case am Taking Account Table into Consideration
  
  
• Click On Account
  
  
• Select Views
  
  
  
  
  
• Select the Views and Click View Settings
  
  
  
  
  
• You can see 2 Options
  • Everyone
  • Specific security roles
    
    
    
    
    
    
    
• Everyone
  
  • If you select Everyone all the users in the system can able to see the Views
    
    
• Specific security Roles
  
  • If you select this you need to select Particular Role to see the views
    
    
    
    
    
• Once done click Save and Publish
  
  
• Now Open your Model Driven App
  
  
• Open Account Entity You can see the Security Role Applied
  
  

Conclusion:

By following above steps we can easily show or hide views based on security role.