Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Extract specific fields from CSV and convert into JSON array

(0) ShareShare
ReportReport
Posted on by 15

Hi, I am attaching test.csv please unzip it for working with csv data.

I would like to have a Json array which will store email address, % of Total Assignments and Completion Status for each record

and store it into json array.

I am also attaching screen shot which shows exactly which fields i need. I appreciate your help

Thanks

ismaredia_0-1719501974702.png

 

Categories:
  • ismaredia Profile Picture
    ismaredia 15 on at
    Re: Extract specific fields from CSV and convert into JSON array

    Hi Nived, Please see the sample output below, 

    Its not compulsory to have exact same format, But we need in JSON output which is similar to the format below. Thanks

     

    [{"Email":"123@gmail.com","TotalAssignements":28,"CompletedStatus":80},{"Email":"123@yahoo.com","TotalAssignements":18,"CompletedStatus":10},{"Email":"123@hotmail.com","TotalAssignements":58,"CompletedStatus":62},{"Email":"test@gmail.com","TotalAssignements":28,"CompletedStatus":80}]

  • Nived_Nambiar Profile Picture
    Nived_Nambiar 17,086 on at
    Re: Extract specific fields from CSV and convert into JSON array

    Hi @ismaredia 

     

    so for every email id - you need these requested field details in array format - correct ?

     

    if possible could you please share how output looks like ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

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

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard