Add new column to table A from Table B

(0) Share

Report

Posted on by LoopinG2023

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:

General Questions

All responses (1)

Answers (0)

mmbr1606 12,104 Super User 2025 Season 1 on at

Like (0)

Report
Re: Add new column to table A from Table B

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