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
a
(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
a
(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