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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issues creating Power ...
Power Apps
Unanswered

Issues creating Power Apps Tables using Import Data, OData

(0) ShareShare
ReportReport
Posted on by

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.

 

CFOANALYST_0-1681424870804.png

CFOANALYST_1-1681424894721.png

CFOANALYST_3-1681424966319.png

 

 

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. 

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    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...

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard