Answered

Set dropdown to the same selected value as another dropdown when a toggle button is clicked

(0) Share

Report

Posted on by lras1202

Hi,

I have dropdown A, dropdown B and a toggle button. I need to have dropdown B selected value same as dropdown A when the toggle button is clicked.

On Default dropdown B: If(togglebutton.Value,dropdownA.Selected.Value, ThisItem.OwnerGender)

On Items dropdown B: Choices(sharepoint list.OwnerGender)

I got "The function "If" has invalid arguements".

Thanks for helping.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Try
: If(togglebutton.Value,dropdownA.Selected.OwnerGender)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
lras1202 52 on at

Like (0)

Report
Copy link

Link copied!

The error is : "Expected record value"

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Change it to
Try
: If(togglebutton.Value,dropdownA.Selected.OwnerGender.Value)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
lras1202 52 on at

Like (0)

Report
Copy link

Link copied!

Same "Expected record value", actually dropdownA.selected.ownergender is not a valid selection, only Value.

If(togglebutton.Value,dropdown.Selected.Value, ThisItem.OwnerGender) ThisItem.OwnerGender is what needs to be when the toggle button is not selected.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Are the dropdown inside a Gallery?

You can try a variable:
OnSelect of the dropdown;
Set(VarSelected,dropdownA.Selected.Value)

Then in DropdownB
If(togglebutton.Value,VarSelected)
Or
If(togglebutton.Value,VarSelected.Value)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
lras1202 52 on at

Like (0)

Report
Copy link

Link copied!

Not in the gallery, just on the Edit form.

Tried your formula, still getting "Expected record value"

Was this reply helpful? Yes No
Al_10 1,691 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

what if you try:

If(togglebutton.Value, {Value: dropdownA.Selected.Value}, ThisItem.OwnerGender)

Was this reply helpful? Yes No
lras1202 52 on at

Like (0)

Report
Copy link

Link copied!

Still getting the same error. But this formula works:

If(togglebutton.Value,dropdownA.Selected.Value,ThisItem.OwnerGender.Value)

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @lras1202 :
Could you tell me:
What are dropdown A and dropdown B?Combo box or Drop down control?
Does OwnerGender allow multiple selections?
Does dropdown B allow mutiple selections?(If it is a combo box)
What is dropdown A 's Item property?
Case1:I assume dropdown B is a DropDown control(do not allow multiple selections) and OwnerGender do not allow multiple selections.
Please try:
On Items dropdown B:
Choices(sharepoint list.OwnerGender)
On Default dropdown B:
If(togglebutton.Value,dropdownA.Selected.Value, ThisItem.OwnerGender.Value)
Case2:I assume dropdown B is a Combo box control(do not allow multiple selections) and OwnerGender do not allow multiple selections.
Please try:
On Items dropdown B:
Choices(sharepoint list.OwnerGender)
On DefaultSelectedItems dropdown B:
If(togglebutton.Value,LookUp(Choices(sharepoint list.OwnerGender),Value=dropdownA.Selected.Value), ThisItem.OwnerGender)
Best Regards,
Bof

Was this reply helpful? Yes No
lras1202 52 on at

Like (0)

Report
Copy link

Link copied!

Hi, @v-bofeng-msft ,

Both DropdownA and Dropdown B are dropdowns, all not allowing multiselect.

Your Case1 is the solution! It works!

Thanks again for helping.

Was this reply helpful? Yes No