You’re offline. This is a read only version of the page.
Announcements
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:
Share
ReportAddColumns('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
hey @LoopinG2023
you can try this:
All responses (
Answers (
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
