Unanswered

Is it possible to Update a SharePoint list with Data from an AZURE Database? and if so how ? hard time find samples on internet

(0) Share

Report

Posted on by SPS-DEV-22

516

I have been asked to develop a power automate flow to get data from a AZURE Database. Is it possible to Update a SharePoint list with Data from an AZURE Database?

How can I achieve this? I've looked on Internet, but it is all SQL to SharePoint list, not AZURE. or do we handle it the same?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey @SPS-DEV-22

When you say AZURE Database do you mean AZURE SQL Database?

With SQL Connector you should be able to get rows for Azure SQL DB - You can create a connection with reference to https://www.youtube.com/watch?v=LjI-YdS2r9k

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

the steps and information to refer to instead of trying to watch a video. Is there a Blog or something to look at?
Yes, exactly AZURE Database and tables,

but youtube videos are a no go here at work.

Blogs are easier and are Ok to access.
and Yes I'm using the SQL Connector in Power Autom ate

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@SPS-DEV-22 - Perhaps read this - https://powerapps.microsoft.com/en-us/blog/general-availability-of-the-azure-ad-sql-server-connector/

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

this is going to be touchy, for the AZURE team as they did the account with Azure AD Integrated-MFA.

but I do not get that prompt, to set that,

Was this reply helpful? Yes No