Expecting string getting Object from API Call sent to Power Apps

(0) Share

Report

Posted on by RiskyBrass

Good Day:

I am sending the following back to Power Apps after using the select function in Power Automate.

I am getting an error message in Power Apps, after using the following formula to create a collection of the appointments to display in a vertical gallery:

ClearCollect(

colAppointments,

ForAll(

Table(ParseJSON(GetPatientAppointments.Run(Appointment_Date.SelectedDate, PatientID.Text).result)),

{

appointmentid: Value(Value.appointmentid),

appointmenttype: Value(Value.appointmenttype)

}

)

When I press the button it runs the flow successfully and returns the array of appointmentids and appointmenttypes. However, Power Apps displays the "Expecting String but got Object".

How do I change the flow or power apps expression to visualize each appointment in the gallery/collection variable.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Pstork1 69,649 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show a screenshot of how you have configured the Respond to Power Apps action? If you want to return an array of results to store in a table you need to use the HTTP response action. Respond to Power Apps can only send an object with specific simple properties, not an array of objects. If you are trying to use the new ParseJSON() function in Power Apps then the response needs to be a single object with a single text property.

Was this reply helpful? Yes No
RiskyBrass 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Pstork1,

Thanks for your reply. This is coming together!
Given your suggestion, I will try to use the HTTP response action to send the data back to Power Apps, rather than using the Respond to Power Apps action?

Thanks

Was this reply helpful? Yes No
Pstork1 69,649 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Ok, that all looks correct, but I think the casts you are doing in your Table are wrong. You are returning string values, but trying to cast them to values, not strings. You also aren't using ThisRecord. to identify the individual fields in the ForAll(). Try this code instead.

ClearCollect( colAppointments, ForAll( Table(ParseJSON(GetPatientAppointments.Run(Appointment_Date.SelectedDate, PatientID.Text).result)), { appointmentid: Text(ThisRecord.Value.appointmentid), appointmenttype: Text(ThisRecord.Value.appointmenttype) } ) )

Was this reply helpful? Yes No