I have a workflow which finds a text (2021 or FY21) in every sheet of an excel.
If either one text is identified anywhere in the sheet, the bot is supposed to write the cell address to me.
The bot is working however, the bot only highlights the cell address to me if the cell content is “2021” or “FY21” (standalone with no other text). If it appears as a sentence or date format in a cell, the bot fails to highlight the cell address.
How do I rectify my flow so that I can locate the text everywhere within a sheet?