Update Choice dropdown with if statement

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

This is my ITems property of my dropdown:

If(DataCardValue48.Text = "Approve", Choices([@'data source'].Status_two) ,Choices([@'data souce'].Status_two))

How can I do this -

If(DataCardValue48.Text = "Approve", Choices([@'data source'].Status_two) = "Complete" ,Choices([@'data souce'].Status_two))

I get an error on this.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @wonka1234 ,

Can you please explain in plain text what you are trying to achieve? Unfortunately it is not clear from the formulas you posted.

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer

Trying to update a choice dropdown in my powerapp based on another field.

So if field a datacard = "Complete" then make the dropdown a certain choice. if not, leave the original choice there.

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wonka1234 ,

In that case I hope the below is of help:

If( DataCardValue48.Text = "Complete", Choices([@'data source'].Status_two), //Items for when the value is complete Choices([@'data souce'].Status_two) //Items for when the value is not complete )

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@wonka1234,

This is a poorly written question.

Assuming:

Your data source is Dataverse (judging by your Choices syntax)

You're using a Form

You want to set the default choice displayed in the dropdown only when the Form is in New Mode.

Apply the below to the Default property of the DataCard (not the DataCardValue).

If( Form1.Mode = FormMode.New, Switch( DataCardValue48.Text, "Approve", 'Your Choice Field'.'Your Choice Value', "Complete", 'Your Choice Field'.'Your Choice Value' ), ThisItem.'Your Choice Field' )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik do i need the form modes? Hopefully this adds more clarity..

If DataCardValue48 = Approve

Then update my STatus Card (DAtaCardValue_49_1)

Currently ITems Property of this card -

If(
DataCardValue48.Text = "Approve",
Choices([@'DataSource'].Status_two),
Choices([@'DataSource'].Status_two)
)

these are my 3 choices.. if my date change approval = approve, make this Complete. if not approve, leave the status as is..

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@wonka1234 - I do not know if you need the check the Form Mode. The above example I gave based on some assumptions I made due to the lack of clarity from your description.

Once again:

What is your data source. Is it Dataverse?

Should the Status field only update when the Form is in New Mode?

Was this reply helpful? Yes No