Hey everyone,
I'm encountering a challenge with my Power App and I could really use some assistance. Let me break it down for you:
In my edit form, I have a repeating gallery (see the attached picture for reference). The EAN_Combobox is a combo box with the following items property:
Sort(SKU_May23, EAN, SortOrder.Descending)
The data source SKU_May23 consists of the fields: EAN, SKU_ID, and Description. My goal is to set up the gallery fields "SKU ID" (LookUp_Gallery_SKU) and "Description" (LookUp_Gallery_Description) in a way that they display the corresponding SKU ID and Description when an EAN is selected from the Combobox.
Currently, I've set the following properties for the SKU field (Description is set up in the same manner):
OnChange: Patch(DataInput, ThisItem, {Collection_SKU_ID: LookUp_Gallery_SKU.Text})Default: If(EditForm_Returns.Mode = FormMode.New, EAN_Combobox.Selected.SKU_ID)
These statements successfully display the SKU IDs and descriptions to the user, but they fail to store the text values into the collection. You can see the output of the collection in the attached picture.
As for the other fields in the gallery, I've set the Default property simply like this: "ThisItem.Collection_Qty." However, I'm unsure of how to combine this with the 'lookup' that needs to be set up for the SKU and Description values.
If anyone can provide some insights or solutions, I'd greatly appreciate your help!


Report
All responses (
Answers (