web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Disable Data Validatio...
Power Apps
Unanswered

Disable Data Validation Tags by default - export to Excel in model-driven app

(0) ShareShare
ReportReport
Posted on by 2
Does anyone know how I can automatically have view exports from model-driven apps not include the data validation tags (example below)?
Data Validation Tag Example - Export to Excel
 
To be clear, this is the Excel file that is downloaded when a user running a model-driven app clicks the "Export to Excel" button from the action bar of any view in the model-driven app. I'm wondering if perhaps there is some table/app/environment setting or even a programmatic method through a Power Automate flow that calls the ExportToExcel via Dataverse API?
 
On the latter, I found an article discussing the capability here: Dataverse export to Excel with Power Automate
 
I know my users can manually remove them by opening the downloaded file, but I genuinely have no customers who need these as they almost exclusively leverage these exports for providing to team/customers and ad-hoc analysis. 
I have the same question (0)
  • Shashank Bhide Profile Picture
    942 Moderator on at
    check if you can select all data in excel and turn off validation as shown below.
  • CU28051302-0 Profile Picture
    2 on at
    @Shashank Bhide - This is what users currently do today, but we are looking to mitigate this extra step. None of our users need this validation and the pop-up bugs many of them so looking for a way to turn these off automatically or by default. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard