Skip to main content

Notifications

Copilot Studio - General
Unanswered

Mail data extraction

Posted on by 3

how to extract Attachments Data from mail and store that data into excel table ? with sample flow image

  • Expiscornovus Profile Picture
    Expiscornovus 1,708 on at
    Re: Mail data extraction

    Hi @kavya1004,

     

    This sounds more like a Power Automate cloud flow related question.

     

    Below is an example with csv files.

     

    content_csv_file.png

     

    1. The first apply to each loops through the attachments.

     

    2. The second apply to each row of the csv attachment by using an expression to split each row of an csv

    skip(split(base64ToString(items('Apply_to_each')?['contentBytes']), decodeUriComponent('%0A')), 1)

     

    3. The add rows into a table map each column via another split function with an index. [0] for column A, [1] for column B and [2] index for column C.

    split(item(), ',')[0]

     

    addrowsintable.png

     

     

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,997

#3
Expiscornovus Profile Picture

Expiscornovus 1,708

Leaderboard