I am working on a bot that will scan a website and extract lead information. The website has new leads added to it constantly. So the bot should scan the site for new numbers and message the ones that have not been contacted. I have managed to scan the website with the bot. It actually downloads the excel version of from the website so the new leads are in a dynamic excel sheet. But I am stuck at the part where the bot determines if any particular phone number in the New Leads excel sheet has already been contacted.. I know it SHOULD compare the current phone number against a list of phone numbers in a different excel sheet (the ones already contacted). If the current number is in the list, it does nothing. If the current number Is NOT on the list, It sends a message/email. The excel list will be constantly growing because at the end, after the message is sent, the bot should add the current phone number to the excel list to ensure it never gets contacted again. How can I have power automate compare the dunamic current website phone numbers against the dynamic excel list? I would like a detailed explanation with the specific set up in power automate desktop (conditionals, etc). If you provide me a solution that works I might venmo you $10

Report
All responses (
Answers (