cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dlprentice
Resolver II
Resolver II

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

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).

 

Screenshot 2021-01-28 072818.png

1 ACCEPTED SOLUTION

Accepted Solutions

@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

 

annajhaveri_0-1611840887039.png

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

View solution in original post

6 REPLIES 6
annajhaveri
Super User
Super User

@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. 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

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"?

@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

 

annajhaveri_0-1611840887039.png

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

View solution in original post

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

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.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

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

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (70,119)