PowerFX - "Collection was of a fixed size" error

(0) Share

Report

Posted on by NaivePowerApper Microsoft Employee

I have a Text field on my Power Pages site that I'm attempting to populate using PowerFX.

This works:

=LookUp(Contacts,Contact=User.DataverseUserId).'First Name'
 
However, what I actually want to do is something like this:
 
=LookUp(Contacts,Contact=User.DataverseUserId).'Custom Attribute Record'.'Custom Attribute Name'
 
When I do this, the output I get is: "Collection was of a fixed size"
 
How can this be resolved?

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report

pls try the following:

The error "Collection was of a fixed size" occurs because you're trying to directly access a nested complex relationship in the Dataverse without appropriately handling the reference

If Custom Attribute Record is a lookup column on the Contacts table that references another table where Custom Attribute Name resides, use: LookUp(Contacts, Contact = User.DataverseUserId).'Custom Attribute Record'.'Custom Attribute Name'

Was this reply helpful? Yes No