Build a form wiith columns from 2 differents tables dataverses

[ALANAH22]

Hello Everyone, 

I'm having  an issue , I have two table that are related  as

hierarchies table which contains [Hierarchy code, Hierarchy_ Name ]

and hierarchies levels TABLE [Sequence, description , hierarchy Code(the foreign key )¨]

Now I'm building a form that should contain (Sequence, description , and hierarchy Name ) I don't know how can I do it from 2tables , I 've made already the sequence , description in my from , but I don't know how can I get the Hierarchy_ Name that came from the other table in my form 

Please any help ?

[RandyHayes]

@ALANAH22 

In your case you will not be trying to put two tables together in one form as a datasource (as you cannot do that), but instead, you will be looking up the Hierarchy Code from the Hierarchies table. 

How would you go about that - as a dropdown, combobox (for search) or some other means?

[ALANAH22]

can you please explain more an alternative way to do this 

[RandyHayes · Accepted solution]

@ALANAH22 

Not sure what you mean by an alternative way.  The description I provided is what needs to be done.

What is remaining for you to determine is how you will have the user select the Hierarchy_Name in order to derive the code to be used in your form.

If you would use a Dropdown for example, you would set the Items of the dropdown to 'Hierarchies Table'  (or whatever its name is) and then display the Hierarchy_Name in the selection list.

Then the Update property of your form for the Hierarchy Code, you would just set it to theDropdown.Selected.'Hierarchy code'

[ALANAH22]

Yes exactly , im using the hierarchy name as a dropdown list , now should i add the hierarchycode im my form , and then updated with the function that you have provide ?

[RandyHayes · Accepted solution]

@ALANAH22 

Yes, you will NEED the Hierarchy code field in your form.  Then unlock that card.  Add a dropdown.  Set the Items as mentioned.  Then change the Update property on the card as mentioned.

If you need to edit prior records (not just creating new ones), then you will need to set the Default property of the Dropdown to:

   LookUp('Hierarchy table', 'Hierarchy Code'=Parent.Default, Hierarchy_ Name)

[ALANAH22]

im getting an error: valeur table attendue , how can i deal with it 

[RandyHayes]

@ALANAH22 

Your formula is not correct!  That is the Items property you are showing.  It should have a formula of: 

'Hierarchies Table'  (or whatever its name is) 

[ALANAH22]

Maybe i didn't understand your idea , you told me to put this formula im my dropdown :Dropdown.Selected.'Hierarchy code'  , where should i put it then ?

[ALANAH22]

excuse me i'm a new developer in power apps , so i don't really know how to deal with all this properties, can you just show me where shloud i put these formulas ?