Matching item from 2 list and email if no mactch

[The_blue]

Background: We have a powerapp that's used to highlight defects, mark equipment on a list as broken in a register (list) then emails the engineer some details including a 10 digit unique defect code 

The engineers can't access our network so we've made an MS form where they cut/paste the unique defect code and repair details and flow matches the new item created with the register/list and ticks off the repair and updates status to green...

What i hadn't bargained for was the inability to cut and paste the unique ID properly...

What i want to do is when the new item from the form is created is check the unique id against the main list and if not found, send an email. 

I thought it would be a condition but no luck with 'equals', 'contains' etc, they all come back false regardless

Any ideas?

Data from form is added to a list and looks like

Repaired by	Unique ID code	Email	Comments
Bob	WA24376-202102120756	A@b.com	fixed the wheels

Register looks like this

Item	Working?	Unique ID code	Plug	Wire	switches	feet	Wheels
Toaster	Yes		Yes	Yes	Yes	Yes	Yes
Bike	No	WA24376-2021021207566	Yes	Yes	Yes	Yes	No
Chair	No	PA77576-202102660756	No	Yes	Yes	Yes	Yes

[tom_riha · Accepted solution]

Hello @The_blue ,

you can do a 'lookup' to the Register list. When a new item is created in the Form list, use 'Get items' action on the Register list with a Filter Query on the Unique ID code: get only items from the Register list whose UniqueID is equal to the UniqueID of the new item.

UniqueIDCodeRegisterList eq '[UniqueIDCodeFormsList]'

Notes:
UniqueIDCodeRegisterList is the internal name of the column on the Register list
[UniqueIDCodeFormsList] is the dynamic content from the new item in the Forms list

Then you can check if the 'value' output from the 'Get items' has any item. If it contains any item, then the item with the UniqueID exists. If it's empty, there's no item with such UniqueID = send an email.

I use the length(...) expression to check if an array is empty. If length(array) is greater than 0 = it's not empty. If it's equal to 0 = it's empty.

[The_blue]

I was so close 😆

Thanks, that works perfectly. I'd danced around similar for ages, just hadn't tried length. 

Thanks again 🙂