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.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
Check out the community blog page where you can find valuable learning material from community and product team members!