Answered

Power Automate & MS Lists

(0) Share

Report

Posted on by MR-22011544-0

I have a MS List. Each time the Status field in the list is updated to Completed, I would like two actions to be performed:

the specific item to be added as a row to an Excel File a
the item to be deleted from the List.

Any suggestions please?

Thank you in advance for the help.

Categories:

Building flows

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Power Platform 1919 2,254 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
HI @MR-22011544-0,

You can do this cleanly with one Power Automate cloud flow. The key is to (1) only run when Status becomes Completed, (2) write to an Excel table, then (3) delete the item.

Store the workbook in OneDrive for Business or SharePoint document library (not on your PC).

Power Automate can only “Add a row” into an Excel Table, not an arbitrary range.

1.

Trigger: SharePoint (your MS List) . When an item is created or modified

Then (best practice) add a Trigger condition so the flow only fires when Status is Completed.

@equals(triggerBody()?['Status']?['Value'], 'Completed')

This keeps the flow from running on every edit and wasting runs

2.

Action: Excel Online (Business) ---Add a row into a table

Map MS List columns to Excel table columns.

3.

Action: SharePoint . Delete item

Site Address: your site

List Name: your list

Id: the trigger item ID (dynamic content)

Note: Excel locking: Excel actions can fail if the workbook is open in desktop Excel Application. Keeping it in SharePoint/OneDrive and avoiding long edits helps.

1 people found this reply helpful.

Was this reply helpful? Yes No
MR-22011544-0 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, this worked very well. I also found this link very useful: https://youtu.be/HD92f_yo0G4?si=Y_dyHJ-6-E9lhutS

Was this reply helpful? Yes No