Skip to main content

Notifications

Power Apps - Power Query
Suggested answer

How to delete auto create columns from PowerApp tables

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,867

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,174

Leaderboard

Featured topics