cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RvdHeijden
Post Partisan
Post Partisan

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

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

 

2022-01-14_13-34-33.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ekarim2020
Super User
Super User

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

Snag_66f3fdc.png

 

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.

 

 

View solution in original post

2 REPLIES 2
ekarim2020
Super User
Super User

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

Snag_66f3fdc.png

 

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.

 

 

@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 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,646)