Share
ReportHello,
I'm building a flow but had some issues:
1. I have a Sharepoint list as the master database with 100 salespeople (First name, last name, email address, report name as plain text). Report name only has something like that: JDoe, FRich etc. No file extension or date, only name format.
2. I want to fetch files from sftp to sharepoint and whenever a new file is added, I have to update the folder's email column with the new file. I asked client to use the same file name but it has to be different for each month like JDoe_Jan, JDoe_Apr. That means someone has to update the email column accordingly. I'd like to automate that.
I tried Get folder metadata, update file properties but didn't work. I tried to filter file name comparison and didn't work.
File name: JDoe_Apr242.pdf
Report name column on Sharepoint list: JDoe
I tried to filter if file name contains report name to catch "JDoe" then update the file properties for email column but didn't work. How can I achieve this? thanks.
All responses (
Answers (
873
