Unanswered

No Field Groups are created for my CDS entities created by importing from SQL Server

(0) Share

Report

Posted on by ricke

Hi, I'm trying to get lookup tables working in my PowerApp. I used the New Entities from Data feature to create new entities based on tables imported from an Azure SQL Server database. The entities get created OK but I have no field groups created which I think I need to get lookups to work. I created relationships between my parent table (People) and 2 other tables also now entitities where I would look up things like someones title and team based on a PositionID and SolutionAreaID in the People table.

I used the create app automatically from data feature to build my app, but the BrowseScreen just uses the ID fields and I can't get them to display the LookUp values instead I think because I don't have the Field Groups populated.

Any idea what might be wrong?

Thanks,

Rick

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi ricke,

So you have created new entities from data successfully, and now you are trying to create relationships between the newly created entity and two other tables. Have you created the lookup relationship successfully?

You said that there is no Field groups on the entity, could you show me a screenshot for this?

On gallery of the app you created from data, besides the ID field, could you show other fields? Such as text field, number field but not the lookup values.

Have you tried with other data bases such as SharePoint list, Excel, etc. to test this issue on your side?

Reference about how to create new entities in the Common Data Services:
https://powerapps.microsoft.com/en-us/tutorials/data-platform-cds-newentity-pq/

Best regards,
Mabel Mao

Was this reply helpful? Yes No
ricke 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi I really want to reply to this but I have a response with a lot of screenshots embedded to illustrate my issues and I can't find any obvious way to include that info. Can I upload a PDF with my reply?

Thanks,
Rick

Was this reply helpful? Yes No