Answered

Duplicates in Text Input Across Gallery - How to Identify Them?

(0) Share

Report

Posted on by CraigLee23

I have a gallery fed by a Sharepoint list allowing users to enter a MAC Address, Serial Number, etc into Power Apps. I am trying to find a way to identify which text inputs are a duplicate from other text inputs. My use case is we have users duplicating MAC Addresses across the screen and I need a way to identify it.

Any thoughts on how to accomplish this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
It's really easy. It all depends on what you want to do. If you want to highlight (set the fill) the control or change the border color for the duplicates, you would simply set a formula like this one:

If(ThisItem.columnname in Datasource.columnName, Red, Black)

If you want to have a popup message of some sort when a user enters a duplicate mac address, you would set the OnChange value of one of the text inputs to something like this and then use your variable to control the visibility of the controls you are using for your 'popup' message.

If(Self.Text in PowerAppsData.Title, Set(varDuplicate, true))

Was this reply helpful? Yes No
CraigLee23 22 on at

Like (0)

Report

Thanks for the help! I am trying to figure this out with a Text Input in the gallery matches any other Text Input across the Gallery. So my 'data source' is the inputs that the user has entered so far.

I'll do another check against the DB, but I get that part. My concern is the onscreen stuff that has been entered.

I'm thinking I may need to Collect each MAC value when 'OnChange', then match against it in a collection....make sense?

Was this reply helpful? Yes No
Ricardo_Costa 150 on at

Like (0)

Report

I assumed the 'OnChange' is a textbox property, so, you don't need to collect since you already have all MACs.

in the OnChange, you can just test like this

If(IsBlank(LookUp(MyDataSource,MAC = txbMAC.Text)),"","MAC already registered")

Was this reply helpful? Yes No
Verified answer

CraigLee23 22 on at

Like (0)

Report

I solved this - each of your tips above helped my writers block and I have a solution....using a collection.

Screen - OnVisible:

ClearCollect(colDup, {MAC:"X", Solution:"X", Item:"X"});

Within the Gallery, each solution item can have up to 10 MAC Addresses, so I have a text input (MacInput_1 thru _10). Here is the MacInput_1.OnChange:

If(IsBlankOrError(LookUp(colDup, Solution = ThisItem.ProductCode && Item = "Mac1")),
Collect(colDup, {MAC:Self.Text, Solution:ThisItem.ProductCode, Item:"Mac1"}),
UpdateIf(colDup, Solution = ThisItem.ProductCode && Item = "Mac1", {MAC:Self.Text}))

I made the same change for _2 thru _10.

Then I updated MacInpupt_1.Fill:

If(CountRows(Filter(colDup, MAC = Self.Text))>1, Red, White)

I made the same change for _2 thru _10.

This is working as I intended.

Was this reply helpful? Yes No