Automate SQL Databases with Microsoft Power Automate Desktop

Automate SQL Databases with Microsoft Power Automate Desktop

Anders Jensen

1 год назад

24,140 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@MindyBrockdesigns
@MindyBrockdesigns - 05.02.2024 23:11

Is it possible to create an automation cloud flow in power automate to copy data from table A to table B in SQL server? Reason being, going from a Microsoft form to SQL creates it’s own ID’s. But I want to coincide with data entries already in table B and set the ID field to identity key field.

Ответить
@fatikelmaswegho1354
@fatikelmaswegho1354 - 18.09.2023 20:54

Hello Mr Jensen,
Thank you so much for the video but i am still confused. Can you please assist with a flow that loads csv files from a folder into a sql table? where the file already exist in the sql table, skip else create records in the sql
I am able to successfully load 1 file but cannot iterate through several because it will not let me link the columns through indexing

Ответить
@jameerbasha5785
@jameerbasha5785 - 04.06.2023 15:04

we can get connection postgresql server in power automate desktop ?

Ответить
@dion4894
@dion4894 - 16.05.2023 16:46

Can you make a video how to achieve this using the SQL connector in Flow? I can't seem the make a right connection with a SQL database using the Flow SQL connector.

Ответить
@hotelranimahaljaipur9380
@hotelranimahaljaipur9380 - 05.05.2023 19:09

Can you pls give us a comparison vedio between uipath vs PAD vs A360 ? I would love to have that? Also I'm curious to know about career and scope in RPA developer

Ответить
@user-sx5iw9pq8i
@user-sx5iw9pq8i - 04.05.2023 15:23

Hi
How to Integrate Uipath Studio with Power BI
Can you make a video

Ответить
@shaunrowley7230
@shaunrowley7230 - 02.05.2023 22:45

Another excellent video that has given me an idea for a project where i set up postal contacts list as an SQL database and then using Power Automate for Desktop can extract the data for example addresses for christmass cards write these to an excel sheet then automate my Dymo label printer software to load a label template and the excel data to print out the labels to attach to my christmas cards to post. For those that run a club etc. could use in a similar way. Thanks again 👍

Ответить
@sanketsingh1735
@sanketsingh1735 - 02.05.2023 22:31

Is there any way to connect to oracle data base without the connector given in cloud flow like can we connect to oracle db from desktop flow if yes how ?

Ответить
@mdhidayat5706
@mdhidayat5706 - 02.05.2023 17:13

Though I am comfortable with SQL, I hope we get a GUI wizard where we can filter datatable easily in the future.
Something like Uipath.
These SQL syntax tend to scare business people 😅

Ответить
@suraj_singh321
@suraj_singh321 - 02.05.2023 17:10

Hi Anders sir make a video on SharePoint actions in PAD

Ответить