I am using a spreadsheet sent to me from another department as the input for a RE Framework bot.
Sometimes the other department fails to include the phone number column in the spreadsheet.
If the phone number column exists, I will have the bot input the provided phone number into the browser field. If not, the bot will enter a default (999) 999-9999.
Outside of RE Framework, I did this with an If condition of ‘InvoiceTable.Columns.Contains(“PhoneNumber1”)’.
InvoiceTable was the name of the data table.
How do I check the transaction data to see if it contains the PhoneNumber1 item now that I’m not using a data table?
I am not using Orchestrator for this bot.
Your assistance is greatly appreciated!