Empty fields in powerapps collection when datasource is CDS.

(0) Share

Report

Posted on by JT_Corrin

104

I've been unable to find a working workaround for this apparent bug.

I'm simply trying to create a collection from CDS entity that contains relationships. I want to be able to access the related entities via my collection.

ClearCollect( MyCollection, 'My CDS Entity')

Without fail, all the lookup values in MyCollection are blank.

I have seen some posts suggesting to use ShowColumns and AddColumns to explicity call down the related fields. This has not worked for me:

ClearCollect(
    LoadedScoreCard,
    ShowColumns(
        AddColumns(
            ThisItem.'Customer Rating Informations',
            "New Risk Group", 'Risk Group'.Name, // Lookup
            "New Measure ID", Measure.Name, // Lookup
            "New Measure Text", 'Measure (text)',
            "New Score", Score,
            "New Measure Option Selected", 'Measure Option Selected (text)',
            "New Measure Option", 'Measure Option Selected'.'Measure Option' // Lookup
        ),
        "New Risk Group",
        "New Measure ID",
        "New Measure Text",
        "New Score",
        "New Measure Option Selected",
        "New Measure Option",
        "Customer RI"
    )
);

What is the situation here? Have I missed something or is this an outstanding bug?

Thanks

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It looks like you are making things more complicated than they need to be. Are you familiar with how PowerApps handles relationships and visualize them in Galleries and Datatables? While you may want to create collections, it will complicate things by an order of magnitude. First see if you really need to do that. Check out this post to see if you can accomplish what you want by following the logic. https://powerapps.microsoft.com/en-us/blog/one-to-many-relationships-for-canvas-apps/ . I would also suggest that you play with the Northwind database example that you can download here. It really helped me understand how relationships are managed in PowerApps. https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/northwind-install

Hi @JT_Corrin

Was this reply helpful? Yes No
JT_Corrin 104 on at

Like (1)

Report
Copy link

Link copied!

Hi @Drrickryp

Thanks for taking some time to respond.

Your answer nor the article really relate to my issue. Specifically, when collecting a datasource/entity into a collection, the resulting collection omits the lookup values contained within the datasource/entity. They are simply blank.

I've done more reading around on this and it seems it been an issue for a while. This post helped:

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Help-with-LookUp-Columns-CDS-Entities-returning-null-data-for/td-p/181647

Ultimately, I have had to add an invisible gallery with an "items" value of my collection and labels that reference each of my lookup values to "trick" PowerApps into bringing those values down into the app.

If this is by design then I can only assume that the designers had spent the night before huffing glue - absolutely bat **bleep** crazy.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @JT_Corrin

Wow, I had no idea. Thanks for the reference. This needs to be fixed.

Was this reply helpful? Yes No
JT_Corrin 104 on at

Like (0)

Report
Copy link

Link copied!

Just wanted to update that my workaround of creating a gallery that references the missing lookup items (in order to force PowerApps to bring that data down from CDS), is not consistent as a solution.

Still looking for an acceptable solution before I will go to support.

Was this reply helpful? Yes No
Charbel_kh 50 on at

Like (0)

Report
Copy link

Link copied!

Hi JT_Corrin,
I've been facing the same problem.
Were you able to find a solution to that?

Was this reply helpful? Yes No
lex02 4 on at

Like (0)

Report
Copy link

Link copied!

Four years later, I'm facing the exact same issue.
Does anyone know if this is a bug?

Was this reply helpful? Yes No
JT_Corrin 104 on at

Like (0)

Report
Copy link

Link copied!

Hi lex02,

Yeah this issue is a pain. Its been a while since I looked at it but I seem to remember reminding myself that I should always use the "ShowColumns" function to get around this issue:

AddColumns, DropColumns, RenameColumns, and ShowColumns functions - Power Platform | Microsoft Learn

It works for me

Was this reply helpful? Yes No
JT_Corrin 104 on at

Like (0)

Report
Copy link

Link copied!

Although reading my original post it seems showcolumns did not work for me back in 2020 - i think it has worked for me in the following years

Was this reply helpful? Yes No