cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RvdHeijden
Helper III
Helper III

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
Community Champion
Community Champion

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
Community Champion
Community Champion

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

@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
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,568)