Lookup Data Table but values contains '

[ppr (Peter Preuss)]

@adrian_sullivan

lets summarize the different inputs from above:

• we had shown you the reason and the fix

@ppr

with the single dot we confuse the syntax and we have to escape it with an additional one

For:

@adrian_sullivan

create a boolean variable (DatePresent) to check see if the value is present

we had introduce the Any Operator which is returning true or false depending on the presence:

@ppr

instead of using count and pay the processing costs of all rows evaluation we would use the Any LINQ Operator

For the depending Column2 Value lookup we also shared a few options e.g.

@ppr

Assign Activity
strValue =

(From d in DT_Values.AsEnumerable
Let cs = d(0).toString.Trim.ToUpper
Where cs.Equals("Date de VL et d'actif géré".ToUpper)
Select v = d(1).toString).DefaultIfEmpty("-1").First()

when found will return the value as string
when not found it will return -1 as string and you can adapt the default values as well

Also feel free to combine the different Approaches as we also have done (Select, Any, Value retrieval …)

So we do feel that the topic can be closed

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…