Your second lot of code looks like it should work. You have followed the example code from ACF, however, I think the ‘post_type’ => ‘any’ is your issue. I don’t think this is possible. Can you confirm the docs about this?
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users