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

Answered

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)

Sort by

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@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
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation