You can use a series of images to display an animation or to create and interactive demo.
The sequence can easily be exported from Photoshop (File > Export > Render Video...).
Once you have a folder of PNGs or JPGs, you can insert the sequence into InDesign using in5's Image Sequence widget (in5 > Interactive Widgets).
Click the ... button to browse to your image folder and then adjust the settings as needed.
In the video below, Keith Gilbert uses this technique to create an interactive demo of a 3D model.
More can be seen in the Create a 3D Product Demo course.