Answered

File name matches user name, send file to user... Compose Expression issues...

(0) Share

Report

Posted on by Murphys110

Sharepoint folder with files, where the filename matches a user (for example: Jane Doe.xlsx)
Want to send the matching file to each user, based on the matching of file name (minus the .xlsx)
Using "get file properties" and then 'apply to each' where first step is a compose with this expression:

substring(item()?['Name'],0,indexOf(item()?['Name'],'.'))

Which generates this error: "Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0': 'The template language function 'indexOf' expects its first parameter to be of type string. The provided value is of type 'Null'."

I'm stuck.... any suggestions are appreciated!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

bentorrey 15 on at

Like
a
(1)

Report
Copy link

Link copied!

If I'm understanding the issue correctly, you shouldn't need to do any substring() there. As you're going through the loop, you can use the Name property to get the file without extension. FileNameWithExtension is sometimes handy, as is FileLeafRef, but in this case, I'd just grab that Name directly and go on to your user lookup for the email. That should already be the file name minus extension.

Was this reply helpful? Yes No
Murphys110 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for that! Not long after I posted, I decided to just do a separate flow with "when a file is created" as trigger. I've finally started reviewing the outputs of flows to see what the actual parameters read behind the scenes, and also noticed the name field. It works well, but I will be using your solution when I get around to tightening up the process.
Thanks!!

Was this reply helpful? Yes No