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.
Best Regards,
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.
Regards
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.
I had slightly different requirements but your instruction helped a lot. Thanks!
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!
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
19 | |
15 | |
10 | |
10 | |
9 |