Preselection a Dropdown Item from LookupGallery.Selected Item

(0) Share

Report

Posted on by Jessetechno

I have 2 tables:

Accounting-POs
Accounting-POs-Items

The "Items" are each related to a PO by way of a field called "RelatedPO" which is a lookup for "Accounting-POs". In a form to add an Item to a PO (that has been selected from a gallery) The "RelatedPO" dropdown where you select the current PO from the list need to be populated with the PO selected from the gallery originally. I have tried everything and this below is the only code for the "Default" field that doesn't show any errors but also doesn't populate the field.

LookUp(Choices([@'Accounting-POs-Items'].RelatedPO),Value=POGallery.Selected.'P.O.')

What can I do to get the Master PO Item from the gallery to be selected automatically in that field...

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Jessetechno 30 on at

Like
a
(0)

Report
Copy link

Link copied!
I tried it and while its not throwing any errors after some work, it still isn't populating the dropdown. The RelatedPO in the Items list is showing the "P.O." columb from POs.

Accounting-POs ("P.O." field)
Accounting-POs-Items (RelatedPO = "P.O.")
But it isnt populating. And according to the monitor there is no lookup happening when I open a New Item form.

Was this reply helpful? Yes No
Jessetechno 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Sadly its a no-go. I guess i'll have to think of something else. Or Patch the whole form (so much work).

Was this reply helpful? Yes No
Verified answer

Jessetechno 30 on at

Like
a
(0)

Report
Copy link

Link copied!
I feel stupid right now... but I figured it out. You dont put it in the Default property... you put it in the DefaultSelectedItems property!

Mudassar, your code was altered and worked perfectly:
If(POItemsItemAddEdit.Mode=FormMode.New,LookUp( Choices('Accounting-POs-Items'.RelatedPO), Value = LookUp( 'Accounting-POs', ID = POGallery.Selected.ID ).'P.O.' ),Parent.Default)

Was this reply helpful? Yes No