Show column function inside collection gives error for lookup column type

(0) Share

Report

Posted on by Matbrown

Hello ALl,

I have a table in dataverse I am trying to create a collection and show coulmns from the table inside collection later to use patch function to update the records in table

the isssue is i have a lookup type coulmn inside my dataverse table and when i use

ClearCollect(
colDeptUpdates,
ShowColumns(
Table(Defaults('Department')),
"cr_name",
"cr_duedate",
"cr_priority",
"cr_userdetails",
"cr_worktaskid"
)
);
Clear(colDeptUpdates)

I am getting error that cr_userdetails column not found and show column has invalid argument if i remove that it doesnot give error so the only difference is all other column are choice and text column but user deatils is lookup coulum, can anyone help how to get this work how to show lookup columns from dataverse inside a collection.

Thanks

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: Show column function inside collection gives error for lookup column type

Hi @Matbrown ,

You could try:

ClearCollect( colDeptUpdates, AddColumns( ShowColumns( FirstN('Department',1), "cr_name", "cr_duedate", "cr_priority", "cr_worktaskid" ), "userdetails", userdetails.XX ) ); Clear(colDeptUpdates)

Best Regards,

Bof

Was this reply helpful? Yes No