News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows SQL get rows emtpy

Power Automate - Using Flows

Unanswered

SQL get rows emtpy

(0) Share

Report

Report

Posted on by YannisB

11

Hello all,

I have a recurring flow that

get sharepoint list items
deletes the items
get rows from SQL
inserts the sql rows into the sharepoint list

This flow on the get rows action returns an empty data set. There are no failed steps.

If I run this manually it completes without issue.

This flow used to run for many months without issue,

How could I trouble shoot such behaviour?

I have tried to run this 2 times per week hoping that the 2nd time it would work but alas..

All responses Img

All responses (2)

Answers Img

Answers (0)

YannisB 11 on at

Like (0)

Report

Re: SQL get rows emtpy

@SudeepGhatakNZ could in theory the account be different when running automatically vs manually?
This is what the raw inputs from both runs (automatic and manual) show
{
    "host": {
        "connectionReferenceName": "shared_sql_2",
        "operationId": "GetItems_V2"
    },
    "parameters": {
        "server": "default",
        "database": "default",
        "table": "[dbo].[PagiaCustomers]"
    }
}
SudeepGhatakNZ 14,297 Most Valuable Professional on at

Like (0)

Report

Re: SQL get rows emtpy

@YannisB ,
What account is the flow running against, does it have access to the SQL table?
Did you investigate the flow run?

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

Leaderboard

#1

WarrenBelz 146,537 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,908 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans