Re: Anybody knows how to reduce API calls using Flow?
Select will do nothing to limit your API calls, every time you use it you increase your API calls. Please see the Use the select action portion of the Data operations documentation:
Use the Data Operations – Select to transform the shape of the objects in an array. For example, you may add, remove, or rename elements in each object in an array.
A Filter Array will filter only the results within the array that you care about, from that point you can utilize other data operations like select.
Your Apply to Each is what is creating the vast majority of your API calls, so you need to perform data filtering prior to the loop to limit the apply to each to only the relevant data, and not all data.
If you need all of the data, and you keep hitting API thresholds, then your only real option is to build in delays within your Flow, so you don't exceed thresholds.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!