Hi All
How do i compare Invoice number from application to excel invoice template if its match need to show it in msg box
Can any one help me on this
@Sam_H
Are you just comparing a selected Invoice from app to a list Invoices on Excel?
If so, Read Range the Excel into Data Table, Loop over Data Table Invoice column, IF a row Invoice is equal to App Invoice (Not sure how you are getting this variable, Get Text Activity I assume), Message Box activity appears with whatever…
Regards
I’m comparing invoice from application to excel if it matches then need to display it in msg box
@Sam_H
You did not answer how you are acquiring your value from App?
But once you have that value you could use below:
Regards
i’m looking solution for this question it self
Do you have any idea how can i acquire values from app
@Sam_H
You can use Extract Table Data activity:
Read Excel into Data Table:
Then For Each inside another For Each to compare each value:
Regards
If its matches with invoice from app then i need to click on that invoice No from app that will open another application
How can i approach this
@Sam_H
Use a Dynamic selector using the matched Invoice number to a Click Activity inside the if statement.
regards
Wht if every time invoice number will get change.will Bot able to identify new invoice number…?
mpraveen1902
Anil_G
supermanPunch
Sagar_Sukla
Puneet_Singh1