Power Platform Community Forum Thread Details

HI,

I got the following error when running a flow that deletes rows based on a odata filter of the ID column in list rows action.

Filtering using a number on a column which contains both strings and numbers is not currently supported.

Its a very simple flow

Ive been running tests to see how many items i can delete at once due to problems with my system. I deleted 75 rows from sharepoint and they are all the same however two of the 75 failed with that error

Is there a fix to this to make it not happen

i.e can i build a QAQC type check like if the flow has any fails then try to repeat the flow for just the errors. Alert the user who deleted that the following rows have not been deleted, or even better rather than run the deletes in a batch run 10 at a time wait a minute then do it again?

As im sure the only error is the API being a tad overloaded.

Also (I reran the errors and it fixed it self..)

Categories:

General topics