cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dyee4614
Level: Powered On

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
eka24
Level 10

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
eka24
Level 10

Re: Filtering to only Unique Asset IDS

Try this
Distinct(AssetTrakerTable,AssetsID)
dyee4614
Level: Powered On

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.

eka24
Level 10

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

dyee4614
Level: Powered On

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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,984)