web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / No puedo recuperar ni ...
Power Apps
Unanswered

No puedo recuperar ni consumir datos en powerapps de una api expuesta creada en Visual Studio Code para Business Central.

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Buenas tardes.

 

He creado un conector personalizado en powerapps asociándolo a una api expuesta creada en Visual Studio Code para Power Apps. Sin embargo, no puedo recuperar ni consumir los datos en PowerApps tras crear una página tipo lista y agregando los datos correspondientes al conector. En la fórmula de PowerApps empleo la siguiente función:

 

Pruebalisthistalbventa.Getpruebalisthistalbventa("4f10685f-de79-4e3c-a581-ff5cba591b97").value

 

Dónde pruebalisthistalbventa es el nombre del conector, getpruebalistahistalbventa es el id del conector, el id qué es el de la empresa de Business Central y .value para recuperar los datos.

 

Espero vuestras respuestas para solucionar este tema, ya que no consigo resolverlo.

 

Muchas gracias.

 

Sergio

Categories:
Connector development
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Buenos días.

     

    El origen de datos es un conector personalizado originado a partir de una página api creado en Visual Studio Code para Business Central (Sales Shipment Header).

     

    Al poner la siguiente fórmula, la cual he cambiado el .value por & value, me devuelve el siguiente error (se esperaba un valor Table)

     

    Fórmula: Pruebalisthistalbventa.Getpruebalisthistalbventa("4f10685f-de79-4e3c-a581-ff5cba591b97") & value

     

    Error:

    scarpintero_0-1625639196245.png

     

     

    He comprado la conexión y no me da error en probar el conector, aunque en la respuesta de la definición no me aparecen los campos que he creado en la api. He puesto en el encabezado lo mismo que me aparece en la página de probar y en el cuerpo no me deja poner lo mismo que me aparece cuando pruebo el conector porque sobrepasa el límite de caracteres permitidos.

     

    scarpintero_1-1625639196259.png

     

     

     

    scarpintero_2-1625639196278.png

     

     

    scarpintero_3-1625639196282.png

     

     

    ¿Cómo tengo que proceder y actuar para poder ver y recuperar los datos de la api en powerapps?

     

    Gracias.

     

    Sergio

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Ok, sorry. I write in English and I send you new photos.

     

    Good Morning.

 

The data source is a custom connector originated from an api page created in Visual Studio Code for Business Central (Sales Shipment Header).

 

When I put the following formula, which I have changed the .value to & value, it returns the following error (a Table value was expected)

 

Formula: 
    Pruebalisthistalbventa.Getpruebalisthistalbventa("4f10685f-de79-4e3c-a581-ff5cba591b97") & value

    scarpintero_0-1625641610071.png

     

     I have compared the connection and it does not give me an error in testing the connector, although in the response of the definition the fields that I have created in the api do not appear. I have put in the header the same thing that appears in the test page and in the body it does not let me put the same thing that appears to me when I test the connector because it exceeds the limit of allowed characters.

    scarpintero_1-1625641846979.png

     

    scarpintero_2-1625641909393.png

    scarpintero_3-1625641985789.png

     

    How do I have to proceed and act to be able to see and retrieve the api data in powerapps?

 

Thanks.

 

Sergio

     

     

     

     

     

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans