Unanswered

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

(1) Share

Report

Posted on by RM-30040732-0

518

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
Verified answer

RM-30040732-0 518 on at

Like (0)

Report

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.

Was this reply helpful? Yes No