Hi @NielsL ,
It seems you want to get some certain columns from CDS.
I suggest you use the 'Select' action to get the certain columns.
Using the 'Filter array' to filter the records.
Community Support Team _ Zhongys
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the input. I'll try to test that somehow. It's just a bit diffucult since the limitation regarding calculated fields only is in the Production environment.
Wouldn't your flow fail already in "List records" step? I can't see how the "Select" action can help, you need to filter before the data is retrieved. I am also looking for a way to add "select" attribute to a query, can't believe it is not there in "List records" action. If you figured it out, please post the answer here.
Did we ever solve this one?
I am struggling with the same scenario where I want to limit what columns my List records brings back. I am getting the same error - Number of calculated fields in query exceeded maximum limit of 50. - even if I fetch only 1 record.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!