Answered

Drop Downs from Excel

(0) Share

Report

Posted on by VW-07081449-0

Hi All,

I have made a app for recording meeting times. So the app is populating/pulling from an excel table. I wanted to use data validation in excel to have options in a drop down. When i try and use that on my app it does not allow the drop down option. I have been using the new 'form' option in power apps to have my data, and I tried to use a vertical gallery but again didn't allow me to choose specific options. Does anyone know how I can do that?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

opticshrew 193 on at

Like (0)

Report
Copy link

Link copied!

I don't believe the connector observes data validation rules, instead you could use a list of values.

("Value1", "Value2", "Value3", "Value4")

I might have the brackets wrong, but generally that's the approach I would take.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @vwemyss,

I want to explain to you that a GENERAL column from excel table will only generate a TextInput control in the form control.

If you want to replace the TextInput control with a dropdown control, you need to unloack the data card and delete the original TextInput, then insert a drodpown control instead.

Set the dropdown's Items property as Distinct(TableName.FieldName), Default property to Parent.Default.

Set the Update property of the card to Dropdown1.Selected.Value

Was this reply helpful? Yes No