Answered

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

All responses (21)

Answers (1)

Sort by

abm abm 33,004 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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.
devatron 45 on at

Like
a
(1)

Report
Copy link

Link copied!

@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?
abm abm 33,004 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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/
abm abm 33,004 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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.
devatron 45 on at

Like
a
(1)

Report
Copy link

Link copied!

@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.
abm abm 33,004 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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
devatron 45 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
abm abm 33,004 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

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

Thanks
devatron 45 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
v-bacao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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,