Answered

Add another option to option column sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

As the title says, lets say I have an option column with 8 options, this column is to show how well did people perform in the month

But lets say for example, I want to add a custom value in power apps, but not add it as an option in here, because its just for that month, how can I achieve this in power apps?

Am I explaying clear enough?

Thanks!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

If( Month(Today()) = 12, // set for the month you want to alter the choices Ungroup( Table( {_items: Table({Value: "December"})}, //Add the additional option here {_items: Choices(yourtable.yourchoicecolumn)} ), "_items" ), Choices(yourtable.yourchoicecolumn) )
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

If( Month(Today()) = 12, // set for the month you want to alter the choices Ungroup( Table( {_items: Table({Value: "December"})}, //Add the additional option here {_items: Choices(yourtable.yourchoicecolumn)} ), "_items" ), Choices(yourtable.yourchoicecolumn) )
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Use the following for the Items property of a dropdown control:

If( Month(Today()) = 12, // set for the month you want to alter the choices Ungroup( Table( {_items: Table({Value: "December"})}, //Add the additional option here, replace December {_items: Choices(yourtable.yourchoicecolumn)} ), "_items" ), Choices(yourtable.yourchoicecolumn) )