You’re offline. This is a read only version of the page.
6
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?
Hi @mariaem ,
I made a test, using classic Combo box could achieve your need:
Items: TableA
DefaultSelectedItems:
Share
Report
All responses (
Answers (
Filter(TableA, nameofThingFieldID.TableAGUID = ThisItem.GUID)
Best regards,
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
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,
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
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,
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
