web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Add new column to tabl...

Power Apps

Unanswered

Add new column to table A from Table B

(0) Share

Report

Report

Posted on by LoopinG2023

59

Hey, it has been a while that i haven't used Powerapps, so very RUSTY. I need to add a column from table A to Table B with a condition.

here is what i tried:

AddColumns('PERSONEL PROPOSED', 'newcol', LookUp(CFT, CFT = 'PERSONEL PROPOSED'[@'CFT_ID: CFT']),ID)

Table B = 'PERSON PROPOSED'

Table A = CFT

i need to add the column in correctly, where CFT from table a is equal to 'CFT_ID: CFT' as table B as a lookup column of table A but problem of delegation.

Thanks helpers

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey @LoopinG2023

you can try this:

AddColumns( 'PERSONEL PROPOSED', "newcol", LookUp( CFT, CFT.ID = 'PERSONEL PROPOSED'[@'CFT_ID: CFT'], ID ) )

or this witha collection:

ClearCollect( ColCFT, CFT ); AddColumns( 'PERSONEL PROPOSED', "newcol", LookUp( ColCFT, ID = 'PERSONEL PROPOSED'[@'CFT_ID: CFT'], ID ) );

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No

Join the conversation