Unanswered

Merge 2 Sharepoints with same ID

(0) Share

Report

Posted on by Mihaela08zl

Hello, Could you please tell me how to put a filter into filter, but with different source. Or how can i join two sharepoint lists based on same ID.

I wrote this code it is good, but it only gives me the first record beacause of LookUp

Filter(ListAll,TextInput1.Text in 'Name&Surname',Title=LookUp(ListHours,Dropdown2.SelectedText.Value in Project).Title || IsBlank(Dropdown2.SelectedText))

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Mihaela08zl

To join two lists, use the AddColumns() function. I suggest starting with the list with more columns. It would be

AddColumns(listbig,"columnname",Lookup(list2,commoncolumninlist2=columninlist1).columnname, "someothercolumn",Lookup(list2,commoncolumninlist2=columninlist1).someothercolumn,"etc...)

It can be used as the Items property of a gallery or you can create a collection with it and use that.
Mihaela08zl 99 on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp Hello, ty for your answer. I have tried this but in my gallery there are no records now.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Mihaela08zl

Could you post the Items property of your gallery as text please?