Hey everyone,
I've built a QR scanning app which takes the following example JSON from a QR Code and stores it in a text field before sending it off to a Sharepoint list. I need to be able to extract the 'FullName' value and display it on a screen before the record is submitted to Sharepoint. I can't use Flow to do this due to the app needing to work where mobile reception is very unreliable.
{"Email":"me@test.dk","FullName":"Me H. Mine","IsShareholder":true,"FieldRep":"Joe Bloggs","SupplierNumber":"S003535","GenericExtensions":[{"Key":"Loyalty","Value":"Gold"},{"Key":"AttendanceLevel","Value":"High"},{"Key":"NewsLetterSubscriber","Value":"Yes"}],"LastUpdatedOn":"2020-04-14T16:22:10"}
Ideally, I'd have liked to be able to just parse the JSON, but scanning it in via QR into a variable seemingly means I can't just call the object - if I take the above and Set it into a variable (qrtstring) then I can do the following
Concatenate("Welcome " , qrstring.FullName)
So I'd like to know how to use a combination of the First/First/Match functions etc to find the 'FullName' object and return the name (Me H. Mine)?
TIA