Copying columnvalue "Id" to another column in a sharepoint list through FLOW

[RvdHeijden]

Ive got an issue with a SP list I'm using because there is an id generated automatically per row and I'm unable to use smart filters on that column to specifically search an Id, there are 3000 (and counting) Id's in the list and I have to scroll a lot.

Someone suggested to create a calculated column that copies the data from the Id column to a new column but that returns a technical error. So another one suggested to use Flow for this action.

I've tried building a flow but I'm to new at this so I need some help.

Basically I set the trigger on every time a new list item is created in my Sharepoint list and i need to value in the Id column to be copied to the new Colum GBO.ID

But I'm doing something wrong because it returns an error that there might be an endless loop in this flow

[ekarim2020 · Accepted solution]

This will copy the SharePoint List item ID to the ID.GBO field:

However, can you please explain further what the issue is with using the SharePoint List Item in a filter. I didn't understand. Perhaps you can share the filter you are trying to create. If you can get that filter to work, you may not need to use the ID.GBO field?

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

[RvdHeijden]

@ekarim2020 I wanted to copy the items in the ID column so I could filter on it but now I understand that you can't filter on number columns just on Textcolumns.

I've decided to build an app to avoid that issue