Hello developers,
I’m currently working on integrating PowerApps with a PostgreSQL database but facing some issues when trying to insert records. The problem seems to be around the enums and how the data is being handled.
Database Structure:
I have a table named Order in PostgreSQL with the following structure:
| Column |
Type |
Nullable |
Default |
| id |
integer |
not null |
nextval('Order_id_seq'::regclass) |
| title |
varchar(255) |
|
|
| status |
OrderStatus |
|
|
| fulfillmentStatus |
FulfillmentStatus |
|
|
| fulfillmentType |
FulfillmentTypes |
|
|
| docNumber |
text |
|
|
| date |
timestamp(3) |
|
|
| postedDate |
timestamp(3) |
|
|
| total |
double precision |
|
|
| createdAt |
timestamp(3) |
not null |
CURRENT_TIMESTAMP |
| updatedAt |
timestamp(3) |
not null |
|
| ... (other fields) |
|
|
|
Here, status, fulfillmentStatus, and other columns like paymentMethod, region are enums defined in PostgreSQL.
Enum Definitions (Example):
OrderStatus: ['Pending', 'Confirmed', 'Shipped', 'Delivered', 'Cancelled']FulfillmentStatus: ['Not Started', 'In Progress', 'Complete']
The problem,
I am using PowerApps to insert a record into this table using the following Patch function:
Patch(
'public.Order',
Defaults('public.Order'),
{
title: "New Order",
status: "Confirmed", // Enum value
fulfillmentStatus: "Complete", // Enum value
date: DateValue("2024-09-23"),
total: 120.50
}
);
I am passing the status as a string (e.g., “Confirmed”), which matches the enum defined in the PostgreSQL table. However, I keep encountering errors related to type mismatch:
Error I am getting,
"The type of column 'status' doesn't match the type of the column in the table."
I tried the following,
- I've confirmed that the values I’m passing for the enums match the exact strings defined in the database.
- I’ve tried using different formats (quoted strings, escaped values) but no luck so far.
- Tried escaping enum values (e.g.,
status: "\"Confirmed\""), but this also didn’t work.
- The record-saving operation keeps failing with a "Network Error" or a "type mismatch" error.
Has anyone successfully inserted records into a PostgreSQL table with enums from PowerApps? Any guidance on how to properly handle enum fields in this context would be greatly appreciated. Is there a specific format or function that I might be missing when passing enum values from PowerApps?
Thanks in advance for any suggestions or tips!
