Unanswered

API error pulling uploaded file from form into email

(0) Share

Report

Posted on by devatron

Hi There! I know there are several posts regarding email attachment but I am getting an api error it seems and I am trying to determine why the uploaded item cannot be found.

Both the form and the flow are related to a team, if that helps.

The instructions I followed are here.

I keep failing on the "get file content using path) step - looks like the following:

{

"status": 404,

"message": "Item not found",

"source": "api.connectorp.svc.ms"

}

The path I am entering is: /Apps/Microsoft Forms/Sponsor Image Addition Request/Question/first(body('Parse_JSON'))?['name']

(the expression is definitely entered as an expression, not just typed in)

Which yields this output path: /Apps/Microsoft Forms/Sponsor Image Addition Request/Question/18596_greeting2_Devon Brown.jpg ... but I am still receiving an error.

Here is a shot of my flow - thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (21)

Answers (1)

abm abm 32,858 Most Valuable Professional on at

Like (1)

Report

Re: API error pulling uploaded file from form into email

Hi @devatron

check the path /Apps/Microsoft Forms/Sponsor Image Addition Request/Question/first(body('Parse_JSON'))?['name'] is correct and make sure the file is there.

Was this reply helpful? Yes No
devatron 45 on at

Like (1)

Report

Re: API error pulling uploaded file from form into email

@abm - and this is where I might be stupid 🙂 So taking that path and pasting it into my browser and file explorer, I get nothing.

However, the way I added it was using the selection tool in the step itself. Should I be doing something else? Or trying to access that path even in a different way?

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (1)

Report

Re: API error pulling uploaded file from form into email

Hi @devatron

This is stored under your one drive as default. See below.

What's your first expression you are using? Make sure there are no space after Question/

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (1)

Report

Re: API error pulling uploaded file from form into email

Hi @devatron

Try to select the file and see whether that works or not. This way it make sure that the hardcoded file is working or not. Another way to try is add a compose and add the path and filename mapping. Next set the output compose mapping here. Make sure set as Dynamic content.

Was this reply helpful? Yes No
devatron 45 on at

Like (1)

Report

Re: API error pulling uploaded file from form into email

@abm Interesting - I actually never used OneDrive previously as my company uses share point. I do see in my local OneDrive folder that nothing is there (see below):

But when i go through he process I described previously, all items live there. Thoughts? Perhaps I am confusing something still, which is entirely possible.

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (1)

Report

Re: API error pulling uploaded file from form into email

Hi @devatron

It must be your office one drive? Who is the owner of the Forms? It must be related to that account.

Also did you tested with my suggestions.

Check your one drive connector using your office account? That might be the case?

Thanks

Was this reply helpful? Yes No
devatron 45 on at

Like (0)

Report

Re: API error pulling uploaded file from form into email

Hi @abm !

When you mentioned "selecting the files" I assumed that is what I was trying to do by finding them via the path wherein I ran into those issues I had screenshots for.

I am the owner of the form but I shared it with our team that was created - could that be the issue?

Was this reply helpful? Yes No
abm abm 32,858 Most Valuable Professional on at

Like (1)

Report

Re: API error pulling uploaded file from form into email

Hi,

Remove your expression and select the file from the drive and test?

Thanks

Was this reply helpful? Yes No
devatron 45 on at

Like (0)

Report

Re: API error pulling uploaded file from form into email

I just tested and selected a specific file in that same folder path and it definitely attached. So that means something with the expression is broken possibly? Or is it something else that I should consider?

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report

Re: API error pulling uploaded file from form into email

Hi @devatron ,

Is it a group form? I noticed that you enter form id to Form Id instead of selecting options from the dropdown list.

If it is a group form, we need to get the file content from the SharePoint Library.

Please check this similar thread and see if it helps:

https://powerusers.microsoft.com/t5/Building-Flows/O365-Group-Form-responses-with-attachments-to-Sharepoint-List/m-p/463809#M55734

Please take a try and feel free to let us know if you have any other questions.

Best Regards,

Was this reply helpful? Yes No