This is puzzling me and have worked for many days on this :
I am looking to update/create an existing collection (colA) in Power Apps that, upon the user selecting an option from the dropdown named 'txtLetterType,' where the txtLetterType values come from from SharePoint List XZY column A.' The collection should store the data of SharePoint List XYZ column B (Column B is a lookup Column with multiple choice) of the txtLetterType selected record.
The collection will have 2 columns, Column A a unique ID such as varUniqueID
Set(
varUniqueID,
"MM" & Text(
Now(),
"yymmdd"
) & Text(
Now(),
"hhmmss"
)
);
and ColumnB would have the SharePoint List XYZ column B.
for Example:
User selects an option from txtLetterType,
SampleSelection
SampleSelection record in SharePoint list contains a lookup Value on ColumnB (1,2,7)
Collection will have
colA
ID SharePointColumnB (Lookup SharePoint Column multiple values)
1234 1
1234 2
1234 7
Any help would be appreciated.
Hi @rojomoin ,
Please try:
Collect(colA, ForAll(LookUp(SPXYZ, ColumnA = txtLetterType.Selected.ColumnA).ColumnB.Value,{ColumnA: varUniqueID, ColumnB: ThisRecord.Value}))
Best regards,