web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Set value based on ano...

Power Apps

Answered

Set value based on another field

(0) Share

Report

Report

Posted on by alpatel

30

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 Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
alpatel 30 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation