Hi all! I've attempted searching but I'm not seeing this exact problem, so apologies if I missed it.
I have a form that's owned by our Advancement group and it allows for a picture to be submitted as an attachment. Upon submission, I create a SharePoint list item with the responses, then check to see if an attachment was submitted. If there is no attachment, I send an email that contains the information. If there IS an attachment, I do a Parse JSON, then Get file content, then Add attachment to attach the file to the SP list item I created previously, then send the email with a link to the SP list attachment.
I've done this successfully with forms I owned, where I'm retrieving the file from my own OneDrive. Where I'm running into trouble now is that I can't seem to retrieve the file from the team site of the Advancement group.
My connections are in place using a service account, and the service account has read/write access to the Advancement team site. I've verified that the files show up in that location.
So ... is there a way I can indicate a specific directory, but include a variable from the JSON step to identify the correct file? Or another way to do this?
Here come screenshots. 🙂 Let me know if more are needed.