Datacard does not show list of values in multiple value column of a many to one relationship

(0) Share

Report

Posted on by mariaem

I trying to make an powerapp for teams app.

I have two tables in dataverse:

TableA, principal table with a fieldID and

TableB, child/secondary table with nameofThingFieldID and lookupField2TableA.

There is a relationship one to many on tableA with TableB as the many side and

a many to one relation on tableB ( I know it is just the same relationship from two points of view, but anyway it is there)

I edit TableB and I put some values in some records of the TableB lookup column. It saves fine.

I create the app and generate the first screen automatically from the TableB. No issue here. Everything works. I can edit, save and so on.

To this point everything is as it shoud be.

No I generate the TableA screen. The forms shows only a DataCard for FieldID. No problem: I go to the form properties tab, click on fields and add another Datacard, that with the many2one relationship field:

It is Spanish, but it looks ok: there is a new Datacard with the right field selected and a control type of "see multiple selection of option collection" or something like that.

In fact the DataCard has a Dropdown, with and error: the Items property shows "Choices(-)" instead of a column. In play mode the control shows nothing.

I have tried with "Choices(thisItem.lookupField2TableA)". The error red sign disappears but the control stays blank.

Can somebody out there help, please?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @mariaem ,

For 1:N relationships, the LookUp columns are always in the many side. So, on your end, one tableA record may be in many different tableB records LookUp column. In the form of tableA, there is no default column/DataCard can add, using a custom card to display corresponding tableB records to current item of tableA is an option.

So, in the custom card, you can use a Combo box, Items set to:

Filter(tableB, lookupField2TableA.FieldID = ThisItem.FieldID)

Best regards,

Was this reply helpful? Yes No
mariaem 6 on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks
That makes sense.
Sadly, datacard shows nothing. I do have data on tableB that refers to TableA so I hoped it was a straight forward question, but that's not the case.
I do not know what to say

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @mariaem ,

Do you mean there is no selection in dropdown of the Combo box? Have you selected the primary field for the Control?

Best regards,

Was this reply helpful? Yes No
mariaem 6 on at

Like (0)

Report
Copy link

Link copied!

Hi
Datacard Datafield shows the name of the relationship ("cra29_relationshipTableATableb"), default shows "thisItem.TableB".
On the dropdown/combobox of the datacard, defaultselecteditems show "parent.default", displayfields y searchfields the principal field of TableB.

I put a modern combobox in the same datacard, just in case. It does not show text but it is interesting to note that it show some commas, as much as the expected values it should have:

The old control shows nothing

Thanks for the help and patience

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @mariaem ,

I made a test, using classic Combo box could achieve your need:

Items: TableA

DefaultSelectedItems:

Filter(TableA, nameofThingFieldID.TableAGUID = ThisItem.GUID)

Best regards,

Was this reply helpful? Yes No