Answered

Extracted Excel Data To Attach In Email

(0) Share

Report

Posted on by Mhdirbaz

I've successfully set up a process where I receive around 10 to 15 emails daily, each containing an Excel attachment. My initial action is to save these attachments onto OneDrive, a step that is facilitated by the "When a File is Created" trigger.

Subsequently, I proceed to structure the data by creating a table within the Excel file. The columns of interest to me are "level1status" and "level2status". Both of these columns contain entries that could be either "success" or "failure".

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.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Mhdirbaz

I can see filter array action before apply to each action, could you pls share the screenshot of that action or tell me the intent of that action. This will help in finding the accurate solution.

Thanks

Was this reply helpful? Yes No
Mhdirbaz 13 on at

Like (0)

Report

Hi @ManishSolanki ,
Screenshot for your reference

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Mhdirbaz

As per my understanding, you are looking for "failure" status in multiple columns and if found you want to send an email with newly created one drive file as an attachment. If that is true, then pls make the following changes in your flows:
here I have filtered out records with failure value from 2 columns 'level1status' & 'level2status':
@or(equals(item()?['level1status'], 'failure'),equals(item()?['level2status'], 'failure'))

Next, we will check the length of filter array using length() function. We need to write an expression to execute the length function, the expression needs to be entered in expression box:
Expression used to check the length:
length(body('Filter_array'))

If filter array returns some records or has some failure records, then we need to add "Send an email" action inside "Yes" section or box. The details of email attachment come from the output of one drive action (When a file is created):

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Mhdirbaz 13 on at

Like (0)

Report

Hi @ManishSolanki
I am grateful for your assistance, Your input has been tremendously helpful in refining my workflow.
Thankyou

Was this reply helpful? Yes No