Unanswered

Preselect value based on another field value

(0) Share

Report

Posted on by Poweruser811

I would like to preselect drop down menu from DataCardValue12 to select "A" when the DataCardValue11 is equal to "Closing," otherwise leave it blank for the user to select.

this is what I have so far.

OnSelect:

If(DataCardValue11.Selected.Value="Closing", "A",blank())

any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Cat Schneider 488 Most Valuable Professional on at

Like (0)

Report
Select the Combobox (DataCardValue12), and edit the Default Property:
If( //To ensure the value for the record is not accidentally overwritten !IsBlankOrError(Parent.Default), Parent.Default, //To set the default selected value of the Combobox to "A" if DataCardValue equals "Closing" DataCardValue11.Selected.Value = "Closing", {Value: "A"} )
Then edit the Reset Property:
updtValue

Then select the Combobox (DataCardValue11), and edit the OnChange Property:
If( Self.Selected.Value = "Closing", UpdateContext({updtValue: true}); UpdateContext({updtValue: false}) )
This will then only reset the default value of DataCardValue12 if DataCardValue11 is changed to "Closing", otherwise, DataCardValue12 will remain the value it started as or that the user has selected since they began editing the record.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Poweruser811,

Could you please tell me that how you set the Items property of the DataCardValue12?

Are both DataCardValue12 and DataCardValue11 ComboBox or Dropdown?

If they are both ComboBox, you need to set the DefaultSelectedItems property of DataCardValue12 as:

If(DataCardValue11.Selected.Value="Closing", {Value:"A"},{})

Here I assume that you set the DataCardValue12 Items property as Choices() function.

If they are both Dropdown, you need to set the Default property:

If(DataCardValue11.Selected.Value="Closing", "A","")

Note that you need to set the AllowEmptySelection property of the dropdown control as true.

Was this reply helpful? Yes No
Poweruser811 34 on at

Like (0)

Report

Both fields are drop down menu.

Was this reply helpful? Yes No
Poweruser811 34 on at

Like (0)

Report

I'm having an error with the first part:
If(
!(Parent.Default),
Parent.Default,
DataCardValue11.Selected.Value = "Closing",
{Value: "A"}
)

is this how its supposed to look?

Was this reply helpful? Yes No
Cat Schneider 488 Most Valuable Professional on at

Like (0)

Report

You're missing BlankOrIsError in your formula. Try:
If(
!BlankOrIsError(Parent.Default),
  Parent.Default,
  DataCardValue11.Selected.Value = "Closing",
  {Value: "A"}
)

Was this reply helpful? Yes No
Poweruser811 34 on at

Like (0)

Report

It wont take,
If(
!(Parent.Default),
Parent.Default,
DataCardValue11.Selected.Value = "Closing",
{Value: "A"}
)

Was this reply helpful? Yes No
Cat Schneider 488 Most Valuable Professional on at

Like (0)

Report

That is correct. You should be getting an error when you enter:
If(
!(Parent.Default),
  Parent.Default,
  DataCardValue11.Selected.Value = "Closing",
  {Value: "A"}
)

That is because you did not include the BlankOrIsError function that would give you the boolean value necessary for the first argument of the If function.

If you want the function to work, you need to include the BlankOrIsError function between the ! and ( just like I have below:
If(
!BlankOrIsError(Parent.Default),
  Parent.Default,
  DataCardValue11.Selected.Value = "Closing",
  {Value: "A"}
)

Was this reply helpful? Yes No
Poweruser811 34 on at

Like (0)

Report

That's strange, I had it in there. I tried it again and still getting an error message.

Was this reply helpful? Yes No
Cat Schneider 488 Most Valuable Professional on at

Like (0)

Report

What type of control is DataCardValue12? and what is the Items property value?

If DataCardValue12 is a Dropdown control and not a Combobox control, you will need to swap out the record value and simply use "A". Meaning you would use:
If(
!BlankOrIsError(Parent.Default),
  Parent.Default,
  DataCardValue11.Selected.Value = "Closing",
  "A"
)

Let me know if that works or if you are still getting an error.

Was this reply helpful? Yes No
Poweruser811 34 on at

Like (0)

Report

They are both drop down menus. Do I need to set up the values first?

Was this reply helpful? Yes No