Move Sharepoint List Items to Archive list failing after 100 entries or if condition fails

(0) Share

Report

Posted on by crdawson

I have a flow set up to check a list of desk bookings for any bookings older than 6 months and create a new entry in an archive list then delete the original, but for some reason it always shows as failed every time I run it. The strange thing is it will still succesfully move up to 100 entries before it shows as "fail" and if there are no entries older than 6 months it will also show as "fail".

The condition seems to be the problem based on the error but I can't figure out what's wrong since it works on the first 100 entries. The formula I'm using is:

formatDateTime(adddays(item()?['BookedDate'], 180), 'yyyyMMdd')

The only thing I can think is that the column for the booking dates has a space so is 'Booked Date', but if I put in the space or _x0020_ the flow fails without moving anything.

I'm pretty new to PA so apologies if I've missed something obviou and thanks in advance for any advice.

I have the same question (0)