Powerfx Function for Lookup Column

(2) Share

Report

Posted on by CU09090954-0

Hi,

I am creating a column (Location) that needs to come from several columns. I will not expound the details because the logic is complex.

But the columns that the data will come from is from a foreign key column(lookup datatyp ). I don't understand why I can't extract the value of the column. See below error.

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi

Its simple, lookup types aren't supported :-(

Work with Dataverse formula columns - Power Apps | Microsoft Learn

Does this work

However for Kicks, if you type 'Foster Claimer'.PickSomeFIeld

Was this reply helpful? Yes No
bscarlavai33 752 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yeah sadly Lookups are not supported, see here - https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste#data-typeshttps://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste#data-types

Was this reply helpful? Yes No
Suggested answer

ankit_singhal 618 Moderator on at

Like (0)

Report
Copy link

Link copied!

Power Fx is not supported for lookup but you can use Power automate for your logic

Was this reply helpful? Yes No

Join the conversation

Community site session details

Powerfx Function for Lookup Column

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates

Community site session details

Powerfx Function for Lookup Column

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Apps

Featured topics

Product updates