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.
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!
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |