Unanswered

Trigger when Excel cell changes

(0) Share

Report

Posted on by mattps

Hi Everyone,

I am new to PA and am struggling a bit tbh. I have an Excel spreadsheet in SharePoint that is modified by approx 10 people. I would like to trigger an action based on the value of a cell in a column changing, but have no idea where to start.

Can anyone send me off in the right direction?

Thanks in advance,

Matt

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @mattps,

Do you want to trigger a flow once a cell is modified in your excel table?

Could you please share a bit more about your scenario?

Actually, we have an out-of-the-box trigger as below:

Was this reply helpful? Yes No
mattps 8 on at

Like (1)

Report
Copy link

Link copied!

Thanks Qi,
I will certainly review the out-of-the-box trigger solution. To give you some context to what I am looking for. I have an Excel document in SharePoint and I would like to monitor for any inserted rows within a worksheet (and trigger an action) and monitor the value of a column cell to trigger an action when it changes from "No" to "Yes".

Is this possible?

Kind regards,
Matt

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

Workaround for "When an Excel row is created", "When an Excel row is modified", and/or "When an Excel row is deleted" triggers

This template triggers some time after users edit an Excel workbook in SharePoint & then for the target Excel table, returns a different set for records that were created, records that were modified, & records that were deleted. This way we can set up additional actions & processes for each edit users made in our target Excel table.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/When-an-Excel-row-is-created-modified-or-deleted-workaround/td-p/2264670

Was this reply helpful? Yes No