An expression to match a closely matching value (but not exact)?

[dlprentice]

Is there any expressions that can help me match up two most closely matching values?

"Row 126 most closely matches your key value input". - Basically this. From this I would be able to extra data from the other columns in that row (my end goal).

[annajhaveri]

@dlprentice  can you please let me know what does closely match mean, it is contains value of starts with or ends with value? I think Get a row will do extact match of Key value in Key Column. Instead you can use list rows present in a table with filter query. 

[dlprentice]

Lets say the full value I'm looking for is

IFTT4F-DDDLSO33332

But all I have to work with is

IFTT4F-DDDLSO3

How do I match the incomplete string "IFTT4F-DDDLSO3" with the row that contains "IFTT4F-DDDLSO33332"?

[annajhaveri · Accepted solution]

@dlprentice , you can use "List rows present in a table" action as shown in below screenshot, please note the filter query has the condition (replace Message with your column name in the filter query). Then you add apply to each action to loop through retrieved rows from excel, to get value of other columns, e.g. i am getting value of Date column of excel in the loop

[dlprentice]

This isn't as easy as I thought.

I have a table called "Circuits"

I want to only work with column "Dns Entity Name"

When I put contains(Dns Entity Name, 'doi') I get an error.

')' or ',' expected at position 13 in 'contains(Dns Entity Name, 'doi')'.
inner exception: ')' or ',' expected at position 13 in 'contains(Dns Entity Name, 'doi')'.
clientRequestId: 63d48af7-3294-4236-85e0-307ddc3dc176

[annajhaveri]

Your column name has space, Dns Entity Name, can you please remove spaces from the column name in your excel and then use it in filter query and then run the flow? Filter query doesnt support spaces in column name. As an alternative you can put under score instead of space in column name.

[dlprentice]

Thanks, everything worked once I removed the spaces in the headers.