Unanswered

Scanning Excel files from SharePoint and send values with Outlook

(0) Share

Report

Posted on by Luchoef

Hi there,

I am looking for quick assistance for the following issue:
I've got an Excel-file on a SharePoint library. In this Excel file, there is a table. Column 1: Machines, Column 2: value either 0 or 1

The goal is to implement a PowerAutomate Flow which 'scans' the Excel file from the SharePoint and to send an E-Mail. In this E-Mail the correlating values should be stated. E.g. Machine A - 1, Machine B - 1, Machine E - 1. Can anyone help here please?

Thanks in advance!

Best

Lucas

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report
@Luchoef

While I don't totally understand your requirement, you Flow will use the Excel List rows present in a table. From there you have two options:

Loop though the rows looking for rows (use a condition) that meet your requirement and send emails

Use a filter query in your List rows action that limit the rows returned to those that meet your criteria. Then loop through and send emails to each

If you can explain a little more about what you want to do and provide a screen shot of part of the Excel table to include the header row, I can provide a more specific answer.

Was this reply helpful? Yes No
v-chenzhi on at

Like (1)

Report

Hi @Luchoef ,

Do you want to email the values in Excel?

As @ScottShearer mentioned, we could use List rows present in a table and filter excel.

I have a test according to your scenario, please mark @ScottShearer answer as solution if it works.

I have this in excel

Here is the flow.

Best Regards,

Zhi Chen

Was this reply helpful? Yes No