Unanswered

BC VIrtual Tables and empty forms

(0) Share

Report

Posted on by antonhh

Hi there

I have for 2 days tried to resolve this issue on my own but I am at a complete loss here. The scenario I am trying to achieve is selecting an item from a list and use the view action of the list to get additional information from selected item.

With Dataverse table there is 0 issue but I want to use BC Virtual Table, specifically I am trying to use the standard access to Items from Business Central.

There is no issue for the most part when setting this up but when I view form (additional information) of the selected item I get an empty form.

From what I have researched about his issue is that if Id column is primary column it should work but given that information I tried using the primary column method with the column displayName, but to no avail.

Apart from this I have configured everything like instructions say but dont get the desired result.

Has anyone had this issue and resolved it? Any help would be highly appreciated.

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

Sort by

David VC 4 on at

Like (0)

Report
Copy link

Link copied!

Hi antonhh,

I'm new to Power Pages, and I'm having the same issue. in my case I'm using Dynamics365fo Virtual Entity. Viewing/Editing data works fine for newly created DV tables, but I'm not able to get related row info. for a given record in a list from D365fo entity.
I've also tried to use Id parameter as well as primary key field, but no results are shown. I guess we're missing something here but I haven't been able to found it yet...

Here is the automatic guid unique identifier from the entity:

Here is the unique identifier from the table

This is the list setup:

List setup showing parameter 'Id'

Edit form setup (the same setup applies to View form but ReadOnly mode):
Edit form parameter 'Id'

When I'm opening a form (Edit/View) using a new page, it seems that the 'Id' parameter is being sent correctly, since I can see the parameter Id in the page url, but no data is shown in the forms:

Edit forms url showing the 'Id' parameter
https:\\portalexample.xxx.com/Audit-View-details/?id=0000554b-0000-0000-0000-005001000000

In addition, If I look for the the given 'Id' in the entity data I'm able to find the associated record.

Let's see if someone can help us...

Was this reply helpful? Yes No
antonhh 35 on at

Like (0)

Report
Copy link

Link copied!

Yeah, we seem to be having the same problem. I sure hope we can get some help with this.

Was this reply helpful? Yes No
oliver.rodrigues 9,453 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi, are you trying to setup the integration using this?: Power Pages on virtual tables - Business Central | Microsoft Learn

Was this reply helpful? Yes No
antonhh 35 on at

Like (0)

Report
Copy link

Link copied!

Yes, I was following these instructions listed in the link you displayed, but it does not seem to work for me. Could it be a Region based issue?

Was this reply helpful? Yes No
oliver.rodrigues 9,453 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

I know this feature is in preview, so not sure if it's been rolled out by region.

I would suggest opening a support ticket with Microsoft for clarification.

Was this reply helpful? Yes No
antonhh 35 on at

Like (0)

Report
Copy link

Link copied!

Hi it seems to work fine for me now for some reason using query with id as parameter. How are things at your end!

Was this reply helpful? Yes No
David VC 4 on at

Like (0)

Report
Copy link

Link copied!

Hello @antonhh !! Its working fine for me aswell.. Didn't change anything, still using query Id as parameter...
Power Pages mysteries...

I'm glad the issue got solved for you too!

Was this reply helpful? Yes No