Forum Discussion

MarkAldous's avatar
MarkAldous
Copper Contributor
Oct 21, 2024

Action 'Get_file_content' failed suddenly

Morning,

I have had my flow fail suddenly with no changes to the form or the flow.

I use the following to get the file contents from the MS form response

 

json(outputs('Get_responses_from_TSE_form')?['body/rb415b42e1eb44a34b1ee76469acebe18'])
 
The 'Get responses.. is from the dynamic content for where the attachments are uploaded within the form - therefore all of the text from "json" is entered for me.
 
 
This worked fine up until last week now I get the error:
 

 

 

I have also re-run one that has previously worked and that now does not work.

 

All I can assume is that an update/change has been made to this action?

Any help would be appreciated.

 

Microsoft Flow

7 Replies

  • Waz's avatar
    Waz
    Copper Contributor
    Dec 10, 2024

    Mark, 

    I have been working on this on some response forms for myself and stumbled across this video series <https://youtu.be/Od3y5mfQ8QA?si=VeAtNqP_F_emz6nH> The creator does a great job of breaking things down and it helped me solve my issue. Which was that I was not using a DriveID when trying to "Get File Content" so Power Automate was looking in my personal one drive rather than the group sharepoint site. I hope this information helps you! 

    • MarkAldous's avatar
      MarkAldous
      Copper Contributor
      Dec 11, 2024

      Thanks for this, I will take a look.

      coincidentally I fixed this issue by moving the flow (which was on a shared drive) to my own drive and it now works. All I can assume is that MS have changed something..

  • BryceB's avatar
    BryceB
    Copper Contributor
    Dec 09, 2024

    I am also experiencing the same issue. With one exception, the error. My error is a "statusCode": 400. I also tried the file input for the Get File Content action with and without the json before output. Which is how it original worked for me.

    • MarkAldous's avatar
      MarkAldous
      Copper Contributor
      Dec 11, 2024

      I fixed mine - well more of a work around. The form sends the file attachments to my one drive. The flow is on a shared drive, so I re-created the exact same flow on my one drive and it now works fine.

      MS must have changed something so that the shared drive flow cannot get files from a personal drive??

  • Waz's avatar
    Waz
    Copper Contributor
    Dec 09, 2024

    Out of curiousity, are you using a custom value for your form ID? on the Get Response details? This is the only difference I have in my flow from other versions that are successfully collecting attachments and adding them to lists. I used custom value because Power Automate did not link up with new forms that I just created. 

    • BryceB's avatar
      BryceB
      Copper Contributor
      Dec 10, 2024

      I am not using custom values. Just using the connections hub for the various MS connections.

  • Waz's avatar
    Waz
    Copper Contributor
    Dec 09, 2024

    I am also having this same issue. Last week, I created a form to collect data from staff and a list to store that data, completed multiple successful tests with various attachments. This morning I created my next form/list, I've verified that everything is correct. And i am getting the same error message when testing the flow. 

Resources