Get File Content from a .json file stored in SharePoint Document Libary

[JanWill]

Hello, 

I'm trying to do a simple flow, wich gets triggered by my canvas app. Next it should get the file content of a file wich is stored in SharePoint Document Libary. The file is a .json. The file content should be the response to the canvas-app.

Triggering this flow the error stops at the step "Get File content". Reviewing the run I get the following error message:

InternalServerError. Encountered internal server error. The tracking Id is '36e36e7d-118d-45e8-ac06-2c79eeb2e63c'.

Doing the same with a .txt file works. Also using the same file (.json- File), storing it on OneDrive and using the OneDrive for Business Get File Content Action works.

Does someone know a solution to this? Or maybe a reason why it behaves this way?

Thanks in advance!

Best regards

Jan

[yashag2255]

Hi @JanWill 

Can you try using the get file content via path instead and check if you continue to face the same issues?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[JanWill]

Hi @yashag2255 , 

thanks for your reply.

Yes, I already tried the get file content via path. I get the same error there. 

[yashag2255]

Hi @JanWill 

Can you share a screenshot of the flow run history along with the error message? 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[JanWill]

Here is the screenshot:

Under Show more you can see, that the input value for 'Infer Content Type' is set to true.

[yashag2255]

Hi @JanWill 

Can you confirm: 

1. No parameters are being passed in the SP action from the trigger? 

2. You have selected the file by clicking the folder icon in the file identifier and actually navigated to the file and selected it? 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[JanWill]

Yes you're right. There are no paramters passed to the action. I selected the file by clicking the folder and navigation to it.

[yashag2255]

Hi @JanWill 

For some reason, I am unable to replicate the issue that you are facing. You might want to try a couple of things: 

1. Remove the flow from the app and add again and try to check if the same issue occurs

2. On the error step, expand the outputs further to see if there is any issue over there?

3. Try the get file content using path action and then remove the flow and re add in the app and try again. 

4. Try a manual trigger test flow to see of the file is being retrieved with a simple trigger. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[JanWill]

Hi @yashag2255, 

thanks again for your reply.

I was able to create the flow with a manual trigger. Also I was able to create it with the PowerApps-trigger. Both run without any error. Then I build the same flow in my solution wich also contains my canvas app. The flow fails again. Also I created a new solution and recreated the flow that was working outside of a solution and it failed again. Also I can't add my working flows to the solution. 

With this knowledge I found this line in the docs:

Flows that connect to SharePoint are not available in solutions.

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/use-solution-explorer#known-lim...

I don't know if this explains my issue because using a .txt-file does work.

[yashag2255 · Accepted solution]

Hi @JanWill 

That is odd. But just an FYI that flows with SP connections do not work as expected in solutions. Also, if you move the solution as managed from one env to another, there is a high chance that it will break down. 

However, have you tried creating the flow outside of the solution and then adding the flow to the solution? I have done this earlier and it does seem to work. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[JanWill]

Hi @yashag2255, 

thank you for your Information.

I can't add the flow to the solution since it isn't listed under: Add exisiting -> Flow -> Outside of Solution.

[yashag2255]

Hi @JanWill 

Can you check if the solution is in the same environment as the flow is in? 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[JanWill]

Hi @yashag2255,

yes, it's in the same environemt. I think it can't be added because using PowerApps as a trigger it's the flow type is instant. In the docs again it says:

Button triggered flows are not available in solutions.
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/use-solution-explorer#known-lim...

This would be again my guess why I can't find this flow, even its not a button triggered flow, but both are instant flows. 

Adding a flow with an automated trigger to the soultion does work.

[yashag2255]

Hi @JanWill 

I have created the flow where the trigger was when an http request is received and that is of type instant again and was available to add in the solution. 

It could be different for different triggers. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[JanWill]

Hi @yashag2255, 

thanks for your reply. That's interesting but doesn't make things easier. Thanks for your help!

[Shams1]

Did you get any solution for that ? I am facing the exact same issue. help!

[JanWill]

Hi @Shams1,

is the flow you've created inside or outside of a solution? 

I've would recommend to rebuild your use case outside of a solution and test if it's working this way.

Best Regards,

Jan

[Shams1]

@JanWill 

Thanks for your reply,

My flow is outside of the solution, Not using solutions at all.

Regards

[ManjulaPraveen · Accepted solution]

I know this a pretty old post but I have the same issue and was able to find a work around, thought it might help someone.

My requirement was to read a JSON file from the SPO library and add/append content to it.

1. In the get file content step, set the Infer Content type to "No". the output would then be the Base64 code. 

2. Use the string conversion in the next compose step.  

3. Then again convert that into  JSON type value. Use another compose step an the JSON conversion function

There could be a better way to do this, but this works for me .

[JanWill]

@ManjulaPraveen So far I habe no time to test it. But I'll mark it as an solution.