web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Add column to collecti...

Power Apps

Answered

Add column to collection from SQL data source

(0) Share

Report

Report

Posted on by Shalom47

51

Hi,

I have a collection called ColData as below:

CompanyName

Apple

Sony

Google

I have a sql table CompanyData as below:

Id	CompanyName	CompanyLocation
1	Apple	California
2	Sony	Tokyo
3	Google	San Fransico
4	Samsung	Seol

I want to add "Id" column from SQL table to my collection ColData so that my ColData will look like below:

Id	CompanyName
1	Apple
2	Sony
3	Google

I have tried AddColumns(ColData,"Id",Filter(CompanyData,CompanyName=ColData.CompanyName)); but it is not working Could anyone pls help

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,404 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Shalom47 ,

Having the two columns the same name does not help, but try this

AddColumns( ColData As aCol, "Id", LookUp( CompanyData, CompanyName = aCol.CompanyName ).Id )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation