Setting Drop Down items based on multiple Yes/No Columns

Like (1) Share

Report

Posted on 15 Mar 2025 17:11:42 by AndrewManning

I'm not sure how I would do this.

I have a SharePoint list. The list has a unique People field. It has multiple columns including columns that are named Budget1, Budget2, Budget3. The budget columns are Yes/No type.

On App Startup takes the logged in user and sets variables from the list. This works for the other columns fine.

I want a drop down box that will list each column name where the Budget* column is YES.

For example:

user<at>email.com Budget1 = YES, Budget2 = NO, Budget3 = YES.

The drop down should show Budget1, Budget3.

The column names may increase in future so ideally I want to search for any column that starts with "Budget" rather than add each one manually to any code

Categories:

Using Apps Using Formulas

All responses (2)

Answers (0)

Michael E. Gernaey 36,186 Super User 2025 Season 1 on 15 Mar 2025 at 21:54:01

Like (0)

Report

Setting Drop Down items based on multiple Yes/No Columns

@vipuljain03

They didnt want to hardcode any names in although i do agree with your code, it would work.

I think @AndrewManning is looking for something dynamic. Which requires you more to either

A) have a list of field names stored somewhere, that you can grab and use that as a way to get it

B) use the HTTP SharePoint to call get the field names, filter on ones with Budget then grab the value, then using the output of that in your combobox.
Suggested answer

vipuljain03 306 on 15 Mar 2025 at 19:04:11

Like (0)

Report
Setting Drop Down items based on multiple Yes/No Columns

1. Modify the App OnStart property:

Set(varUserData, LookUp(SharePointList, PeopleColumn.Email = User().Email) );

2. Extract Budget Columns:

ClearCollect( colBudgetColumns, If(varUserData.Budget1, {ColumnName: "Budget1"}), If(varUserData.Budget2, {ColumnName: "Budget2"}), If(varUserData.Budget3, {ColumnName: "Budget3"}) );

Note: If you anticipate more columns in the future, you will need to update this list manually.

3. Bind to dropdown:

Set the Items property of dropdown to: colBudgetColumns

Set the Value property of dropdown to: ColumnName