I have the code listed below as the TEXT of a datacardvalue. It works great. I was wondering if there is a way to NOT show the red
middle section if it is empty and let the city,state,zip move up a line? Its not that big of a deal. I just think it could look nicer if when address2 is blank that the datacard box is more condensed.
ThisItem.Address1 & " " & ThisItem.Address2 & " " & City & " " & State & " " & Zip
Solved! Go to Solution.
Hi @SeanTambling ,
Use below formula instead to achieve this:
If(!IsBlank(ThisItem.Address2),ThisItem.Address1 & " " & ThisItem.Address2 & " " & City & " " & State & " " & Zip, ThisItem.Address1 & " " & City & " " & State & " " & Zip)
Regards,
Mona
Hi @SeanTambling ,
Use below formula instead to achieve this:
If(!IsBlank(ThisItem.Address2),ThisItem.Address1 & " " & ThisItem.Address2 & " " & City & " " & State & " " & Zip, ThisItem.Address1 & " " & City & " " & State & " " & Zip)
Regards,
Mona
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
200 | |
99 | |
59 | |
59 | |
54 |
User | Count |
---|---|
257 | |
161 | |
88 | |
79 | |
69 |