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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Problems importing dat...
Power Apps
Unanswered

Problems importing data from excel to Dataverse

(0) ShareShare
ReportReport
Posted on by 80

I am trying to import data from an excel table into a dataverse table.The Flow I created triggers off the creating of a file in  a sharepoint document folder.

 

I am experiencing two major problems

1) sometimes multiple instances of the flow are triggered. today 20 copies of the flow were created when the file was created!!!

2) even when only one flow is triggered, duplicate records are created. These are the steps I am taking:

I create a list of all the records in the file:

ListRows.png

 

Then for each record i check if it is not blank. otherwise, i add a new row to the Dataverse table

ApplyToEach.png

 

 

 

I cannot figure out why these are happening. I have spent so much time on this..... 

I am begining to believe that it is not possible to do what i planned and I need to scrap the project....

 

 

I have the same question (0)
  • Anton_Dali_UKR Profile Picture
    75 on at

    Hi. Could you tell me please what is entire purpose of this task? Do you need to provide data import one time or this is recurrence activity?

    If first assumption is correct I would rather use standard import dataverse feature. All what you need is just populate your data in the essential xls. file downloaded from dataverse and upload it back. 

    Shout if you need an assistance where to find it

  • moshe raab Profile Picture
    80 on at

    this is a daily recurring task. unfortunately, i do not have control over the format of the excel file. the file is created in a different system and is ftp-ed.

     

  • moshe raab Profile Picture
    80 on at

    i just noticed that the difference between the duplicated records is that one has a timezoneruleversionnumber value of 0 and the other is 4. I can only see this when i export the table's data to a CSV file. 

    i see that this is/has been deprecated. so why is it showing up? How to i prevent this or work around it? do i have to add the timezoneruleversionnumber to each of my queries?

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

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard