How to display Dynamics CRM option set in PowerApps as a dropdown

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello, I am relatively new to Dynamics and Power Apps. And I'm trying to accomplish a task and I'm not getting the expected result.

I have an entity in Dynamics CRM, for example, Opportunity entity. This entity form has some fields, like Currency and Purchase Process.

I am creating an App, using PowerApps, for editing an opportunity. Regarding currency, I was able to create a dropdown in PowerApps, using Currency table and lookups to show the currency name instead of its GUID. But for Purchase Process, that in CRM is an Option Set, I can't even show its values, I can't find a table where its referenced to use the same approach I've used in currency.

Does anyone have the same issue I am having here? I can not complete the opportunity editing without this field in my PowerApps application.

Appreciate any help! :)

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to display Dynamics CRM option set in PowerApps as a dropdown

Hello Mohamed Mostafa, thank you for your help.

I checked, and you are sure, the STRINGMAPBASE table stores the OptionSet values.

But regarding adding this information on my PowerApps app, I can't find this table.

Here are some pics to illustrate what I'm talking about:

In this first pic, as you can see, the currency displays the currency, and I even can select between euro and dollar for example.

My problem is when I am trying to do the same with an Option Set named Purchase Process, I can't find this table in the list of tables that PowerApps integrated with dynamics CRM source provide. I found the Currency and it worked as expected, but I don't know how to do it with an Option Set like Purchase Process
M I Mostafa 4,257 on at

Like (0)

Report

RE: How to display Dynamics CRM option set in PowerApps as a dropdown

Hi Evandro,

The option set is added as a field to the Opportunity entity form. i.e. it will show as a column in Opportunity table (if you were to access it as a table).

If you want to get the option set values, the table is STRINGMAPBASE. Have a look at the following post for details:

ashwaniashwin.wordpress.com/.../crm-2011-fetch-optionset-text-through-filteredstringmap-table

and this one:

mscrmtechie.blogspot.co.uk/.../get-optionset-values-from-crm-database.html

Thanks,

Mohamed