Unanswered

Add second column to collection based on values from the first column

(0) Share

Report

Posted on by pipkinpaula

I have a list that filters names from a tableA (excel data) based on a selection made on a dropdown that has peoples state in it,

when I select items from the list (multiple selection) I have:

ClearCollect(CollectionA ,namelist.SelectedItems) but I would like to have a second column added to the Collection A. A column with peoples ID, this data is present on TableA (excel file).

So as I select names on namelist, I would like my collection to populate both, name and ID.

my file has the headers : ID/City/Name/Phone

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

AmeerJab 370 on at

Like (1)

Report

Hello Dear,

to add new columns to your collection you can follow the below syntax

clearcollect(NewColeection, addcolumns(original collection, "New column name", and here you add the condition and expression for your new column)

Was this reply helpful? Yes No
pipkinpaula 37 on at

Like (0)

Report

can you help with the condition? I tried that before but it says that I'm comparing a record to a table, here is what I tried:

ClearCollect(Collection,namelist.SelectedItems);
ClearCollect(NewCollection, AddColumns(Collection,"ID",LookUp(Collection, TableA[@Name] = Collection[@Value],TableA[@ID]))).

It does not work, is says I'm comparing table to text inside the lookup part)

Was this reply helpful? Yes No
AmeerJab 370 on at

Like (1)

Report

can you try
ClearCollect(NewCollection, AddColumns(Collection,"ID",LookUp(Collection, Name = Value,here you need to have the column from collection))).

Was this reply helpful? Yes No
AmeerJab 370 on at

Like (1)

Report

in your syntax you're putting a table value in a column value

Was this reply helpful? Yes No
pipkinpaula 37 on at

Like (0)

Report

Thanks for your help, but it doesn't work, I need to use something that will compare the names saves on collection one, to my excel table and retrieve the id number to add the id number on the second column.

Was this reply helpful? Yes No
Verified answer

AmeerJab 370 on at

Like (1)

Report

Hello Dear,

sorry for late response.

lets take this scenario:

1- you have a collection that has data from excel, and in this collection you have an Id column and a name column
2- you have another collection that has a column names
3- to get the id from your first column into your second collection you need this syntax
clearCollect(Col3, Addcolumns(2ndCollection, "ID", lookup(1stCollection, Name = 2ndCollection[@Name],id)))

Was this reply helpful? Yes No
pipkinpaula 37 on at

Like (1)

Report

Thank you!

Was this reply helpful? Yes No