cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dlprentice
Responsive Resident
Responsive Resident

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
Community Champion
Community Champion

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

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,298)