Need to create commands

Help Activities
, , , , , , , ,
1

I have Boolean variable
boolnamematches=true
booladdressmaches=true
boolnumbermatches=false

Comment to be added in excel as name, address matches telephone not matches
How to implement it in single line

Forum Engagement Daily Reports
2

Hi @sruthesanju

 (If(boolnamematches, "name matches", "name not matches") & ", " & If(booladdressmaches, "address matches", "address not matches") & ", " & If(boolnumbermatches, "telephone matches", "telephone not matches"))
3

Which activity should I use this

4

@sruthesanju

Check with log message or message box.Whether you are getting the required output or not.
If yes store in the variable using assign activity and use in the further steps

Hope it helps!!

5 
If(boolnamematches And booladdressmatches And Not boolnumbermatches, "comment in excel",Nothing)
6

name matches,add matches ,number not matches

How to make it like this

Name,add matches and number not matches

7

@sruthesanju

Check with this

 (If(boolnamematches, "name matches", "name not matches") & ", " & If(booladdressmaches, "address matches", "address not matches")).Replace(", address matches", " and address matches") & " and " & If(boolnumbermatches, "telephone matches", "telephone not matches")
8

@sruthesanju

(If(boolnamematches, "name matches", "name not matches") & ", " & If(booladdressmaches, "add matches", "add not matches")) & " and " & If(boolnumbermatches, "number matches", "number not matches")

This image shows a workflow in UiPath with a "Multiple Assign" activity setting three Boolean variables and a "Message Box" displaying a conditional message based on the values of these variables. (Captioned by AI)
This image shows a workflow in UiPath with a "Multiple Assign" activity setting three Boolean variables and a "Message Box" displaying a conditional message based on the values of these variables. (Captioned by AI)1073×419 20.5 KB

9

Replaces will not work it is not constant some time name will not matches same for add number either match or not match we will get

10

@sruthesanju

In the recent updated solution we havent used replace.Please check and let me know

11

This one is different right if matches cases means it should come as name ,add matches

12

from the above given requirement we derrive that the report is aggregating the matchnames on its results.
name, name1… matches name2, name3… not matches

We assume that it should be dynamically

One of more options is to model it as the following:

The image shows a sequence in an RPA workflow, with variables including a dictionary and strings, and a table listing variable names, types, scopes, and default values. (Captioned by AI)
The image shows a sequence in an RPA workflow, with variables including a dictionary and strings, and a table listing variable names, types, scopes, and default values. (Captioned by AI)796×533 49.4 KB

we create a dictionary (can by done dynamically)
then we process the dictionary entries by:

  • grouping the entries on the match result
  • aggregating the names
  • appending the match result
  • Concatenating all report groups

strReportLine =

(From kvp In dictMatchResults
Group kvp By k=kvp.Value Into grp=Group
Let nl = String.Join(", ", grp.Select(Function (g) g.Key))
Let rs = If(k, "matches", "not matches")
Select cs = nl & " " & rs).Aggregate(Function (x,y) x & " " & y)

Check:
grafik

It will by create dynamically build the string and also the position of trues, falses are irrelevant as it will catch it during the grouping