I've created a flow in Power Automate to insert data into a Databricks table using the HTTP connector.
I should mention that I don't have a Power Apps Premium license.
From Power Automate, the insertion works, but when I integrate the flow into Power Apps, the insertion doesn't work. This is the code I pass to Power Apps:
Set(response, Flow_1301.Run(
Value(TextInput1.Text), // id
TextInput1_1.Text, // name
TextInput1_2.Text, // description
Value(TextInput1_3.Text),// price
Value(TextInput1_4.Text),// quantity
DatePicker1.SelectedDate // creation_date
));
// Show the response received
Notify(
"Response: " & Text(response.status) & " - " & Text(response.message),
NotificationType.Information
);
// Check the response and show the result
If(
response.status = "Success",
Notify("insertion_ok", NotificationType.Success),
Notify("insertion_ko: " & response.message, NotificationType.Error)
);
The flow works from Power Automate, and the notification I receive from Power Apps is "insertion ok", but through Power Apps, the insertion doesn't happen.
Flow to write to Databricks works from Power Automate but not from Power Apps.
hi
We need to see a flow that you called from the Canvas App, what was the error, what actions worked and which ones failed.
Bring in pictures, validate exactly what you typed in the actions etc, and what you saw coming in, versus when you just test from Power Automate.
So from the Apps side, nothing I can say as it looks just fine "as it relates to calling a Power Automate from a canvas app", its all on the PA side that we need to see a run, and what that run did and how it failed etc.
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.