I want to concat a few fields together to maintain a unique Title for sharepoint list items.
However due to URL length restrictions I need to cut down the size of the title. In order to do that I want to identify two fields (FieldA and FieldB) to use.
FIELDA will never not be empty. It is a required field.
If FIELDA is not empty and FIELDB is empty then concat FIELDA.
OR
If FIELDA is not empty and FIELDB is not empty then concat FIELDB.
Here is my current concat formula: concat(substring-before(Registration Cut-Off Date, "T"), " ", Office, " ", FIELDA, " ", FIELDB)
Now I did figure out a way to do it using action rules and having a "helper field". But is there a way to do this using xpath all in the same formula/field?