Unanswered

Get Items ID

(0) Share

Report

Posted on by AndyatCompany

Hi!

Running into a few issues with my list flows. I have a few lists that populate a much larger SP database list. The issue I am running into is trying to figure out how to make the unique Title entries the primary ID field for my Get Items function. Is there a way to make the Title entries read as an ID number so the various lists aren't populating data on top of each other in the database? Thank you!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

bcdautomation 36 on at

Like (1)

Report
Copy link

Link copied!

I think what you would need is a calculated column for Title. Unfortunately, that seems like something that could be done by using this

=CONCATENATE([ID])

But we can't use the ID column when we want a calculated column. So there are couple ways we could approach this. If it was a new table we could create another ID column, lets call it 'ID2' that has a formula that would increment by one every time a new record is inserted, basically mimicking the existing ID column.

The second way is a bit more work but achievable, check out this article on how it's done:
https://spgeeks.devoworx.com/id-field-in-calaulated-column-sharepoint/

I'm not sure why we can't directly reference the ID column, it's a real pain, but hopefully these ideas will help you, cheers.

Was this reply helpful? Yes No
AndyatCompany 62 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Thanks for the response. I'll give that a try in a hidden column.

Was this reply helpful? Yes No