Getting the perfect look from your foundation is often a mix of the right product plus the right application. Choosing liquid, powder, or cream foundation often has more to do with your skin type than your preference. Oily skins don't need the richness of a cream makeup, and dry skin usually looks even drier or flaky with powders. Think about the look you want and what your skin needs as you try different formulas. If your foundation looks too dewy or won't spread evenly on your skin, perhaps your moisturizer is too rich or it needs more time to absorb into your skin before you apply your makeup.
Dehydrated skin can grab onto the foundation and make it streak and set too quickly.
Before you apply your makeup, your skin should feel comfortable, and without any excess moisture. You might also be having problems because of the Retin-A, which can make the skin sensitive or dry. Every woman I know has her own method for applying foundation, so there are really no rules or absolutes. I suggest trying a few different techniques to see which one gives you the finish you want. I would encourage you to experiment until you find a method that you feel comfortable with.