Answered

Set value based on another field

(0) Share

Report

Posted on by alpatel

I have a powerapps custom form and the "zip code" is an text free entry based on zip code the county name should populate on "Region" Field. Below formula in powerapps is not working. I need OR condition.

If(DataCardValue6.Mode='11727'||'11324', set(DataCardValue8)='Suffolk County',set(DataCardValue8)='None')

Please advise.

Categories:

Power Apps component framework

All responses (2)

Answers (1)

alpatel 30 on at

Like (1)

Report

Re: Set value based on another field

We don't want to do lookup as user have to maintained the list.

I used option second code and that worked beautifully.
Thank you so much for your quick response.
Verified answer

v-jefferni on at

Like (0)

Report
Re: Set value based on another field

Hi @alpatel ,

Could you please share more details about your scenario? Do you have another list where contains county names along with unique zip codes? If there is a list it will be quite simple.

I assume the list is named Counties, with county names in Title column and zip codes in ZipCode column. Both columns are of type text. So, Text property of DataCardValue8:

Coalesce(LookUp(Counties, ZipCode = DataCardValue6.Text, Title),"None")

If you do not have the Counties list, according to the formula you give, please try below in Text of DataCardValue8:

If(DataCardValue6.Text="11727"||DataCardValue6.Text="11324", "Suffolk County","None")

Best regards,