Answered

Assistance Needed with Excel Data Extraction Flow

(0) Share

Report

Posted on by Mhdirbaz

Hello,

I am reaching out to seek guidance on setting up a workflow to extract specific values from Excel files. I'd like to walk you through my understanding of the process and gather your expertise to ensure I am on the right track.

Currently, my situation involves receiving approximately 10 to 15 emails per day, each of which includes an Excel attachment. My initial step is to save these attachments to a designated OneDrive location for further processing. To achieve this, I am utilizing the "When a File is Created" trigger, which has proven effective.

The next step in my workflow involves creating a table to structure the data within the Excel file. Specifically, I am interested in extracting values from three columns: F, G, and H. These columns exclusively contain either "success" or "failure" entries.

The critical juncture in this process occurs when I identify a "failure" entry within any of these three columns. In such cases, my objective is to promptly generate an email notification. This email should include the original Excel file as an attachment, enabling swift analysis and resolution of the underlying issue.
screenshot for reference :

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

SanmeshG 1,947 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Mhdirbaz ,

After you create a table in Excel , you can use the list present in a table action and read the excel table data.

Then you can use the select data operation (using value array as input from list rows present in a table action) and read the data from only the three columns that you want to read.(this step is optional - you can directly use the filter array action and filter the rows with Failure messages).

You can use the filter array operation and filter the data based on the Failure status.

@Or(equals(item()?['Level1Status'], 'Failure'),equals(item()?['Level2Status'], 'Failure'))

Hope this helps!

Thanks,

Was this reply helpful? Yes No
Mhdirbaz 13 on at

Like (0)

Report
Copy link

Link copied!

I am grateful for your assistance, @SanmeshG . Your input has been tremendously helpful in refining my workflow. I have one more step that I'd like to discuss,Here's where the additional step comes into play: I want to introduce a scenario where if a "failure" is identified in either the "level1status" or "level2status" columns, an immediate email notification is triggered. This email should contain the exact Excel file as an attachment, allowing for a swift and efficient examination of the issue at hand.

Was this reply helpful? Yes No