At my company, I've setup an inventory tracking app. All the items in inventory have an associated QR code that just translates to the item's plain-English name, or the "Title" of the item. For example, the 6ft USB-C to Lightning cables will have a QR code that, when scanned, returns "USB-C to Lightning Cable 6ft".

When items are scanned in and out of inventory, it logs that transaction on a SharePoint list we'll call "Transactions". When an item is added to this list, a Flow is triggered to update quantities on another SharePoint list we'll call "Quantities", which stores how many of each item we have on hand.

Based on how many of the item are scanned in or out of inventory will determine what it updates the value in "Quantities" to. For example, say we have 6 of those charging cables in inventory, and we purchase 6 more and scan them into inventory. It will update the Quantities list to show 12. Then, if we scan out 2 for employees, it should update it again to be 10.

The way it does this is by simply comparing the scanned item's Title to the Title of the item in the Quantities list. If they match, it will update the quantity. If there is no matching item in Quantities, it will create a new item with the scanned item's Title.

Everything works great with the app, Flow, SharePoint list, EXCEPT, sometimes when we scan the QR code, it gives us different output. It's the exact same QR code using the exact same PowerApp I created. For example:

• One day I scan a "USB-C to Lightning Cable 6 ft" into inventory, and the "Title" is exactly that.
• Some other day, the same item above is scanned into or out of inventory (doesn't matter which), but the backend data will show the Title as "USB-C to Lightning Cable \r\n6 ft".

USB-C to Lightning 6 ft

USB-C to Lightning \r\n6 ft

The problem is, now the compared Titles do not match. "USB-C to Lightning 6ft" does not equal "USB-C to Lightning \r\n6ft". This isn't an issue with this specific item, I'm just using it as an example. But it seems to be totally random. It's really caused some headaches because our inventory is not being tracked accurately as the QR code values are randomly different for no apparent reason.

I've done testing on this and cannot replicate it whenever I try. But when our procurement assistant mentions quantities not matching up to what they should be, I go back into the Flow execution history and can see the different Titles for the item scanned in different transactions. The QR codes have not changed but some transactions will have that mysterious carriage return character (\r\n) in them, sometimes they just have the \r in them with no \n, and sometimes neither will be there.

Here is where the comparison happens - when item is created in "Transactions", it Gets Items from "Quantities" that have a matching title. Flow_Screenshot_GetItems