Unanswered

Problem building my first flow from Excel -> Planner

(0) Share

Report

Posted on by MPLekter

Hello,

I just started testing the Power Automate.
Simple flows from templates work well, but when I tried doing something more custom-made
(On button pressed, take rows from Excel file and make new tasks in Planner)

I get a fail with this message included:
Only ordering by properties is supported for non-primitive collections. Expressions are not supported. inner exception: Only ordering by properties is supported for non-primitive collections. Expressions are not supported. clientRequestId: a3f247b3-948b-4bf5-9382-d39bf34cd36d

Attached a picture to show what is going on.
Any ideas where the trouble is? Thanks!

Categories:

Building flows

Flow_diagram_fail...

Flow excel_25-05-...

Flow failed_25-05...

I have the same question (0)

All responses (2)

Answers (1)

v-qiaqi@microsoft.com on at

Like (1)

Report

Re: Problem building my first flow from Excel -> Planner

Hi @MPLekter，

Could you please show me how you configure the OrderBy parameter in the List rows present in a table?

Actually we will order by a specific column.

Was this reply helpful? Yes No
Verified answer

MPLekter 17 on at

Like (0)

Report

Re: Problem building my first flow from Excel -> Planner

Hi Qi,

this problem did not persist after a while of playing around with the flow.
I probably had something in the OrderBy, as you mentioned.
Hard to re-create the problem now, so I think we can close the case.

Was this reply helpful? Yes No