Drop down choices from column list in SP

(0) Share

Report

Posted on by Charlie Martharper

372 Season of Giving Solutions 2025

Hi guys!

So I want a drop down in an App that gets the choices from the column type choice in the sharepoint list.

When adding the data into the App, the column named "AGA" doesn't appear, so I don't really know how to link the column into that drop down. I would also need to be blank or have a grey text like "Add here..."

How could I do it?

Categories:

Connector development

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Kalathiya 472 on at

Like (1)

Report
Copy link

Link copied!
Hello @Charlie Martharper,

Drop down Item Property: Use this formula to pull the choices from the column

Choices([@'SharePointListName'].'AGA') //SharePointListName - replace this with your sharepoint list name

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.

Was this reply helpful? Yes No
Charlie Martharper 372 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Perfect!! Thank you so much @Kalathiya

It appears the options of the column. The thing now is, how to get a text like "Write here..." in grey color instead of a choice:

So people guides and don't have an option written already.

Was this reply helpful? Yes No
Verified answer

Kalathiya 472 on at

Like (1)

Report
Copy link

Link copied!

@Charlie Martharper, Great!

In that case you need to use Combobox instead of Dropdown control. There have Property for set the placeholder.

Was this reply helpful? Yes No
Charlie Martharper 372 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

Nice @Kalathiya! That worked too for the choices one. But I have an error in a combo box when trying to get the options. There aren't choices, just text, but it doesn't appear.

Look this is how it looks one of the combo box that depends on the first one:

But when clicking in the box, nothing appears, example below:

Should I add anything more? What am I missing?

Was this reply helpful? Yes No