You’re offline. This is a read only version of the page.
Announcements
108
Hi All,
Good Day!!
I have excel template and circulated to different level of users. I will get back the excel with some input and consolidate it to Master excel. Created flow to read the source excel once after the upload to SP Document library and copied data to Master. But i couldn't get the data for few columns, where "/" is available in column header. Since few of data contains "/" , i couldn't proceed with search & replace of "/" manually before uploading the excel in sharepoint document library.
My excel template is structured like, 1st row - Header, 2nd row - Guidelines, 3rd row - Contains actual column header.
Here i tried to use "Get a row" option to pull row 3 records alone and proceed with replacing "/" to <<space>>. But unable to provide Key Value.
Is there any other possible way available to identify "/" from my column header and to replace it with space?
Thanks in advance.
Hi @suriyamv07 ,
Are you trying to replace "/" in your data?
In power automate, "/" can be expressed as decodeUriComponent('%2F').
You can try to replace it with this formula:
replace(string,decodeUriComponent('%2F'),'')
Best Regards,
Dehzi
Share
Report
All responses (
Answers (
