Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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:
Can anyone help what to do? 🙂
Thank you very much!
Solved! Go to 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.
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
Hello @Laura_Dannisoe
two things that come into my mind here:
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
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:
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.
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 🙂
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
24 | |
12 | |
11 | |
11 | |
8 |
User | Count |
---|---|
43 | |
25 | |
16 | |
15 | |
12 |