I hava a simple power app with a few "simple text" fields. The app is just the form and a submit button. Press the button and the record is created as a lead in D365.
I added a couple of new fields, lookup and options set in D365 and added them to the form. The fields "data type" is set as string so none of the options (or lookup) is showing when I try to add data to those fields.
What would be the best practice to solve this?
Hi @Eraserhead ,
Could you please share a bit more about the issue?
Do you mean the Option Set field and Lookup field acted as String type in your Edit form rather than "Complex" type?
Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Actually, it is not necessary to add D365 connection in your app, instead, you should add corresponding CDS Entity as data source into your app.
Note: The D365 Entity is based on CDS Entity, which is in same PowerApps Environment (D365 instance).
Please consider take a try to generate a new app based on the corresponding CDS Entity, then check if the issue is solved. In additon, please make sure you have refreshed the data source manually in your app after you add a couple of new fields to your Entity.
Hi Kris Dai
This is how I set this up:
1. I went to data sources and searched for Dynamics365. I added that data source and chose "Leads" as the entity.
2. I added a "edit form" and automatically got the lead entity fields. I also got the new 2 custom fields a had created.
3. I then added a submit button.
4. When I go to edit mode for this app both custom fields, the one with option set and the one with lookup work as basic text fields. I get no drop-down with options or lookup.
I need both those fields to show the same information as in D365.
Hi @Eraserhead ,
Have you taken a try with the solution I provided above? Using CDS Entity as data source instead of D365 Entity
Which PowerApps license do you have for your sign in account?
Based on the needs that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Currently, within PowerApps, the Leads Entity is a Complex Entity, which contains complex server-side logic. If you want to access Complex Entity (from CDS or D365) in PowerApps app, you must own PowerApps Plan 2 or Microsoft Flow Plan 2 license at least.
Please refer to the following article for more details:
Please make sure you have owned PowerApps Plan 2 license or Microsoft Flow Plan 2 license at least for your sign in account.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand