What are the challenges or Limitations of Appian

It completely depends on your application requirements.

From my perspective, the biggest challenge is to change your mind to think in processes and accept that software development with Appian can be pretty easy.