You’re offline. This is a read only version of the page.
Announcements
Hi all,
I'm making a flow that should iterate over each item (record) in a SharePoint List and make sure there is a matching record in a table in a Excel file. If there it no matching record, the item should be deleted from the SP List. There's a little quirk in that there are no unique identifiers on each record / item, but we can combine three columns to identify.
My initial thoughts are to
> do a 'List rows present in table' and a 'Get items'
> Parse JSON the output of the List rows present in table
> Apply to each the 'value' output of the 'Get items'
> 'Filter array' the output of the Parse JSON with each of the three fields that can be used to uniquely identify records
… and be left with the output of the final Filter array being an array of length 1 which should match current SP item that is being iterated, or an array of length 0, meaning there is no matching record in the Excel file.
Above is my attempt at implementing this, but the problem I'm facing is that the output of the first Filter array is empty square brackets. Any suggestion on how best to fix this or alternative means of achieving the same ends would be greatly appreciated.
Share
Report
All responses (
Answers (
501
