Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Flows / how does "sql get rows...
Power Automate - Using Flows
Answered

how does "sql get rows" work?

(0) ShareShare
ReportReport
Posted on by nphdiem95

Hi all,

 

I am a new user of MS Flow.

I want to create a real time report in power BI, so I use "SQL Get rows" to keep my report updated.

How many rows can the Flow get in one turn? and how can I get only new rows or updated rows?

 

Thanks.

  • Verified answer
    yoshihirok Profile Picture
    yoshihirok 1,724 on at
    Re: how does "sql get rows" work?

    Hi @nphdiem95

     

    I share a Flow Cookbook "Notify Max No of SQL Server records to Phone"

    https://powerusers.microsoft.com/t5/Flow-Cookbook/Notify-Max-No-of-SQL-Server-records-to-Phone/m-p/49958#M21

     

    This flow notify max no of SQL Server records by using "SQL Server - Get rows" action.

     

    I hope to help your question.

     

    Regards

    Yoshihiro Kawabata

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans