Skip to main content

Notifications

Power Automate - AI Builder
Unanswered

Power automate to delete/append Postgresql table

Like (1) ShareShare
ReportReport
Posted on 13 Sep 2024 20:20:54 by 2
Hi All,

I am trying to delete existing table and updating a new table on Postgresql using power automate. Seems like there is no primary key on the Postgresql table. I am getting the below error. Any idea how to fix this? I table has a index column with unique number in each row, I am trying to use that a primary key, but it does not work.

"
The specified table has no primary key. Update and delete operations are not supported.
     inner exception: The specified table has no primary key. Update and delete operations are not supported.
clientRequestId: 055ca333-81c5-495e-8559-f33986dbf148
"

Thanks
Shab
Categories:
  • Suggested answer
    FLMike Profile Picture
    FLMike 27,286 on 14 Sep 2024 at 04:13:38
    Power automate to delete/append Postgresql table
    HI
     
    Its super straight forward the error tells you.
     
    1. You need a primary key for those actions (delete)
    2. Your table doesn't have  one
     
    so whats the solution
    Add One
     
    If this answers your question please mark the answer

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,654

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,440

Leaderboard
Loading complete