I have two labels that I need to compare. We want to make sure the manufacturing part number on our internal label matches the manufacturing part number provided by the manufacturer. Our QR code on our internal label doesn't just contain the manufacturer part number which is my issue. It contains 8 pieces of information all comma separated. I know that what i'm looking for is always going to be after the 4th comma in the string. Is there a way to extract that info so I can do a comparison of that to the label provided by the manufacturer??
Solved! Go to Solution.
The following will give you the 4th element:
Last(FirstN(Split(yourScannedValue, ","), 4)).Result
I hope this is helpful for you.
The following will give you the 4th element:
Last(FirstN(Split(yourScannedValue, ","), 4)).Result
I hope this is helpful for you.
Genius, it worked. Thanks!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
199 | |
52 | |
41 | |
39 | |
35 |
User | Count |
---|---|
261 | |
86 | |
71 | |
69 | |
66 |