I have 2 SharePoint lists:
- List A with an Asset No field/column (single line of text clmn) - a list of all bookings made, and what asset no. has been assigned to the booking.
- List B with an Asset No field/column (single line of text clmn) - a list of all bookable items, each with a unique asset no.
I have an Edit form on a PowerApp which populates from a user selection on a gallery.
I have changed an Asset No. text field (within a datacard) on the form to a drop down:
I have populated the Asset No. drop down with:
Items: Distinct(ListB, AssetNo)
This populates the list with all Asset No.'s successfully.
But it does not set the Asset No. drop down with the selected asset no. from a selection in the gallery.
I kind of understand why this is happening - the two lists are separate.
My settings:
Gallery on item selection:
Select(Parent)
In Edit Form:
DataSource: ListA
In DataCard:
Default: ListA.Selected.AssetNo
Update: ddAssetNo.SelectedText.Value
DataField: "AssetNo"
In Drop down:
Items: Distinct(ListB, AssetNo)
Default: Parent.Default
I've tried:
In Drop down:
Default: galListA.Selected.AssetNo
Default: ThisItem.AssetNo
