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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to delete auto cre...
Power Apps
Suggested Answer

How to delete auto create columns from PowerApp tables

(0) ShareShare
ReportReport
Posted on by OM-22110953-0 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!

Untitled.jpg
Categories:
Power Query
I have the same question (0)
  • Suggested answer
    Anchov Profile Picture
    Anchov 1,986 on at
    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.
  • OM-22110953-0 Profile Picture
    OM-22110953-0 10 on at
    My Prompts are more specific but it gets results for system-based columns such as "Name"
     
    See attached screenshots
     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 493 Most Valuable Professional

#2
11manish Profile Picture

11manish 479

#3
Haque Profile Picture

Haque 328

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans