Answered

Lookup column value not showing correctly in collection (FullName.Value showing error)

(1) Share

Report

Posted on by oyepanky

537

Hi everyone,
I’m trying to collect records from my SharePoint list PREDBSRecords into a collection called colAllRecords, but my lookup column (FullName) isn’t displaying its text value properly.
Here’s my formula:


// PRE DBS (FullName is a lookup)
Collect(
    colAllRecords,
    AddColumns(
        ShowColumns(
            Filter(
                PREDBSRecords,
                Created >= Today() && Created < DateAdd(Today(), 1)
            ),
             FullName,OfficeLocation
        ),
        'Name', FullName.Value,
        'Staff', "PRE DBS",
        'Persent', false
    )
);


PowerApps shows an error under 'FullName.Value'.



I want to extract and display the actual text value from the lookup column instead of the record.
Could someone please help me fix this formula?
Thanks in advance! 🙏
Best Regards,

Pankaj Jangid (OyePanky)

Power Platform Developer

YouTube: @Oyepanky

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hey @oyepanky,

Those are the everlasting issues with special columns from SharePoiny. it sometimes feels like the Power Platform just hates them.

But no worries, we’ll get this figured out together.

Here’s what I like to do in those cases: go at it step by step.

This is your current code:

Collect( colAllRecords, AddColumns( ShowColumns( Filter( PREDBSRecords, Created >= Today() && Created < DateAdd(Today(), 1) ), FullName,OfficeLocation ), 'Name', FullName.Value, 'Staff', "PRE DBS", 'Persent', false ) );

Let’s start with this small adjustment:

Collect( colAllRecords, AddColumns( ShowColumns( Filter( PREDBSRecords, Created >= Today() && Created < DateAdd(Today(), 1) ), FullName,OfficeLocation )/*, 'Name', FullName.Value*/, 'Staff', "PRE DBS", 'Persent', false ) );

Since the error seems to come from the AddColumns part FullName.Value mapping first and see what your collection returns.

You might get something like this:

You’ll probably notice a nested column.

When you select it in the data viewer, you’ll see the actual values (SharePoint lookups usually return an ID and Title record).
If you see the lookup column and the expected value is there, we can move forward with a few targeted tests.

Could you share the exact error message you’re getting? That’ll help confirm whether it’s a lookup-type issue or something else.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
Suggested answer

Youssef_Arouay 200 on at

Like
a
(1)

Report
Copy link

Link copied!

A Lookup column (like FullName) stores a record, not plain text. It has subfields such as .Id and .Value

Try this code instead :

Don’t use ShowColumns() before AddColumns() — apply it after you’ve expanded the lookup :

Collect(
colAllRecords,
ShowColumns(
AddColumns(
Filter(
PREDBSRecords,
Created >= Today() && Created < DateAdd(Today(), 1)
),
"Name", FullName.Value,
"Staff", "PRE DBS",
"Persent", false
),
"Name",
"OfficeLocation",
"Staff",
"Persent"
)
);

Was this reply helpful? Yes No