ClearCollect Dataverse Table - LookUp field empty?

(2) Share

Report

Posted on by mrQ

482

Hey there

I hope someone could help me with the following issue. This is my setup:

Table Users

Default Users table from Dataverse, including all users in the tenant

Table Schools

Users - type: Lookup to Users (internal name: crc06_User)
Date - type: date (internal name: crc06_date)
some other fields...

If I would like to add the table Schools into a collection, the field crc06_User (which should contain the unique id of linked User) is empty. I realized this always happens with LookUp fields:

With ForAll() I could loop through each item to get the unique identifier of the User field. However, combined with a Filter on the data source, I get a "Invalid argument type" error. If I use As for the data source, the error disappears, but so does the unique identifier for the User field again... making LookUp invalid.

Anyone knows how to get around that issue?

Thank you and kind regards,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Prakash4691 1,332 on at

Like (0)

Report

Re: ClearCollect Dataverse Table - LookUp field empty?

Hi @mrQ ,
Can you try below formulas,

Step1,
Screen->on visible property: Create collect for school entity and get first record of user set to global variable. Just to filter school records based on the userid.
ClearCollect(TestSchool, Schools); Set(userid, First(Users).User)

Step2,
gallery->Items property: filter the collected school record based on the global userid created on above formula.
Filter(TestSchool, Users.User = userid)

Regards,
Prakash

Was this reply helpful? Yes No
mrQ 482 on at

Like (0)

Report

Re: ClearCollect Dataverse Table - LookUp field empty?

Hi @Prakash4691

Unfortunately, this doesn't work since the ClearCollect() won't add the unique identifier of the LookUp field "User" to the collection. Hence, I can't filter based on that field.

Kind regards,

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (0)

Report

Re: ClearCollect Dataverse Table - LookUp field empty?

Hi @mrQ ,

But the filtered records for school entity is based on user id.

Regards,
Prakash

Was this reply helpful? Yes No
mrQ 482 on at

Like (0)

Report
Re: ClearCollect Dataverse Table - LookUp field empty?

@Prakash4691

Your second formula:

Filter(TestSchool, Users.User = userid)

will not work like this, since Users.User is not part of the collection TestSchool. Users is an own entity/table. I assume what you were referring to was the following:

Filter( TestSchool, User.User = userid )

However, I can't filter by the field User in the TestSchool collection, since the User field in that collection is empty.

Kind regards,

Was this reply helpful? Yes No
Verified answer

mrQ 482 on at

Like (0)

Report

Re: ClearCollect Dataverse Table - LookUp field empty?

Hi @Prakash4691 again,

I see what you meant now. I found this blog post explaining the limitation/bug.
After your suggestion, I would need to create the collection again with ClearCollect(). Since I set the temp variable before, it will now populate the User.User value into the corresponding User field.

Thanks for the hint!

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (0)

Report

Re: ClearCollect Dataverse Table - LookUp field empty?

Hi @mrQ ,

Yes, it is a bug.
I just gave you a hint to achieve solution to your problem.
Thanks for accepting as the solution.

Regards,
Prakash

Was this reply helpful? Yes No