Access Token Not Found - Get File Content from SharePoint

[aahmed1]

Hi,

I recently created a flow that will create a file in SharePoint from a specific email that contains an attachment. I then proceeded to construct another flow that will wait for the file creation and then "Get file content" to proceed with parsing a csv file into json and then drop the data into a SharePoint list. My end goal would be to have the data inserted in SQL Server, I'm using the SharePoint list for testing purposes. Below is the snippet:

When proceeding to "Get File content" I get an error message "Access token is not found". I've tested the parsing before with a click flow trigger which works well. However my objective would be to make this more dynamic thus I'm using "Get file content". I tried looking into this error, some mentioned clearing out history and signing out completely. However the issue still persists. Is there any fix for this? Please let me know.

[ScottShearer]

@aahmed1 

Can you post a screen shot of the Get file content action while in design/edit mode?  Expand the action to show how it has been configured.

[aahmed1]

Hi @ScottShearer,

Sure, here's the edit of the "Get file content":

The csvFileName is just a variable I defined that is based off the name of the attachment file: 

Please let me know if you need more info.

[ScottShearer]

@aahmed1 

I don't believe that you need the Get file content action.  It appears as though the file content is available via Dynamic properties as an output of the When a file is created or modified trigger.

That said, you are using multiple triggers - When a file is created or modified SharePoint trigger and the Outlook When a new email is received trigger.  It is almost never appropriate to use multiple triggers in the same Flow.

Can you explain what you are trying to do and maybe I can suggest an alternative solution?

[aahmed1]

@ScottShearer,

I'm aware that the trigger "When a file is created or modified in a folder" would be best to simply place at the root of the flow. I only included the "When a new email arrives" before it to save the attachment name of the file to the variable "csvFileName" since this is a dynamic process. 

I could try implementing "When a file is created or modified in a folder" and look for the most recent item entry in this case file created and acquire the property info that way. The main thing is to acquire "get_file_content" which I need to correlate with the recent created file in that site stored in the specific directory specified in the address to begin the process of parsing the csv file. 

The issue that I've been facing is getting the flow to read the newly created file. I thought about using One Drive for this operation as well. But One Drive for business would work best if you knew the file name in advance making it more of a static process.