Hi.
I'm trying to find some text in files on Sharepoint. For that I used "Send HTTP request to Sharepoint". Once I get Result is shows search in HTML format. I convert it to text, but after that I realize that path to the file contains "enter". And step - get file content using path failed.
I tried to use "replace", but it didn't help.
Solved! Go to Solution.
@Anonymous please follow this
see when you use uriComponent you have this %20%0A%0A string that means your like break. Then you just can replacte this to delete it from your line.
Proud to be a Flownaut!
hi @Anonymous enter is a line break like this
12123123
12312312
that blank space is a line break for me, it is for you the same as enter?
if is yes please use this expression
uriComponentToString(replace(uriComponent(body('Html_to_text')), '%0A', ''))
you can follow more info here https://powerusers.microsoft.com/t5/Building-Flows/Replace-Newline-in-Flow-Expression/td-p/57333
Proud to be a Flownaut!
@ChristianAbata hi.
yes. The problem is that when I get a substring from converted text it in some cases shown like:
”https://....../folder
xxx/filename.pdf”
if I use this substring in get file content it shows error due to line breaker.
i made a test removed it, so line looks like:
”https://....../folder xxx/filename.pdf”
and it worked properly. So I’m looking for a way how to remove that line breaker.
Hi @Anonymous
Use a Split expression then iterate the values and map in next step.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blog@Anonymous please follow this
see when you use uriComponent you have this %20%0A%0A string that means your like break. Then you just can replacte this to delete it from your line.
Proud to be a Flownaut!
Hi, tried your solution, but that didn't work for me.
As a result I got as an input on a second compose -
Path%2FFolder%0AXXXXX%2F2020%2F05%2F103_120520_PP200512-0508418.pdf
Instead of Path/Folder XXXXX/2020/05/103_120520_PP200512-0508418.pdf
On a step "get file content using path I added replace function to output from Compose replacing %2F by "/" and it worked 🙂
Thanks 🙂
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
28 | |
26 | |
23 | |
17 | |
10 |
User | Count |
---|---|
59 | |
56 | |
29 | |
27 | |
24 |