web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collection showing fie...

Power Apps

Answered

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

(1) Share

Report

Report

Posted on by RM-30040732-0

545

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 Img

All responses (2)

Answers Img

Answers (1)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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 545 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Join the conversation