Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Upload Excel and import in Dataverse

Like (1) ShareShare
ReportReport
Posted on 19 Sep 2024 07:35:22 by 12
Dear all, 
I have received a request from a cutomer to have the ability to upload an Excel in a model driven app and read it into a dataverse table.  The Excel should be edited automatically.  
 
So in real life the solution should be looking something like 
 
 
An additional difficulty is that the Excel should be transformed (format in screenshot), so empty lines van be removed automatically.
 
 
At this moment, i don't find a appropriate solution to achieve this.
Could someone help me out ?
 
Kind regards
 
Steve
Categories:
  • FLMike Profile Picture
    FLMike 27,286 on 21 Sep 2024 at 01:04:05
    Upload Excel and import in Dataverse
    why do people keep posting the same answer or suggestion way after its already there?
  • Suggested answer
    Ammar Zaied Profile Picture
    Ammar Zaied 97 on 20 Sep 2024 at 16:18:05
    Upload Excel and import in Dataverse
    You can load into Dataverse to trigger a Power Automate flow if you need to process the Excel file, then recreate the file in OneDrive, for example, and return the result to Dataverse.
  • timl Profile Picture
    timl 32,938 on 20 Sep 2024 at 15:14:21
    Upload Excel and import in Dataverse
    Hi Steve,
     
    The approach I would start off with is to build a Power Automate Flow. You can trigger it when a row is updated/added to your Dataverse table.
     
    In the flow, you can retrieve the attachment/Excel file and use the Excel connector to list the rows. You can filter out the empty ones and add the resulting rows to the target Dataverse table.
  • CA1105 Profile Picture
    CA1105 222 on 20 Sep 2024 at 10:21:00
    Upload Excel and import in Dataverse
    How you are reading the data from excel? Or is it like you downloaded the excel template for DV table and import from there?
  • Suggested answer
    FLMike Profile Picture
    FLMike 27,286 on 20 Sep 2024 at 05:29:21
    Upload Excel and import in Dataverse
    Hi
     
    There are different ways, but would you could do is either create a Collection based on XYZ column !IsBlank() and then it wont have the blank ones
     
    Or you can use a power automate flow, that will process the file and make it importable, and then point at THAT.
     
    So essentially either parse it in memory, or write it to SharePoint/OneDrive, remove the empty lines then import the output of that flow.

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,654

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,440

Leaderboard
Loading started