Hello! I’m starting to use OCR in Apps. In this case, I’m trying to find a name in the text coming from the image.
- The name could be any from a list of names. Which is in another table: (“Recipients [Recipients]”)
- ([label data]) is the text from the images (it changes depending on the picture)
I’m trying to get the email next to the names column.
LOOKUP(SUBSTITUTE(ANY(Recipients[Recipients]),[_THISROW].[Label],ANY(Recipients[Recipients])),“Recipients”,“Recipients”,“email”)
The problem with this formula is that it doesn’t match the name.
Please let me know! Thank you!