Answered

Show/Hide Field based on combo box selection

(0) Share

Report

Posted on by autumn

Hello, I can't seem to get this to function and could use some guidance. We have a field called "Invoice Delivery Method" (DataCardValue45) with two choices - Print and Manual E-Bill.

If Manual E-Bill is selected, we would like the E-Bill Email Address text field to be both visible and required. Seems simple enough, and all of the answers I find point to the same formula, but it's not working. I have tried this formula on both the Visible and the Required property of the E-Bill Email Address Data Card, but I keep getting an error.

If(DataCardValue45.Selected.Value="Manual E-Bill",true,false)

The error just indicates the field types don't match, which I already know. They shouldn't have to, right? Where am I going wrong?

Categories:

Using Apps Using Formulas

Untitled.png

All responses (4)

Answers (1)

autumn 9 on at

Like (1)

Report

Re: Show/Hide Field based on combo box selection

The third one worked!! Thanks!
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Re: Show/Hide Field based on combo box selection

Hi @autumn

All these works for me. Can you try these

First(DataCardValue45.SelectedItems).Value="Manual E-Bill" OR DataCardValue45.Selected.Value="Manual E-Bill" OR Text(DataCardValue45.Selected.Value) = "Manual E-Bill"
autumn 9 on at

Like (0)

Report

Re: Show/Hide Field based on combo box selection

It is Choices('Invoice Delivery Method') from Dataverse.

I receive the same error when using your code on the E-Bill Email Address control.
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Re: Show/Hide Field based on combo box selection

Hi @autumn

What is the Items property of DataCardValue45? Is it the Choice field in Shapepoint?

If it's a choice field then
DataCardValue45.Selected.Value="Manual E-Bill"