I don't think I really know how to do makeup either but one thing I've learned is to kinda follow tutorials but also don't be afraid to try other stuff.
Foundation seems to look flaky on me no matter what I do, and anyway I don't wanna spend forever doing makeup so I decided I was gonna cover a couple broken capillaries on my face with concealer and then blend that out, which would have the side effect of kind of muting the natural rudiness of my face a little (but not completely getting rid of it either).
I ran into a problem though: the concealer often looked flaky, too. I tried everything, different brands, using less, using more, different primer, asking the best looking people at Ulta what they would recommend, changing up my skincare, etc. but I always was using liquid concealer because that's all anyone ever uses it seems like.
Then one day my mom gave me a CoverGirl stick concealer, was way cheaper than anything I picked up at Ulta, and it was a fucking game changer. I think it's a little more waxy and I need that to pat down the flakes? And also probably easier to use less. There are areas I still can't use it (right around my nostrils will always look flaky) but whatever, it's working for me!