Unanswered

When a sharepoint list is modified (completed) update an excel file

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

Hoping someone could help. I have a list on our sharepoint we use for "reporting findings" there are a number of columns we as a team update throughout the project. Once we are finished, and change the "status" to closed, can this trigger a flow to update a line in excel?

we use mail merge to send our clients information so updating a row in an excel works perfectly.

I see you can export a list from sharepoint, I'm just looking to automate the process.

I see a lot of excel updating a list, which i understand but i cant seem to find a list that updates an excel.

Any help would be much appreciated. Thank you all in advance.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi Adomo,

You can use the 'When an item is created or modified' trigger in powerautomate and then from the elipses (three ...) select settings and apply a trigger condition. This will ensure that your Flow/Automate will only run when these conditions are met. In your example try @equals(triggerBody()?['Status'],"Closed").

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

Hi,

That worked! i think i was trying to over complicate things.

thank you so much for your help.

Adomo

Was this reply helpful? Yes No