How to extract particular data from dropdown

Help Studio
, ,
#1

Dear Masters,
I extracted data from the drop-down(eg: RED, BLUE,GREY, BLACK, etc) using find children activity and get attribute. Now I want to compare my data in an excel item (eg: GREY) from dropdown data. if it is available I will execute the next activity otherwise it must show an exception. Kindly help me.tq

#2

Hi @lakshmi_narayana_ch ,
this youtube link might help you:

Thanks & Regards,
Shubham Dutta

#3

sounds as you want to check if a particular drop down value is present or not

If Activity: Condition -

YourFindChildrenOutput.Any(Function (x) x.Get("innertext").toString.ToUpper.Trim.Equals(strCheck.Trim.ToUpper))

Then: doYour Steps
Else: handle the tasks when value is missing

#4

Not working it is going to else part

#5

Hello @lakshmi_narayana_ch , Kindly refer this Xaml file, You may got some idea
FindChildren.xaml (24.3 KB)
In flow there is 2 for each

  1. Based of for each data table
  2. Based on lookup data table
#6

set a breakpoint on the if activity
run debug file and get paused
type into the immediate panel

YourFindChildrenOutput.Select(Function (x) x.Get("innertext").toString).toArray

and the variablename which is used for the check

please share with us the output from immediate
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

#7

Use For Each for List of Children
Inside that
Boolean_Var=DT.Asenumerable.Any(Function(r) r(Column_Name).To string.equals(item.Get(“aaname”).Tostring)

Use if activity
True Means Next Steps
False Means Throw an Exception

#8

Yes, it is working.Thank u

#9

@lakshmi_narayana_ch
Perfect. So the topic can be closed, right?
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

#10

yes.Thank u

#11

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