Power Automate flow from Spreadsheet
Budget: $10 – $30 USD
Help me design a power automate flow (or alternative low / no-code Microsoft solution, including Microsoft Agents) which does the following:
- Scans inbound email for a string
- If string exists in Column A of a spreadsheet on Onedrive, THEN
- If sender matches one of the column heads in that spreadsheet reply using the the value in that column number which corresponds to the row that the string was found in. (I.e. string is "123" and we find it in cell A44; sender is john at smith.com in cell D1; therefore respond to sender with the contents of cell D44)
- If sender does not exist apply the same logic but use column B
- If no string exists, send an email telling the sender we're going to forward this email to a human, and then forward the mail to a set email address
- Scans inbound email for a string
- If string exists in Column A of a spreadsheet on Onedrive, THEN
- If sender matches one of the column heads in that spreadsheet reply using the the value in that column number which corresponds to the row that the string was found in. (I.e. string is "123" and we find it in cell A44; sender is john at smith.com in cell D1; therefore respond to sender with the contents of cell D44)
- If sender does not exist apply the same logic but use column B
- If no string exists, send an email telling the sender we're going to forward this email to a human, and then forward the mail to a set email address