Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Collection showing fields as ID's not names and cannot use in a formula

(1) ShareShare
ReportReport
Posted on by 446
I wonder if someone can help me with a collection I'm using.  i have a button with ClearCollect that brings data from a SharePoint list for one specific row item - all good, it's pulling into the collection the data I want.
 
However, the collection is showing the fields like this - these all have names in the list - is this normal? 
 
I cannot seem to then use the fields to populate other inputs further along my app - see below. I want the field to default to the corresponding entry in the collection.  My varID is showing the right ID but nothing is populated in the field?
  • Verified answer
    RM-30040732-0 Profile Picture
    446 on at
    Collection showing fields as ID's not names and cannot use in a formula
    Thanks,
     
    I did not expect you to rewrite my code for me! My code previously worked great until I added a new If statement and then discovered what the collection looks like and what I was asking was why the collection shows my column names as field_7 etc. - is it normal etc - and was that a reason for my formula failing.
     
    No matter though, I worked out the issue myself, the brackets were in the wrong place and the column name works despite what the collection shows them as.
  • Michael E. Gernaey Profile Picture
    40,887 Super User 2025 Season 1 on at
    Collection showing fields as ID's not names and cannot use in a formula
    Hi 
     
    So lets separate what you think is happening versus what is.
     
    1) the images are great, but please add the code you want updated/fixed to be a Code Snippet. Not cool to expect us to write it all again for you :-) 
     
    2) In your code, I am confused as to what you are trying to do
    in the first If, you are returning a Record (not a value)
    in the second if, I don't even know what that is doing, but
     
    If you want to return a value don't do a Lookup and return the record
    Do a lookup and return the value
     
    LookUp(myDataSet, MyValue = SomeValue).MyFieldValue
    
    You are doing
    LookUp(myDataSet, MyValue = SomeValue) 
    which return a record.
    
    And the second one.. not idea.
    
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,618 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,962 Most Valuable Professional

Leaderboard