Unanswered

Writing back to AWS RDS PostgreSQL using Power Apps

(0) Share

Report

Posted on by aqeelwilliams

Hi everyone,

I want to create a Power App that sits within Power BI online, and is connected to a PostgreSQL database sitting in an AWS RDS environment. The Power App is connected via a gateway.

I want to use the app as a form to update fields in the table, but when I add fields to the form, it only gives me the option to view values and not to edit (I tested this with an Excel sheet in the OneDrive for Business cloud environment, and it defaults to that option). I also see in the description of the PostgreSQL connector, it says "Connect to on-premises PostgreSQL database to read data from tables." For other connectors, MySQL and Excel for example, they mention read, write, update, etc.

Does this mean I cannot write to my PostgreSQL database, or is there a setting I need to change? And if I can't are there other ways around this?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

timl 37,154 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@aqeelwilliams

I'm pretty sure it's possible to write to PostgreSQL with the setup that you've configured.

One thing to note is that the PostgreSQL tables must have a primary key column. Without this, Power Apps will connect to the table in read only mode. It's also worth noting that PostgreSQL doesn't support writing to tables with an autoincrement primary key column.

Was this reply helpful? Yes No
aqeelwilliams 5 on at

Like (0)

Report
Copy link

Link copied!

Amazing, thank you so much. Once I defined a primary key in my table it actually loaded and allowed me to change the Control Type for each field to edit!

Will still have to check whether the updates on the Power Apps side feed through to the table...

Was this reply helpful? Yes No