Unanswered

Updated Excel File in Sharepoint - Email Only The Updated Row

(0) Share

Report

Posted on by AquaExtensions

I started creating my flow based on the information in this post. Now, I'm trying to figure out a way to send only the row updated in the Excel file in the email notification. Any assistance would be much appreciated.

Screen Shot 2019-11-07 at 5.03.00 PM.png Screen Shot 2019-11-07 at 5.04.56 PM.png

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

v-alzhan-msft on at

Like (0)

Report

Re: Updated Excel File in Sharepoint - Email Only The Updated Row

Hi @AquaExtensions ,

Does the Condition in your flow could check if the excel row is updated?

If yes, you could change your Condition to a Filter Array and the flow should as screenshot below:

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
AquaExtensions 12 on at

Like (0)

Report

Re: Updated Excel File in Sharepoint - Email Only The Updated Row

@v-alzhan-msft Thank you for your input. I just need to add those two new actions inside the IF YES section of Condition 2?

Was this reply helpful? Yes No
AquaExtensions 12 on at

Like (0)

Report

Re: Updated Excel File in Sharepoint - Email Only The Updated Row

@v-alzhan-msft I've made the changes. Should the flow look like the following?
CONDITION: IF YESCONTINUES FLOW AFTER IF YES

Was this reply helpful? Yes No
AquaExtensions 12 on at

Like (0)

Report

Re: Updated Excel File in Sharepoint - Email Only The Updated Row

@v-alzhan-msft I made a change to the column I selected in the Filter Array action, but it still sent me all of the rows that have the Out of Stock or Low Inventory.

Was this reply helpful? Yes No
AquaExtensions 12 on at

Like (0)

Report

Re: Updated Excel File in Sharepoint - Email Only The Updated Row

@v-alzhan-msft Is there any way that you can assist me with the necessary changes in making this flow work properly? Thank you.

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Re: Updated Excel File in Sharepoint - Email Only The Updated Row

Hi @AquaExtensions ,

Please delete the actions under the condition.

And you could add a "Send an email" action under the "Create HTML table2" inside the Condition.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
AquaExtensions 12 on at

Like (0)

Report

Re: Updated Excel File in Sharepoint - Email Only The Updated Row

@v-alzhan-msft Thank you. The one thing I don't understand is how the Filter Array action can have 'updated' in it? How does that actually know that the row was updated? Here's the latest version. Should this work?

Was this reply helpful? Yes No
AquaExtensions 12 on at

Like (0)

Report

Re: Updated Excel File in Sharepoint - Email Only The Updated Row

@v-alzhan-msft I just tested the flow, and the email it sent was blank. Does the row in question need to have the word updated in it? If so, that's not what I'm trying to achieve. (If that's the only way for this to work, then I would need to add another column for my team to add the term that triggers the email.)

Was this reply helpful? Yes No