Need help with excel data validation

(0) Share

Report

Posted on by Community Power Pla...

Hello Everyone,

I am struggling to find a solution when trying to check for a value from excel.

Basically, I have implemented an OCR model into my workflow to extract information from invoices. But before the extraction starts, I want to check whether the account number within the invoice exists in an excel file. If the account exist, the flow will continue with extraction, if not, the flow will generate an email saying 'the account number is not valid'. Please note, the excel file has multiple sheets and tables and I want the flow to check through each of those sheets and tables.

I have looked for solutions online and found a solution where it says to use 'List Rows Present..' activity, however, within this activity, the 'Table' label allows me to add only 1 table. I currently have 21 tables spread across multiple sheets in one excel file.

Any assistance is highly appreciated. 123

Categories:

AI Builder

I have the same question (0)

All responses (3)

Answers (0)

Antrod Moderator on at

Like (0)

Report

Re: Need help with excel data validation

Hi @Anonymous ,

Did you try using the "Get tables" action card? It should get you all the tables from your Excel file, even when they are in multiple sheets.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Need help with excel data validation

Hello,

Thank you for your response. I am trying it now. Do I put the name of the first table in 'Table'? or any name would work?

Was this reply helpful? Yes No
Antrod Moderator on at

Like (0)

Report

Re: Need help with excel data validation

In the "Table" field of "List rows present in a table", I just used the dynamic content "Name" coming from the "Get tables" action. It should do the work dynamically.

Was this reply helpful? Yes No