Answered

Dataverse Lookup Column - usage with Sort - Column does not exist or is an invalid column type

(0) Share

Report

Posted on by MichalBr89

Hi,

I am setting Lookup column name into variable, however it seems that Power Apps doesn't recognize it - I am not sure if I should write the column name differently or I am just not allowed to use Lookup column in variables.. I am then leveraging the variable in Sort function.

Variable:

The name of the column as it is in Dataverse table:

The error I receive:

Thanks a lot for your help!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-xiaochen-msft on at

Like (1)

Report

Hi @MichalBr89 ,

Please try the addcolumns function.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (1)

Report

Hi @MichalBr89

try using AddColumns

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
MichalBr89 61 on at

Like (0)

Report

Thanks a lot @rampprakash & @v-xiaochen-msft , AddColumns solved it for me!

Was this reply helpful? Yes No