Answered

Need help getting ODATA filter for excel to email power automate chain

(0) Share

Report

Posted on by DANIELMITCHELL

I am currently trying to power automate when a file in excel gets edited on a specific column (which has data validation for 2 words: Approved/Denied) to send an email out. Currently my flow sends an email out whenever ANYTHING is edited on the document. I need help with what to put into the ODATA filter query in order to only send email when that column is edited.

Below is a picture of my current flow.

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DANIELMITCHELL

So currently there is no trigger on the excel connector where it can be triggered on update or Modified , The filter query on the List Rows Just get the rows with a specific Filter, so I suggest to use SharePoint list instead for this purpose and then you can trigger it on the change of the field being modified.

Was this reply helpful? Yes No
DANIELMITCHELL 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply! What flow do you recommend?
I have a form that pushes to this excel sheet. I added a column for approved/denied and want an email based on form responses based on that row to send once that rows cell has been updated.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DANIELMITCHELL

So can I understand more:

You have a Microsoft form that you use to collect responses into the Excel Sheet is that correct?

And then you want to send a consolidated email based on the responses?

Was this reply helpful? Yes No
DANIELMITCHELL 12 on at

Like (0)

Report
Copy link

Link copied!

Yes, I have a Microsoft Form that dumps to excel.
I added a column to the table below for Approved and Denied and used data validation to limit responses.
I want an email to be sent out using form responses once that cell has been modified.
The way I have it now sends based on any change to the document. But, I only want it to send if that rows cell for approved gets modified. And the email only be referencing that rows form responses.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DANIELMITCHELL

What do you use as a trigger for the for your flow that sends email is it a scheduled that runs daily checks the excel ?

I tried with Filter Query and it did not work but the below approach worked to get only rows with the Approve Or Denied Column with data

Let me know if you need further help!

Was this reply helpful? Yes No
DANIELMITCHELL 12 on at

Like (0)

Report
Copy link

Link copied!

this is my trigger. I couldn't find something that related directly to my excel file.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DANIELMITCHELL

You need to use the output of the filter Query in CREATE HTML Table action as below and use the output from this step directly in your email

Was this reply helpful? Yes No
DANIELMITCHELL 12 on at

Like (0)

Report
Copy link

Link copied!

Ok updated the next step but it added an apply to each around the email. Which choice do I enter for output?

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@DANIELMITCHELL

You need to pass the output from the Create HTML Table directly in the email body not through an apply to each , it is all dependent on which other values you are referencing.

Was this reply helpful? Yes No
DANIELMITCHELL 12 on at

Like (0)

Report
Copy link

Link copied!

Every time I try to reference the data from excel in the body of the email it adds an apply to each step automatically. I'm trying to get the email set without adding the apply to each step. When that gets added i get sent an email for each line of the excel sheet not just the one line I'm editing What does the HTML table step do for the body of the email? What is the data in the output of the HTML table?

Was this reply helpful? Yes No