cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JanWill
Helper I
Helper I

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

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'.

 

 

 

Get File Content From SharePoint.PNG


















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

2 ACCEPTED SOLUTIONS

Accepted Solutions

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!

View solution in original post

ManjulaPraveen
Advocate I
Advocate I

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. 

ManjulaPraveen_1-1644611593287.png

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

ManjulaPraveen_2-1644611976211.png

 

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

ManjulaPraveen_3-1644612146637.png

 

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

 

View solution in original post

21 REPLIES 21

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!

Hi @yashag2255 , 

 

thanks for your reply.

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

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!

Here is the screenshot:


temp.PNG

 

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

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!

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

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!

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.

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!

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.

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!

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.

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!

Hi @yashag2255

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

Shams1
Frequent Visitor

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

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

@JanWill 

 

Thanks for your reply,

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

 

Regards

ManjulaPraveen
Advocate I
Advocate I

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. 

ManjulaPraveen_1-1644611593287.png

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

ManjulaPraveen_2-1644611976211.png

 

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

ManjulaPraveen_3-1644612146637.png

 

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

 

JanWill
Helper I
Helper I

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,982)