Import data from sql server to a sharepoint list

(0) Share

Report

Posted on by mimi51340

Hello,

I created a new flow to import data from sql server to a sharepoint list.

But I have an issue because I need to add a filter in my sql request from the previous request (previous request is : get sharepoint items). From my previous request I have a field (Request number) that I need to add in the sql filter. How can I do it ?

Thanks a lot.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Riyaz_riz11 3,844 Super User 2025 Season 2 on at

Like (0)

Report

Hi @mimi1255 ,

You can provide condition if it matches then do this you can use.

Regards

Ahammad Riyaz

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report

Do you need to pull records for:

each record returned from the get items action
each unique request number returned from the get items action
just one request number

?

Was this reply helpful? Yes No
mimi51340 4 on at

Like (0)

Report

For each item in the sharepoint list containing a request number, I need to check the sql table to see if the number exists.
And if it exists I need to get the amount of the orders.

Was this reply helpful? Yes No
KvB1 1,596 on at

Like (0)

Report

Okay so that would be option: each unique request number returned from the get items action?

After the get items action, add a select action to grab the request number.

Then, add a compose action, where you union( the output of the select action with itself, to return an array with unique request numbers. This will also eliminate empty records.

Then you give compose action as input for an apply to each loop, where you can use an odata filter query in the sql action, something like: SQLColumnName eq items('Apply_to_each')?['RequestNumber']

On a side note, if you are working with large tables, power automate is not the greatest tool to use, since it will take a very long time to go through the flow, and you might run into throttle limits

Was this reply helpful? Yes No
mimi51340 4 on at

Like (0)

Report

Hello,
I do not understand the second step.
I created this :

But I did not understand the following step.

Thanks a lot

Was this reply helpful? Yes No