I have 2 drop-down fields (DataCardValue14 & DataCardValue15) and they contain options starting with numbers such as 1,2,3,4,5, etc..
and based on the selection of above 2 dropdowns >> i need to select the value of a third drop down >> so inside the 3rd dropdown i added this formula inside the Update field:-
If(StartsWith(DataCardValue14.Selected.Value,"1") && StartsWith(DataCardValue15.Selected.Value,"1"),"Low","High")
as follow:-
but i got this error:-
StartWith has some invalid arguemnts
Any advice?
Solved! Go to Solution.
Assuming the field you are trying to update is a choice column.
Change your formula to the following:
{Value:
If(
StartsWith(DataCardValue14.Selected.Value,"1") &&
StartsWith(DataCardValue15.Selected.Value,"1"),
"Low",
"High"
)
}
I hope this is helpful for you.
EDIT: Also, if you have your choice column set to allow multiple selections, then:
Table(
{Value:
If(
StartsWith(DataCardValue14.Selected.Value,"1") &&
StartsWith(DataCardValue15.Selected.Value,"1"),
"Low",
"High"
)
}
)
Hi @johnjohn123 ,
If your comboboxes have numbers as items, you should use Text function inside StartsWith:
If(StartsWith(Text(DataCardValue14.Selected.Value),"1") &&StartsWith(Text(DataCardValue15.Selected.Value),"1"),"Low","High")
You are trying to set the Update property of the datacard ? This way your third combobox will not be populated with any value. Use the defaultSelectedItem of the combobox.
Hope it helps !
@gabibalabanI define your formula inside the DefaultSelectedItems but i got this error "Expected Table Value".. any idea?
Assuming the field you are trying to update is a choice column.
Change your formula to the following:
{Value:
If(
StartsWith(DataCardValue14.Selected.Value,"1") &&
StartsWith(DataCardValue15.Selected.Value,"1"),
"Low",
"High"
)
}
I hope this is helpful for you.
EDIT: Also, if you have your choice column set to allow multiple selections, then:
Table(
{Value:
If(
StartsWith(DataCardValue14.Selected.Value,"1") &&
StartsWith(DataCardValue15.Selected.Value,"1"),
"Low",
"High"
)
}
)
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
204 | |
71 | |
51 | |
49 | |
20 |
User | Count |
---|---|
257 | |
121 | |
85 | |
75 | |
73 |