Share
Report
82I 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.
Categories:
All responses (
Answers (
