Checking names on two collections updating table

(0) Share

Report

Posted on by nekinekic

I have two collections that I would like to cross reference names on

Collection 1

Name

Bob

Tom

Collection 2

Task Number	Name
1	Bob
2	Bob
1	Harry
2	Harry

Table

Task	Name	Other
...	...	...

So in my case I would like to see if Collection 2 has a matching Name in Collection 1, if it does than not to update the table with that Name and Tasks, if it does not have a matching name than to update the table with the Name and Tasks.

So if I were to check Collection 2 against Collection 1 in this example the table would yield

Table

Task	Name	Other
1	Harry	...
2	Harry	...

I would put in the code I wrote but no part of it works so it would just be a waste of time. I would appreciate any help. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi nekinekic,
you can use search function to check that name is available on collection 1 or not.
Search(Table*, SearchString, Column1 [, Column2, ... ] ) Example Search(Collection2,"Rahul","Name")
then use patch or update function to add new record on Collection2.

Thanks,
Chitrakant27

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @nekinekic ,

I did a test for you.

1\ This is my collection1.

ClearCollect(Collection1,{Name:"Bob"},{Name:"Tom"})

2\ This is my collection2.

ClearCollect(Collection2,{TaskNumber:1,Name:"Bob"},{TaskNumber:2,Name:"Bob"},{TaskNumber:1,Name:"Harry"},{TaskNumber:2,Name:"Harry"})

3\ This is my Table

ClearCollect(Table,{Task:6,Name:"Test",OtherColumn1:"Test"})

4\ Add a button control and set its onselect property to:

ForAll(Collection2 As A,If(CountRows(Filter(Collection1,Collection1[@Name]=A.Name))=0,Patch(Table,Defaults(Table),{Task:A.TaskNumber,Name:A.Name})))

5\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No