Skip to main content

Notifications

Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Help us with Power Pages Makers & Tenant Admin
News and Announcements icon
Power Platform Community / Forums / Power Apps - Power Query / Multiple Rows - Dataverse
Power Apps - Power Query
Suggested answer

Multiple Rows - Dataverse

(0) ShareShare
ReportReport
Posted on by OM-22110953-0 4
 

Hi,

I am new in Power Platform / Copilot Studio and need your help regarding this.

I have connected PowerApps - Tables with my Internal Oracle Server Database and Select one demo table "Sales" which has 6 columns and 12 rows. (All Screenshots attached)

The Dataverse is successfully import from Oracle Database but when i click on SALES columns and data i can see duplicate entries added like i have two entiry for every month (duplicate rows).

 

Observation: i tried to delete the duplicated row from PowerApps but i can see after some times the duplicate rows occurred again.

 
Categories:
General Comment
6.jpg
7.jpg
2.jpg
  • ronaldwalcott Profile Picture
    ronaldwalcott 1,501 on at
    Multiple Rows - Dataverse
    What is your process for importing data?
    How do you plan to ensure that same records cannot be imported more than once?
    You should identify primary keys on your Oracle database and duplicate in Dataverse if you are importing data. This would prevent the process from importing the same data.  
  • Suggested answer
    SaiRT14 Profile Picture
    SaiRT14 1,931 on at
    Multiple Rows - Dataverse
    pls try the following:
     
    Check for Duplicate Data in Oracle 
    SELECT column1, column2, COUNT(*)
    FROM Sales
    GROUP BY column1, column2
    HAVING COUNT(*) > 1;
     
    Ensure your table in Oracle has a unique identifier column (e.g., ID) - In PowerApps, map this unique column as the Primary Key when connecting to the Oracle database. Go to the table settings in PowerApps. Identify the key field for the table (ID, SalesID, etc.).
     
    Use the Distinct function to ensure unique row - Distinct(Sales, ColumnName)
     
    try the above and let me know.

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

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Help us with Power Pages Makers & Tenant Admin

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans