cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Filtering to only Unique Asset IDS

Hi.  I built an asset tracker.  The issue with my asset tracker is you can scan the same barcode multiple times or scan a different barcode and get the same asset ID.  I want to make sure my collection only shows one asset ID.  Is there any way I can do this outside of using a group by function?

 

Example: 

Data collected.

BarcodeAssetID
1A
2A
3B
4B
5C

 

Filtered:

BarcodeAssetID
1A
3B
5C
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Filtering to only Unique Asset IDS

I want to understand, you have AssetID A that matches to 1, 2 . But in your filter results you showed only 1 for AssetID A .
What determines whether it should be 1 and not 2 for Same AssetID A .
My other question is it to a collection or a gallery

View solution in original post

4 REPLIES 4
Highlighted
Community Champion
Community Champion

Re: Filtering to only Unique Asset IDS

Try this
Distinct(AssetTrakerTable,AssetsID)
Highlighted
Helper IV
Helper IV

Re: Filtering to only Unique Asset IDS

@eka24  Thanks for your suggestion!  I don't think distinct works because it creates a 1 column table which means I won't be able to get the rest of the information I need.  I also tried Filter(Collection,Distinct(Collection,AssetID)=AssetID) which doesn't work either.

Highlighted
Community Champion
Community Champion

Re: Filtering to only Unique Asset IDS

I want to understand, you have AssetID A that matches to 1, 2 . But in your filter results you showed only 1 for AssetID A .
What determines whether it should be 1 and not 2 for Same AssetID A .
My other question is it to a collection or a gallery

View solution in original post

Highlighted
Helper IV
Helper IV

Re: Filtering to only Unique Asset IDS

I figured it out.  I just added logic to prevent it from making a record before it creates a duplicate.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (8,866)