Azure Function App The data returned in the response is invalid

[JhonatanRS]

Hi team 🙂

I am a beginer in PowerApps so, I waste two days and cannot solve my problem.

I Create a basic Function App on Azure it returns a string:

then I created my connection in PowerApps connection and tested it, everithing seems that is OK.

However when I Use my function in my app in the onselect of a button i receive an error:

my code on select button is:

I am trying to asign the string that i get from my function to "Azvar" variable, but it is not working,

the swagger file looks:

do you have any idea to fix this problem?

thanks in advance

[v-xida-msft]

Hi @JhonatanRS ,

Could you please share a bit more about the Response body JSON schema you specified in your Custom connector action?

Do you use API Key as Authentication way in your Customer connector?

Based on the OpenAPI definition file you provided, I could not find any error syntax error within it. Please check if you have provided proper Response JSON Schema withim your Custom connector action.

If you use API Key as Authentication way in your Custom connector, there is an known limit -- When using an API key, we recommend not testing the connector immediately after you create it. It can take a few minutes until the connector is ready to connect to the API.

https://docs.microsoft.com/en-us/connectors/custom-connectors/define-openapi-definition#test-the-con...

More details about creating a customer connector based on Azure Function, please check the following blog:

https://powerapps.microsoft.com/de-de/blog/using-azure-functions-in-powerapps/

Best regards,

[JhonatanRS · Accepted solution]

well, after intensive research I didn't solve it I think that it is related on the way that PowerApps require the information, so to go ahead with my scenario, I change the strategy and now I am using Flow to invoke and get values exactly as Power Apps needs

I

I hope it helps someone else and if anybody knows a better solution, please share it 🙂

have a great one!

[7d3dev]

I kept getting this same problem.

In the end I configured my Azure function to return the data in json e.g. {"CustomerStatus":"Valid"}

After updating the swagger file and importing into PowerApps I was able to get the data via 

[MyConnection].[InvokeAzureFunction](CustomerName).CustomerStatus

Hope this helps.

[JhonatanRS]

Great!! it is helpful! Thanks 7d3dev I'll try