web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Update Collection base...
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:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard