Unanswered

making a flow with SQL and sharepoint

(0) Share

Report

Posted on by TarekEzz

hello everyone

am trying to make flow that should autofill the shrepoint list once I entry the ID of an employee
so my plan was using both cloud and desktop automate
the flow :
when a new item is added into a sharepoint list
open SQL connection
get the desired data from DB
update the list according to the DB

but am not able to make such a flow, if you have any advice would appreciate that

FYI : i want to make the flow start when a new item is added into the list (which will be the ID) and then autofill the rest of the fields based on the given ID in the sharepoint list
then update the sharepoint list and then use those data i got to send an email +creeating excel tables
i have made the flow at the beginning without connecting to DB so all the columns are been entered manually.
any help will be much appreciated

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @TarekEzz ,

You need to install a data gateway on the server where SQL DB located.

Using Flow with on-premises data and applications | Power Automate Blog (microsoft.com)

In the automated flow, you can connect to the database directly, no need to create desktop flow at all. However, due to different column types in SharePoint, it's hard to tell how to populate list columns using SQL data, you need to provide more detailed information about the two data sources.

Best regards,

Was this reply helpful? Yes No
TarekEzz 16 on at

Like (0)

Report
Copy link

Link copied!

I have tried to connect and use only the automated flow which makes more sense, but for some reason when I applied the filter query, I was never able to get any results.
so I tried to use both desktop and cloud
but am not able to pass the variable which will be the ID that I get from CLoud flow to the desktop to use it as a filter and get me only the employee under that ID
the second issue I faced was after I retrieved the data from DB in the desktop flow, how I passed it back to the cloud flow

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TarekEzz ,

So, let's troubleshoot why can't get the item from list rows actions when applying filter query. What query have you tried? What type is this column in SQL table?

Best regards,

Was this reply helpful? Yes No