Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Laura_Dannisoe
Frequent Visitor

Expression.Error: 1 argument was sent to a function, which expects 2

Hello community!

 

I am getting this error: 

Expression.Error: 1 argument was sent to a function, which expects 2.

Details:

Pattern=

Arguments=[List]

 

This is the power query:

Laura_Dannisoe_0-1611656328395.png

 

Can anyone help what to do? 🙂 

Thank you very much!

 

 

1 ACCEPTED SOLUTION

Hello @Laura_Dannisoe 

 

is this your function "SinglePageMB"? As I can see it needs two parameters, but you are launching it with only one.

Jimmy801_1-1611660743527.png

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

 

View solution in original post

4 REPLIES 4
Jimmy801
Community Champion
Community Champion

Hello @Laura_Dannisoe 

 

two things that come into my mind here:

Jimmy801_0-1611658709863.png

Is Record.Field returning a list to count? In other words, is the record "StartRecord" containing fields that contains list where you can count items?

 

You are using a few custom functions. Maybe here you forgot to add a parameter

Jimmy801_1-1611658797446.png


If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

Hi @Jimmy801 !

 

Thanks for your answer. 

Yes it is returning a list of items.

 

I have checked the custom method and when I am calling it, it seems to work correct. This is the query for that method:

Laura_Dannisoe_0-1611659375841.png

 

Do you have any ideas of what I can try?

 

Best,

Laura

 

Hello @Laura_Dannisoe 

 

is this your function "SinglePageMB"? As I can see it needs two parameters, but you are launching it with only one.

Jimmy801_1-1611660743527.png

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

 

 

Ah just noticed that the name of the function was "SinglePageMB (3)" and it thought the "(3)" was a parameter. It is working now, thank you! 

 

Have a great day 🙂 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.