web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to collect a looku...

Power Apps

Unanswered

How to collect a lookup entity

(0) Share

Report

Report

Posted on by Kesh

230

Hi,

I have an issue with a lookup field in CDS.

A store is managed with an user. Every user is stored in CDS in the "Users" entity.

I try to use this function:

collect(Stores;{
Store_Name;"My store";
User_in_charge:lookup(Users;'full name'="Brian Singer")})

The system says that it needs a data entity and the type I try to insert is not compatible. I tried with the GUID but nothing works at all.

Can someone help me?

Kind regards

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

v-siky-msft on at

Like (0)

Report
@Kesh
I'm not sure whether it is a clerical error or something, but could you please modify the formula as follows

Collect(Stores;{Store_Name:"My store";User_in_charge:LookUp(Users;'Full Name'="Brian Singer")})

In my test, this codes can work well, could you have a try to check if the issue is fixed?
Sik

Was this reply helpful? Yes No
Kesh 230 on at

Like (0)

Report

Hi, thank you for your time, I don't understand why it does not works at all:
this is my User in charge filed in CDS:

And I tried your code (the same as my) and I have this error:

I don't understand.
Please help me

Was this reply helpful? Yes No
Verified answer

Kesh 230 on at

Like (0)

Report

Hi, I found the solution replacing collect() by update().
Thank you for your time

Was this reply helpful? Yes No

Join the conversation