Custom Connector to Business Central returns no data in a canvas app but does for Power Automate? 🤷‍♂️

(0) Share

Report

Posted on by JAngle

Created a custom connector for a Business Central API page. All is good at the point of testing the connector:

When I add this connector to a canvas app I get no data but I do get the structure of the JSON:

If I use the custom connector in Power Automate I get a valid response with a full payload of JSON:

What am I missing here?

I've played around with the CompanyID parameter as that is fundamental like passing it into the PowerApp formula as {CompanyID: "<string>"} but then the formula won't accept the value and it errors....

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

JAngle 17 on at

Like
a
(0)

Report
Copy link

Link copied!

I have since this suggestion from a previous post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Custom-Connector-works-in-Flow-Power-Automate-but-not-in-my/m-p/397617

upon trying this I get an invalid response in PowerApps when no parameter is passed?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JAngle

Can you confirm if you have defined the output schema in the custom connector action definition? Also, are you getting any error when you click the button control in the canvas app after passing the required parameter? If you can share more details, we might be able to help you better.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
JAngle 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes I have an output schema defined. Can be seen in the test screen grab I have. No error if I pass the required parameter in the defined format (text).

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JAngle

Thank you for sharing the details. If the parameter value that you are passing is going to be same, can you try to set it as default in the action definition and then trigger the custom connector?

I came across a thread which can be helpful in this: https://powerusers.microsoft.com/t5/Building-Power-Apps/Custom-Connector-works-in-Flow-Power-Automate-but-not-in-my/td-p/397617

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

JAngle 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Resolved this by adding the full URL to the GET command that is setup in the connector. This goes against explanations I’d seen on videos and read on blogs, however it seems like the done thing on none business central custom connectors. Done it a bunch of times since so it’s certainly the way to go.

Was this reply helpful? Yes No