Answered

Broken list after trying to automate.. What's the error?

(1) Share

Report

Posted on by tiredMonk

I was trying to use power automate to send items from one list to another "Archive list" when my column "Delete" was equal to yes.

I was going to make a test item to test the flow, however when I went to save my Item I got this error:

Invalid statement, ResultCode: 1

I tried to edit a preexisting item, but when I went to do so I was met with a blank screen:

I've exported the list as an excel file, and I'm planning on recreating the list, but I'm very confused. What was the error? Is it fixable without creating a new list?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tiredMonk ,

Maybe you could check Flow's run history to see if any 'Delete item' Actions were executed.
Based on your description, I have made a test for your reference.

1. Here are my lists.
2. Here is my flow.
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Verified answer

tiredMonk 17 on at

Like (0)

Report
Copy link

Link copied!

Hi there, thanks for your reply! I'm unsure why this will have caused an error for the other items though.

The flow ran and deleted correctly before on my test items. I don't understand why this would stop me from being able to edit the other items.
I've recreated the list and it works perfectly in its new form, so this isn't urgent or very important, I'm just curious for now.

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tiredMonk ,

Glad to see you solved the problem.
As far as I have tested, if the item currently being edited has been deleted by Flow but not refreshed in SharePoint, it will show blank. In addition, it may be a temporary problem.

You might consider marking your reply or mine as a 'solution' to close the case.

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
tiredMonk 17 on at

Like (0)

Report
Copy link

Link copied!

I've marked my reply as the solution to solve it (if anyone has a similar issue, I suppose then they can see a solution is just to recreate the list).
I'd understand that it would show blank if it had been deleted but even after a couple of days, and on items that were not marked to be deleted, they showed as blank still. Very weird!

Anyway, thank you so much for your responses.
Take care 🙂

Was this reply helpful? Yes No
MarioOne 67 on at

Like (0)

Report
Copy link

Link copied!

I can see that annouying really; I am autmating my list with extensive testing and sharepoint started failing, both my flows and the lists as well clearing out the fields after automation. I am confused with that behaviour, as it seem to work one day and then this eventually fails. Restoring and rewrking the list along with flows? Seems far from autmation indeed 😞

Was this reply helpful? Yes No