Hi @w-f,
Thanks for the post.
In this use cases, you will only need to create a custom query using the get_posts() function and filter the returned posts using a meta_query by passing the name and value of the custom field.
This is already covered in the following tutorial: https://www.advancedcustomfields.com/resources/query-posts-custom-fields/