web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps patch SharePoint list ...

Power Apps

Unanswered

patch SharePoint list using lookup from another list

(0) Share

Report

Report

Posted on by neuronic

177

Have tired many variations of below code unsuccessfully:

ForAll(CERAMICS,Patch(myPots2,Defaults(myPots2),artist:LookUp(LKP_CERAMICS_ARTIST,ID=ARTIST_FAMILY_NAME.ID]).ARTIST_FAMILY_NAME}))

CERAMICS is a SharePoint list

myPots2 is a SharePoint list

LKP_CERAMICS_ARTIST is a SharePoint list

artist is a text field in myPots2

ARTIST_FAMILY_NAME is a field in LKP_CERAMICS_ARTIST

ARTIST_FAMILY_NAME is a lookup field in CERAMICS, lookups from ARTIST_FAMILY_NAME in LKP_CERAMICS_ARTIST

I want to populate myPots2 by patching the field ARTIST_FAMILY_NAME from CERAMICS (to field artist)

Can do it using collections but would prefer to avoid

Very frustrating. Can anyone help please?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @neuronic ,

I may be oversimplifying this, but try

Patch( myPots2, ForAll( CERAMICS, {artist: ARTIST_FAMILY_NAME.Value} ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Join the conversation