Invalid number of arguments: received 2, expected 0-1

(0) Share

Report

Posted on by nleuck_101

429

Hello All,

I'm working on a Power App that you can upload files (like Excel) and it puts the data in to a SharePoint list. I'm following Shane Young's video Power Apps import Excel to SharePoint list or any data source with Power Automate. I'm getting the following error "Invalid number of arguments: received 2, expected 0-1" where I run the flow on the OnSelect of the button. In his video, he does this on the OnAddFile of the Attachment control. The below screenshot is from Shane's video but it's where I'm getting the error. Any ideas on why and how to solve this? I greatly appreciate it!

Categories:

Error handling

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Can you show a screenshot of the trigger in the UploadandImport flow?

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
nleuck_101 429 on at

Like (0)

Report

Is this what you're asking for?

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Can you also show the OnSelect you are using to Invoke the flow? You said the screenshot you supplied was from Shane's video.

Was this reply helpful? Yes No
nleuck_101 429 on at

Like (0)

Report

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report
I haven't watched Shane's video so I'm not quite clear on what he is doing with that code. But I have a similar demo that uses the attachment control and a trigger configured to accept a file. The onSelect code for my flow is below. As you can see it includes a single file record consisting of the name from the attachment control and the Content. This is what works for me.

UploadFileFlow.Run({file: {name: First(AttachmentControl.Attachments).Name,contentBytes: First(AttachmentControl.Attachments).Value}})

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
nleuck_101 429 on at

Like (0)

Report

So this kinda works for me. The file does get added to my document library. The issue is I get an error code 504, BadGateway, Response Timeout, The server did not receive a timely response from the upstream server. My list only uploaded 256 out of the 1,004 records I have in the Excel file. Any ideas on what might have caused that?

Was this reply helpful? Yes No
nleuck_101 429 on at

Like (0)

Report

So this kinda works for me. The file does get added to my document library. The issue is I get an error code 504, BadGateway, Response Timeout, The server did not receive a timely response from the upstream server. My list only uploaded 256 out of the 1,004 records I have in the Excel file. Any ideas on what might have caused that?

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

When you call a flow from a Power App you are calling the flow Synchronously. The app will wait for a return from the flow before proceeding. The problem is that what you are doing is taking too long and the return is timing out before it can return to the Power App. You should break your flow up into two flows.

1) The flow that uploads the file to the SharePoint document library should be the one called from the Power App. But don't do any processing of the upload in that flow.

2) Then create a second automated flow that runs when a document is created in the SharePoint document library. That will trigger when the first flow uploads the file. Have that flow do the processing of all the records. That way the app doesn't have to wait for this background processing to happen before it can continue.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
nleuck_101 429 on at

Like (0)

Report

Update. I believe part of my issue was I was hitting a Pagination limit in the List rows present in a table for my flow. I turned that on and changed the limit to 2,500. I still get the same error timeout but I did get all 1,004 records uploaded to my list.

Was this reply helpful? Yes No