Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Pro Dev & ISV
Unanswered

Import data from custom file format to dataverse

(0) ShareShare
ReportReport
Posted on by 9

I have a Power App using dataverse as the backend and I need to allow a user of the app to upload a file (in an entirely custom format) such that the file is then parsed (where I will obviously need to write custom code to do this) and imported to the database as one or more new records.

 

Can you tell me how I can do this please?   I assume it's possible!

  • cchannon Profile Picture
    4,702 Super User 2025 Season 1 on at
    Re: Import data from custom file format to dataverse

    @MatMd did these posts help solve your issue? If so, please mark one as the solution so future readers can see.

  • cchannon Profile Picture
    4,702 Super User 2025 Season 1 on at
    Re: Import data from custom file format to dataverse

    Add a new column of type Attachment to your form.

     

    Create a Power Automate Flow that fires on Update of Record for this new column.

     

    Read the file (I assume it is some kind of text file?) and parse its contents according to whatever logic this custom format has.

  • Narayana Swamy S Profile Picture
    42 on at
    Re: Import data from custom file format to dataverse

    do you want to create a table on air and upload the data into dataverse?

  • Moximox Profile Picture
    135 on at
    Re: Import data from custom file format to dataverse

    Hi

    yes it is possible but without knowing more details about the file and what type of records you want to create then it is impossible to give a solution with any certainty. But simplest way would be to build a pcf that you use in your powerapp and upon upload to an intermediate table this would trigger a powerautomate flow that would parse and create the records using dataverse actions. 

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Power Apps Pro Dev & ISV

#1
WarrenBelz Profile Picture

WarrenBelz 109 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 82 Super User 2025 Season 1

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 72

Overall leaderboard