Extract ID field from Collection

[luvagoldenk9]

Thinking this should be easy but perhaps I'm overthinking it.

I am loading one Share Point list record into a collection based on the user's email. I need to extract the collection ID field into a variable. I tried Set(SelectedID,colName.ID) but SelectedID returns a table and I just need the ID value.

I need to reference the ID value later in the app for Patching.

Thoughts??

[mdevaney · Accepted solution]

@luvagoldenk9 
Yes, try a LOOKUP function like this.

Set(SelectedID, LookUp(colName, EmailColumnName=User().Email, ID)) 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Prakash4691]

Hi @luvagoldenk9 ,

Try below reference link, which has already been answered to the same question in the community.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Collect-specific-columns-in-a-SP-List-in-a-C...

Regards,

Prakash