Answered

SQL Lookup Expression

(0) Share

Report

Posted on by ez1138

218

Hi, to populate certain fields in the "Populate Word" piece, I'm having some trouble creating the expression. Or is there a way to pull in all of the rows of the table another way? Not worried about copying/pasting/modifying expressions...once it's in place it will not change for a long time.

Here's a little more detail...

SQL Server Table - dbo.descriptions
Example of row detail, Title is ABC123
Looking to pull the Description for ABC123

Categories:

Using connectors

I have the same question (0)

All responses (6)

Answers (1)

v-litu-msft on at

Like (0)

Report

Hi @ez1138,

To use the filter query could find the Title is ABC123, there is using ODATA syntax, Title eq 'ABC123', eq means equals.

For more ODATA syntax, you could refer to this document:

https://www.odata.org/documentation/odata-version-2-0/uri-conventions/

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report

Thanks for the reply. That did not work. ABC123 is simply the name, title is the column and there are hundreds of rows. So if a row has ABC123 as the title, I would like to pull the "description" of "This is a description".

ID Title Description
1 ABC123 This is a description.
2 DEF123 This is a description.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @ez1138,

OK, after you get rows which title equals to "ABC123", you could use the expression to get the Description:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report

Awesome, I will give it a try and let you know. In addition to the description column, what's the best practice to add additional columns based on the same Title column?

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report

Hi, knowing someone was missed since I did not see a spot/location to place in "Title", it did not work as expected. Referencing an earlier reply, ABC123 is just an example. I literally have hundreds of rows. Are you saying that I have to create an "apply to each" hundreds of times?

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (0)

Report

Hi @ez1138,

If you want to add multiple condition into the filter query, such as ID, you could add the filter query as below:

Title eq '123' and ID eq '12'

It's no need to create multiple Apply to each action, you just need to one, the Apply to each will loop through all items of the Get rows output. Could you please share your Flow run history and status? If there is any error when it runs, please share the error information, thanks.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No