Hi @John_Martel ,
Could you please share a bit more about the formula you executed within your canvas app?
Do you mean your Azure function could return a single value (Text String value)?
Based on the OpenAPI JSON definition that you mentioned, I could not find any syntax error with it. Please make sure your whole OpenAPI definition file looks like below:
{
"swagger": "2.0",
"info": {
"version": "1.0.0",
"title": "MyAzureFunction"
},
"host": "azurefn.azurewebsites.net",
"paths": {
"/api/HttpTriggerCSharp1": {
"get": {
"description": "Calls my azure function over https",
"operationId": "RunThis",
"parameters": [
{
"name": "code",
"in": "query",
"description": "code",
"default": "h6ztu…[your code here]…i",
"type": "string"
},
{
"name": "name",
"in": "query",
"required": true,
"type": "string"
}
],
"responses": {
"200": {
"description": "Successful response",
"schema": {
"title": "The response of the api.",
"type": "string"
}
}
}
}
}
}
}
More details about the creating a custom connector based on Azure function, please refer to the following blog:
https://powerapps.microsoft.com/de-de/blog/using-azure-functions-in-powerapps/
Please check if the result your Azure function returned is always a Text string value. As an alternative solution, you could consider re-define your Azure function, to make it return a Object value. Then based on the modified Azure function, re-generate a new custom connector, check if the issue is solved.
Within your canvas app, please execute your custom connector action within Behavior property of a control, e.g. OnSelect property of a button, rather than Non-Behavior property of a control. Set the OnSelect property of a button to following:
Set(ReturnedValue, 'Custom Connector'.get-SingleOrMulti("xxxx"))
then check if the ReturnedValue variable is populated with proper value
Best regards,
