Update Choice dropdown with if statement

(0) Share

Report

Posted on by wonka1234

909 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.

All responses (6)

Answers (0)

Ami K 15,665 Super User 2024 Season 1 on at

Like (0)

Report
Re: Update Choice dropdown with if statement

@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?
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Update Choice dropdown with if statement

@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..
Ami K 15,665 Super User 2024 Season 1 on at

Like (0)

Report
Re: Update Choice dropdown with if statement

@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
BCBuizer 21,999 Super User 2025 Season 1 on at

Like (0)

Report
Re: Update Choice dropdown with if statement

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 )
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Update Choice dropdown with if statement

@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.
BCBuizer 21,999 Super User 2025 Season 1 on at

Like (0)

Report

Re: Update Choice dropdown with if statement

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.