Unanswered

Is there an automatic trigger to run a flow when a specific cell in Excel reaches a certain value?

(0) Share

Report

Posted on by SAIFON

Hi Power Automate Community,

I am currently working with an Excel file stored in SharePoint and I need to trigger a flow only when a specific cell in the Excel file reaches a certain value.

So far, I've been using the "When a file is modified (properties only)" trigger, but this triggers the flow every time the file is modified, which is not efficient for my use case.

Is there an automatic trigger in Power Automate that allows the flow to be triggered only when a specific cell in an Excel file reaches a particular value, without triggering every time the file is modified? If not, what would be the best approach to achieve this?

Thanks in advance for your help!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

RogerCP66 105 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SAIFON I don't believe there is a specific trigger that would enable this functionality. That said does this table have to be in excel?

Was this reply helpful? Yes No
Anil_g 668 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@SAIFON

There is no trigger on value or cell..but you have a trigger that can be set on specific row...you can use that to trigger only for that row modification..Also with trigger condition we try to setup condition to check if the value threshold is reached or not as the return values contain the row details as well

https://learn.microsoft.com/en-US/connectors/excelonlinebusiness/#for-a-selected-row

cheers

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SAIFON

well there is no such trigger which trigger when excel file cell value reaches a value. But as you said > using when file is modified trigger can help to do but in different approach >

see below

Assume i want to check until the first row column value (highlighted ) should reach value 10.

For that try this flow design:-

1. Use trigger when the file is modified

In the trigger under trigger settings use the trigger condition to trigger the flow only when this excel file modified

Expression - @equals(triggerOutputs()?['body/{FilenameWithExtension}'],'Export Data.xlsx')

replace the Export Data.xlsx with the file name of yours.

Now coming back to flow - use get tables to get list of all tables present in sheet/workbook

Here for demo purposes- i will take the first table where the data for checking value resides

Next use list rows in table to list rows

Expression -

first(outputs('Get_tables')?['body/value'])?['id']

Now use the condition to check whether the first row > ABC column value equal to 10 using this expression in condition action

Expression -

outputs('List_rows_present_in_a_table')?['body/value']?[0]?['ABC']

(change the condition accordingly as per your requirement )

Now based on condition > you can do yes /no sections accordingly in the flow.

There is another way as well to check excel value reaching threshold> by using scheduled flow which runs in specific interval of time and check the value as well.

Hope it helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No