Unanswered

Parse JSON and Convert to String

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm trying to do a flow that has the goal to send an word file by e-mail that is stored in a network share folder.

In a Sharepoint we have the same files stored with the same name but as pdf files. So, when a file in State "to be reviewed" we need to send that file in word by email do the responsbile person to review the file.

So I came up with the idea of adding a column to sharepoint with the name "Name .docx" that column is to have in sharepoint the same file name that we have in the network share folder to send the right one.

First, I did an filter ODATA query to filter all the file that Status eq "Para Revisão" (that means to be reviewed in portuguese) and then I Parsed Jason to have the strings that I need. With that string I tried to get file content in the right netwrok share folder but It doesnt work.

Can sombody help me? Or have better ideas to do this right?

Thanks 🙂

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Anupam.Khasia 368 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Can you answer few questions to troubleshoot issue ?

1) In "Get File contents using path" action , are you getting correct path with file name ?
2) Are you encountering any error with this flow ?

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello, Thanks for reaching out to me 🙂

So firstly, I tried a new think and it kinda worked. I create an append to string connector using Name + .docx. The problem is that when is using aplly to each he does Name+.docx right (and I received the mail) but then he does NameName2+docx + NameName2Name3.docx and so on and it gives error.

So as I said the outputs comes like this:

E-mail only comes with first document:

And then when you see the flow:

So this solution doesnt work to.

Can you help me find a way to do this?

Best regards,

Edgar Simões

Was this reply helpful? Yes No