I was working off another post asking the same info but when I follow how they created the flow for the solution it always triggers as True and doesn't delete the row. If I try and modify the flow it then wants to add an apply all and tried to delete the entire list.
The same rows/columns are in the excel sheet and the SharePoint list. But the unique trigger to each row would be 'Question'.
There's the original post I found, any help would be greatly appreciated.
I think your problem is in the Filter Array action. You changed the ID to Question, but the right side of the filter is still a String() function, which shouldn't be necessary since Question would already be a string. Did you change the right side of the filter to point to the Question column? If not you'll always end up with an empty array.
I didn't have the option for "Item ID", I tried the other 3 options (value, body, body/value - item) that weren't the names for the rows of the table but each of them did the same thing.
In filter array enter: string(triggerOutputs()?['body/ID'])
In condition: empty(body('Filter_array'))
Tried using those as well from the original solution and still the same result either deleted all rows, or did nothing.
You have to filter the array by using some value that is both in Excel and SharePoint. Otherwise you aren't matching the row. Since you are trying to delete a matching row, what value is in both data sets. That is what you want to filter on.
Sorry I am not sure I follow, would you be able to show an example? I thought I tried setting it up based on a unique value for each document "Question"
You may be able to filter on Question. But if you are filtering using Question then what is on the right side of the equals? All I can see in the Screenshot is String(). Since Question is already a String you wouldn't need that formula. It would be something different. So I suspect you are trying to compare question to an ID row, which is what the blog had in the right side. So what is inside your string() function?
First, the question should already be a string so you don't need the String function. triggerOutputs()?['item/Question'] should be enough. To troubleshoot use a couple of compose actions just before the filter array to check the values being used on the right and the left side of the filter. The delete trigger doesn't return all the data of the item that was deleted, so question may not be available in the triggerOutputs.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!