Unanswered

Filtering Unique Items Between two lists based on a common field

(0) Share

Report

Posted on by PowerAppsQ

Hi All,

I have two SharePoint Lists, and i created an app that gets data from the first list, and it gets submitted to the second with some additional fields through a gallery.

One of the fields has a Unique number that exist on both SharePoint.

My question is: how can i filter out the data based on; if this field exists on the first SharePoint and is already submitted to the second SharePoint, i would like it to be filtered out of the application.

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @PowerAppsQ

According to your description, you want to filter the items both in the two SharePoint list based on the common fields.
This is my two sharepoint list to test:

This is my flow:

(1)The GetItems , select,initial variable actions:

(2)The “Apply to each” action:

contains(union(body('Select'),body('Select')),items('Apply_to_each')?['Title'])

Then in the end we can use the compose action to see the result in the FilteredArray variable:

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang
PowerAppsQ 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thank you for your response, its appreciated.

what I want to achieve is to have the items in the gallery to contain only the unique items between the two lists (based on that unique ID field)
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @PowerAppsQ
Thanks for your quick response . For example , the two lists are:
And what is the unique items between the two lists (based on that unique Title field)?

In my above reply, the flow return the [t1,t2,t3] which exists both in the two lists.
If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi , @PowerAppsQ
Sorry , i may misunderstand your need , do you mean you want to realize it in Power Apps to get the data exists both in the two Lists.
We can add the data in Power Apps:
And we can use this in the Button -OnSelect:
Set(LisA, ListATable); Set(ListB, ListBTable); Set(FilteredData, Filter(LisA, Title in ListB.Title ))

The result is as follows:

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang
PowerAppsQ 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply and apologies if it wasn't too clear.

I have List A and List B, both of them have a common field (Unique ID).
The power App Gallery pulls data from list A and submits it to list B.
i want the gallery to view only Unique items based on the unique ID field.

as in only items that weren't already submitted from list A to list B to be in the gallery view, and the items that are common between that two lists (Already submitted) to disappear.
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi , @PowerAppsQ
Thanks for your quick response ! For your need , you can use this to filter the ListA to do not contains data in ListB:
Filter( ListATable , !(Title in ListBTable.Title) )
And this will not delegation in SharePoint .
And you can also create a flexible gallery and make all the control in this gallery- Visible:
!(ThisItem.Title in ListBTable.Title)
The result is as follows:

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.You can also give me some sample data with a table to good understand so that i can help you better!

Best Regards,
Yueyun Zhang
PowerAppsQ 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thank you for this, I tried the solution, and it seems to be the right one.

however, something i don't understand happens.

the gallery shows a limited number of old items only and it doesn't show new ones.