web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Get rows action oc...
Power Automate
Unanswered

SQL Get rows action occasionally failing - unable to find SQL table

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have a flow with a SQL Get rows action and about 10% of the time the flow is failing with the error below:

 

Invalid Mashup Expression using supplied values. inner exception: The specified item '[dbo].[MyTable]' is not found.

 

Basically, Flow is saying that it can't find my database table. This makes no sense to me, because the other 90% of the time the Get rows action executes flawlessly. The fails and the succeeds are happening during the same time period too: earlier today, the flow ran about 30 times in a 2 hour period, and the fails were more or less evenly spread throughout that period. So it doesn't seem like this is an issue of database availability. Any ideas what is going wrong here?

 

Categories:
I have the same question (0)
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi JML,

     

    How is the Primary key column name configured?

     

    When I create a flow with the action “SQL-Get rows”, it seems that I haven’t occurred the error so far.

     

    Have you tried to resubmit the flow to see if it will work?

     

    Best regards,
    Mabel Mao

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard