Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Update Collection based on values of Selected Field

(0) ShareShare
ReportReport
Posted on by 19

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. 

Categories:
  • Verified answer
    v-jefferni Profile Picture
    v-jefferni on at
    Re: Update Collection based on values of Selected Field

    Hi @rojomoin ,

     

    Please try:

    Collect(colA, ForAll(LookUp(SPXYZ, ColumnA = txtLetterType.Selected.ColumnA).ColumnB.Value,{ColumnA: varUniqueID, ColumnB: ThisRecord.Value}))

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard