Dataverse Created By Value in Clear Collect

(1) Share

Report

Posted on by ctedesco3307

938

ClearCollect(colpogress,ShowColumns(DataverseTable,Name,Notes,'Created By'.'Full Name' ,'Created On'))
 
'Created By'.'Full Name' is throwing an error - how do I get the 'Full Name'  
 
Name isn't valid. 'Created By' isn't recognized

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ctedesco3307,

ShowColumns can't drill into a related record's field (like 'Created By'.'Full Name') as part of its column list. Use AddColumns instead to create the flattened column first, then select with ShowColumns:

ClearCollect(
colpogress,
ShowColumns(
AddColumns(
DataverseTable,
CreatedByName,
'Created By'.'Full Name'
),
Name,
Notes,
CreatedByName,
'Created On'
)
)

AddColumns creates a new column called CreatedByName that pulls the Full Name from the Created By lookup. Then ShowColumns can include it alongside your other flat columns.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @ctedesco3307,

In Dataverse, you can’t directly use 'Created By'.'Full Name' inside ShowColumns(). Instead, use AddColumns() to pull the value first, then reference it in ShowColumns.

For example, add a column like CreatedByName: 'Created By'.'Full Name' and then use it in your collection.

So for example your collection code will be like this:

ClearCollect( colpogress, ShowColumns( AddColumns( Courses, CreatedByName, //Specify the name of the new column you want to create or expand 'Created By'.'Full Name' ), Name, Notes, CreatedByName, 'Created On' ) )

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No