Is there a way to create a fountain show like this in the engine?

Hi

Is it possible to make this in UE4?
I have tried many ways and these are the results

The only issue left is the timing and how to make them move left and right. I am using Niagara and I am still a beginner. Blueprints, C++ and Sequencers are also new to me.

I would also like to know how to make lights (Point Light) change color.

Thanks for reading!

You’re on the right track. You can make the particles look EXACTLY like water, example here:

but that's the 'craft'...

Point light changing color can just be done from blueprint, or you can write a material that uses sine waves to automatically change.