No Field Groups are created for my CDS entities created by importing from SQL Server
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.
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?
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?