cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Djack
Frequent Visitor

Patch Lookup field from Collection

Hellow All,

 

I want to patch a field in a sharepoint list, the ID of that field is a member of a Collection

 

ForAll(ProdcutenRemoved,
Patch(BEWONERS_PRODUCTEN, LookUp(BEWONERS_PRODUCTEN, ID=ID), {Tot:DatePicker1_2.SelectedDate}))

The ID field is in the Collection and also in the BEWONERS_PRODUCTEN.

 

I'm lost in the forrest and cant seem to find the way out 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Patch Lookup field from Collection

Hi @Djack 

One approach you can take is to rename your source ID column.

Here's how you would do this by renaming your collection's ID column to ID1.

ForAll(RenameColumns(ProdcutenRemoved,"ID","ID1"),
       Patch(BEWONERS_PRODUCTEN, 
             LookUp(BEWONERS_PRODUCTEN, ID1=ID),
              {Tot:DatePicker1_2.SelectedDate}
        )
)

 

View solution in original post

1 REPLY 1
Super User
Super User

Re: Patch Lookup field from Collection

Hi @Djack 

One approach you can take is to rename your source ID column.

Here's how you would do this by renaming your collection's ID column to ID1.

ForAll(RenameColumns(ProdcutenRemoved,"ID","ID1"),
       Patch(BEWONERS_PRODUCTEN, 
             LookUp(BEWONERS_PRODUCTEN, ID1=ID),
              {Tot:DatePicker1_2.SelectedDate}
        )
)

 

View solution in original post

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (8,553)