Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Answered

Parsing a CSV real-time to check for potential issues prior to upload

(0) ShareShare
ReportReport
Posted on by 101
I have a model-driven app with a custom page that allows for end-users to upload a file, which then puts it in a File Uploads Dataverse table. This triggers flows that work with the uploaded file. I'd like to do some rudimentary checks of the file prior to saving it to the table so that I can give the end user some guidance on potential issues. Essentially, I want to try and parse the first few lines of the CSV in order to try and give the end user things to look at prior to saving the upload to our tables.  I'm struggling with finding any decent solutions for this or an approach that won't break the bank on licenses. I'm curious if anyone can point me in the right direction for how to approach this. Thanks in advance for any help anyone can lend.
  • Verified answer
    FLMike Profile Picture
    FLMike 29,419 on at
    Parsing a CSV real-time to check for potential issues prior to upload
    Hi
     
    One option would be as part of your page to call a power automate flow, pass it the details of the file, (if you need to temporarily save it in SharePoint or other secure location while doing your validations, then delete it).
     
    While you could also save it to a working table, which would trigger a power automate flow and do validations, it would not come back to your page, it would have to tell them later.
     
    So you would let them know you are doing verifications and they will hear back shortly
    Save it into working table
    Flow triggers
    It does the validations etc
    if all good it saves it in the table and updates some tracking data in your working table, or deletes it
    If it doesn't work, it would email you and them, letting them fix and retry later.
     
    Technically you could trigger a flow in your page, but i'd have to see the page and how you are creating it to say exactly how and you want to make sure its can take the file data, save it temporarily (as above suggestion), do the work in real-time, then let you know if it worked or not and if not, give you back the list of issues, which you give back to the user and wait until they retry.

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

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,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard