Answered

Conditionally Hidden Field Help on a SharePoint List Form - When Editing

(0) Share

Report

Posted on by harveysm

Hello - I have a SharePoint List form that has 2 fields within it that are location/branch. When a user selects X location, a new field displays with a branch selection. The branches only exist for one location. So I'm just hiding the branch field using the following code: If(ComboBox1.Selected.Title="XXX",true, false). This seems to work fine with no issues.

My issue is that if a user edits an entry the location still shows correctly with what was selected. But the branch field is not visible again. Now, if they re-select X location, the branch they entered is still there. But I can't figure out why on edit the branch field isn't showing correctly.

Any help would be awesome. Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I tested this and didn't have the same issue you are experiencing. Is your CombBox a multi-select by any chance? Is there a specific reason you are using a combobox rather than a dropdown?

Was this reply helpful? Yes No
harveysm 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah, it is a multi. I'm using a combobox because people have the option to type something else in if none of the locations work for them.

Thanks!

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I think it has to do with how the multi-select works. Try this workaround.

In the OnChange of your ComboBox set (or add) this formula

Set(varXXX, Concat(ComboBox1.SelectedItems, Title & ", "))

Then Filter your dropdown like so:

Filter(DataSource, Title in varXXX)

Was this reply helpful? Yes No