Honestly OP, from the research I have done on collagen powder it's not going to give you the results you want and is therefore a waste of money.
If you are looking to increase collagen production in your skin, it takes more than just ingesting collagen powder (which is usually just amino acids that are also found in protein, so you could save your money and eat some good quality steak instead). If your diet is lacking in protein that may be beneficial to you generally, but there's no guarantee it will be delivered to the places you want it (your skin).
There are however a few things that have been shown to specifically increase collagen production in the skin (which unfortunately declines a lot as we age).
The main one is using a topically applied retinoid on a regular basis (so tretinoin, retinol, retinaldehyde etc.). This has been shown in studies to increase collagen production over time, along with other skin benefits like improved skin tone and texture. An over the counter retinol is a weaker strength, so it will take longer to see good results.
Another one would be lasers and radiofrequency procedures you can get in salons or dermatologists - these work by causing a controlled injury in the skin, which triggers a healing response and as a result there is a temporary spike in collagen production as part of the repair process.
There is also some research to show that LED light at certain wavelengths (red light specifically) can stimulate the fibroblast cells in the skin - these are the little collagen factories - and the good thing is there is no down time or irritation like you usually get after a laser treatment or similar. Again you can get LED treatments in dermatologists offices or skin salons. Or there are at home devices like LED masks.
All of these things will have mild to moderate results, and would ideally need to be used consistently to maintain results. Unfortunately, from our 30's onwards our collagen production just drops like a stone and there's only so much you can do to claw it back. Also make sure your diet (or vitamin supplements) include vitamin c and zinc as these are necessary for collagen synthesis.
The last thing you could do is use a good sunscreen everyday, as UVA light can destroy your existing collagen so it will help preserve what you have.