Power Platform Community Forum Thread Details

Hello Power Platform Community,

I have 2 Sharepoint lists, one containing primary keys of recipe names as displayed below:

Recipe_Name:

Air Fryer Pork Chops

Baked Feta Pasta

And the other list contains the secondary key of each associated ingredient to the recipe:

Recipe_Name	Ingredient	Quantity	Measurement
Air Fryer Pork Chops	Pork	2	Whole
Air Fryer Pork Chops	Breadcrumbs	1	Cup(s)
Air Fryer Pork Chops	Eggs	2	Whole
Baked Feta Pasta	Spaghetti	1	Whole
Baked Feta Pasta	Olive Oil	2	Tbsp(s)
Baked Feta Pasta	Feta Cheese	1	Cup(s)

In my app I have a gallery with a checkbox that allows users to select the recipe name from primary key list. I am storing the checked items in a collection, then patching that collection to a third SharePoint list.

I am wondering if it is possible to create some sort of LookUp() feature in my patch statement so that if the user selects the recipe_name from the primary key list, it will patch over the secondary key of ingredients associated with that recipe name. My current patch formula is below (colUpdates is the collection of checked items from the Primary Key List Data Source in my gallery):

ClearCollect(
colDataToPatch,

ShowColumns(
colUpdates,
"Title",
"field_1",
"field_2",
"field_3",
"field_4",
"field_5",
"field_7",
"field_8",
"List_Name"

)
)
;

Patch(
'Patched Recipes DB',
colDataToPatch
);

Clear(colUpdates);

Please let me know if there is a way I can go about doing this.

Thanks in advance,

Jackson

Categories:

Building Power Apps