Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Suggested answer

How to delete auto create columns from PowerApp tables

(0) ShareShare
ReportReport
Posted on by 10
Hi Experts,
 
I am new in PowerApp / Power Query and need your help it can be a stupid question but please help me.
 
I have Oracle Database and i import table through PowerApps with required my columns, the required columns are successfully added, but i see that some extra columns (**added by PowerApps) it self now i use hide to column but usage of this table through dataverse on my copilot is not giving me correct results as copilot is reading extra columns.
 
I am also unable to delete these columns 
 

Hi Experts,

I am new to PowerApps and Power Query and need some guidance. Apologies if this is a basic question, but your help would be greatly appreciated.

Here’s my situation:

  1. I have imported a table from an Oracle Database into PowerApps, selecting only the required columns.
  2. However, I noticed that some additional columns (added by PowerApps) were automatically included.
  3. I tried hiding these extra columns, but when using this table through Dataverse with Copilot, the results are incorrect as Copilot reads these extra columns.
  4. Unfortunately, I’m unable to delete these columns from the table.

Is there a way to remove these extra columns permanently or to ensure Copilot does not read them?

Thanks in advance for your support!

Categories:
  • OM-22110953-0 Profile Picture
    10 on at
    How to delete auto create columns from PowerApp tables
    My Prompts are more specific but it gets results for system-based columns such as "Name"
     
    See attached screenshots
     
  • Suggested answer
    Anchov Profile Picture
    1,984 on at
    How to delete auto create columns from PowerApp tables
    You cannot delete these system columns because they are essential for Dataverse functionality and are automatically added to all tables. However, these system columns should not interfere with how Co-pilot interprets the data stored in the Dataverse tables. To get more meaningful answers from Co-pilot, you can try using a specific prompt to specify the columns in the data source you want it to prioritize, but I don't think this should be necessary.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Featured topics