I am having trouble creating Power Apps Tables using the Import Data, Connect a data source, Odata. See below example where the table data populates for one OData feed but not the other. I can confirm both feeds point to tables with data in them (they work in excel) I also included the procedure I used below. I am trying to connect to my Business Central data to Power Apps.
1 Power Apps
2 Import Data
3 (choose a data source) OData
4 (connection settings) connection: create new connection, name: "email", Data gateway: (none), authentication: Org account
5 (Power Query) no modifcations to the power query screen, enters NEXT
6 (MAP TABLES) Load to new table, Table name: PO Lines, Table display name: PO Lines unique primary name column: "Document_no" default Alternate Key: (none) NEXT
7 (refresh settings) refresh automatically, every thirty minuites, starting now PUBLISH
Every time I do this for PO lines the table is blank as shown. The exception is somehow I setup the items table... any assistance is greatly appreciated and will help my business.
Hi @CFOANALYST ,
One thing I am thinking is since it is PO Lines, do you have the PO Header table? I am thinking that it requires the PO lookup value and it can not resolve this if you haven't loaded the POs first? Just a thought...
stampcoin
17
mmbr1606
15
Super User 2025 Season 1
ankit_singhal
11
Super User 2025 Season 1