web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Cant see tables in SQL...

Power Automate - Building Flows

Answered

Cant see tables in SQL Update row action

Like (1) Share

Report

Report

Posted on 2 Aug 2022 03:37:29 by ppl

404

Hello

I cant see sql tables in Update Row action, but I see them in Insert row action. Why?

image001 (1).png

All responses Img

All responses (3)

Answers Img

Answers (1)

v-xiaochen-msft on 05 Aug 2022 at 06:50:17

Like (1)

Report

Re: Cant see tables in SQL Update row action

Hi @ppl ,

Maybe because the update operation requires the row id parameter... The primary key has the characteristics of uniqueness. : )

Best Regards,

Wearsky
ppl 404 on 05 Aug 2022 at 06:37:51

Like (0)

Report

Re: Cant see tables in SQL Update row action

@v-xiaochen-msft but why I see them in Insert row action?
Verified answer

v-xiaochen-msft on 04 Aug 2022 at 07:48:52

Like (2)

Report

Re: Cant see tables in SQL Update row action

Hi @ppl ,

Please make sure that your table has a primary key.

If the table doesn't have it , this action will not show this table in dropdown.

Best Regards,

Wearsky

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans