Unanswered

Option set and loookup fields not working

(0) Share

Report

Posted on by Greynir

Hi all

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Best regards,

Was this reply helpful? Yes No
Greynir 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-complex-entities

Please make sure you have owned PowerApps Plan 2 license or Microsoft Flow Plan 2 license at least for your sign in account.

Best regards,

Was this reply helpful? Yes No