Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / How to collect a looku...
Power Apps - Microsoft Dataverse
Answered

How to collect a lookup entity

(0) ShareShare
ReportReport
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

  • Verified answer
    Kesh Profile Picture
    Kesh 230 on at
    Re: How to collect a lookup entity

    Hi, I found the solution replacing collect() by update().

    Thank you for your time

  • Kesh Profile Picture
    Kesh 230 on at
    Re: How to collect a lookup entity

    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:

    image.png

     

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

     

    image.png

    I don't understand.

    Please help me

  • v-siky-msft Profile Picture
    v-siky-msft on at
    Re: How to collect a lookup entity

    @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?

    Snipaste_2020-02-13_14-04-24.png

    Sik

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans