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.
Check out new user group experience and if you are a leader please create your group
May the fourth be with you, join us online!
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.