cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dronzer10
Frequent Visitor

Delete item from excel if the list item is deleted from sharepoint

Hello,

 

I have a SharePoint list and an Excel stored in the Documents folder. I have Power automate which updates the excel items when an item in SharePoint list is Created or Modified. But unfortunately If i delete items in SharePoint the excel items still remains. Can you please suggest how can I achieve this?

 

Many Thanks,

Nilanjan

1 ACCEPTED SOLUTION

Accepted Solutions
Dronzer10
Frequent Visitor

Hello guys,

 

I have found the solution to this issue. With trigger when item is created or modified this action is difficult. So I constructed a new flow with When item is deleted trigger. 

Here is the screenshot.

1.JPG2.JPG3.JPG

In filter array enter: string(triggerOutputs()?['body/ID'])

In condition: empty(body('Filter_array'))

 

Important point: Please remove the filters of the excel when is being synced with SharePoint list. If any filter is there the flow will fail. 

 

Regards,

Nilanjan

View solution in original post

1 REPLY 1
Dronzer10
Frequent Visitor

Hello guys,

 

I have found the solution to this issue. With trigger when item is created or modified this action is difficult. So I constructed a new flow with When item is deleted trigger. 

Here is the screenshot.

1.JPG2.JPG3.JPG

In filter array enter: string(triggerOutputs()?['body/ID'])

In condition: empty(body('Filter_array'))

 

Important point: Please remove the filters of the excel when is being synced with SharePoint list. If any filter is there the flow will fail. 

 

Regards,

Nilanjan

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,049)