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

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (4,024)