Answered

Dropdown box items property

(0) Share

Report

Posted on by alec

I'm playing with the case example application. On the edit screen I've deleted "origin" and added the "account" datacard. I want to select the account from a list that comes from an excel file on one drive.

I add the excel file OK and it appears as Table1. In the post I was reading on how to do this it says go to the drop down properties and set "items" to Table1.AccountName.

But I cant find the "items" property for the dropdown box? (Initially I changed the "origin" drop down items to show my list which showed my items, but when I deleted the case "origin" datacard and added the account datacard, the drop down does not have an items property. Nor can I see where it gets its AC001, AC002,.... values from)

I'm clicking the datacard, then the drop down so it has the size handles shown, then in the designer I'm looking for "items" property in "properties" and "fx advanced".

I'm using the web deisgner on IE11.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @alec,

Is this issue only happening when the dropbox is inside a form? If we add the dropbox outside, will the issue occurs?

Regards,

Mona

Was this reply helpful? Yes No
Verified answer

alec 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mona
The cause is that in the common data service template "case", the accounts field is defined to take values from a look up. That is where the AC0001 ... is coming from. (If this is highlighted in the web studio form properties, I don't see it)
As a result the web studio does not show the "items" property that I expected.
My work around was to add my own "account" field to "case" in CDS that i called "accountg" that I set as a 100 charcater text field. Then in studio I added a custom card for accountg and then I added a dropdown to this card. That dropdown has an "items" property that I connected to my Excel table 🙂

Thanks for following up

Was this reply helpful? Yes No