I want to output in excel for data that is not in web search

Friends, my problems do not end,
Now, while the web search is in progress, I want it to output the result not found in the excel output, what can I do instead of skipping the search, please help

for example:
StockTable PriceTable
306451 - 1250$
306452 - results not found
excel output

1 Like

I need to help please

1 Like

Hey @A_Zyzz_Man

When you don’t find a result you want to write it in Excel as ‘result not found’ right ?

This is what you are looking for, I believe

  1. Use Element Exists to check if your price element is present

  2. Use IF to check the condition output of Element Exist

  3. Found then write value else write the static string ‘result not found’

Hope this helps

Thanks
#nK

Thank you so much, but I need to see how it is done on the diagram please help me…

1 Like

Hey @A_Zyzz_Man

Check this out please…

Thanks
#nK

1 Like

can i do this on it?

1 Like

Oh Okay @A_Zyzz_Man You are using modern design.

Yep, you can do on that should be fine.

Thanks
#nK

1 Like

Can you show me how to add the static message, everything is so complicated in modern design?

1 Like

Could you please show a snap of your Add data row please which you have on the right ?

Where am ı wrong?

1 Like

Hey @A_Zyzz_Man

Towards the left from the Add Data Row just replace your strPrice with the static string "results not found"

This should help

Thanks
#nK

1 Like

thanks for everything dude it finally worked… :pinched_fingers:

1 Like

Cool @A_Zyzz_Man :slight_smile: :+1:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.