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

All responses (3)

Answers (0)

Suggested answer

ankit_singhal 84 on at

Like (0)

Report

Powerfx Function for Lookup Column

Power Fx is not supported for lookup but you can use Power automate for your logic
bscarlavai33 196 on at

Like (0)

Report

Powerfx Function for Lookup Column

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
Suggested answer

FLMike 23,258 on at

Like (2)

Report

Powerfx Function for Lookup Column

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

Quick Links

Leaderboard

WarrenBelz 140,719

RandyHayes 76,308

Pstork1 63,355

Leaderboard

Powerfx Function for Lookup Column

Helpful resources

News and Announcements

Quick Links

Welcome to the Power Platform…

Community Update Sept 16…

Welcome to the new Power Platform Community!…

more Community News

Leaderboard

Featured topics

Product updates

Powerfx Function for Lookup Column

Helpful resources

News and Announcements

Quick Links

Welcome to the Power Platform…

Community Update Sept 16…

Welcome to the new Power Platform Community!…

more Community News

Subscribe to

Leaderboard

Featured topics

Product updates