Answered

Missing ID on File in Sharepoint Library

(0) Share

Report

Posted on by davidfehrenbach

Hi to all,

I tried to extend the "save attachment to Sharepoint-Library"-Template a little bit.

My goal is to provide aditional information like e.g. where the email comes from, so I tried to us the "Update File"-Action to map those information with columns in the Library itself.

Here is where the problem occurs: I need to know the ID of the created file. I Here, the dynamic content only provides "size" which isn't very usefull to identify the created file.

Has anybody similar problems or a solution?

Thank you very much

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @davidfehrenbach,

I think here you are using the Update file properties Action, right?

There is a little difference between those two actions.

For Update file properties, it would need the corresponding Item Id, not the File identifier,

For the Update file action, it needs the file identifier, which could be generated from the Create File action.

To get the corresponding Item ID, we need to use the Get files (properties only ) action, and it is not so easy to get the ID.

I will make some more tests and share the result here once I finished.

Regards,

Michael

Was this reply helpful? Yes No
theBIMtractor 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-micsh-msft, I'm also desperately needing this functionality in order to copy a file, complete with it's properties. Any ideas how long it might take to get an upate on this?

Was this reply helpful? Yes No
UKCAdmin 13 on at

Like (0)

Report
Copy link

Link copied!

Yes, I've been looking for this for a while as well. It seems crazy to me that when you do a Create File that it can't pass an ID to the next step in the flow. Better yet, let us specify the metadata when you upload the file in the first place.

My flow looks like this:

HTTP Get File Content --> Create File (Here I pass the BODY from the previous step and specify a File Name) ---> Get files (properties only) THIS IS WHERE I AM STUCK

When you upload the file, you can't specify any metadata other than the filename, BUT I can't seem to figure out a way to filter by the filename in the "Get Files (properties only)" step. And believe me I have searched all over for this.

IF a file has a title set, you can easily enter "Title eq 'TITLEHERE'" into the Filter Query field and it will return that one file (inlcuding the ID) and then you can use the update file properties task and be on your way.

But, this is where we are stuck because the upload process doesn't allow you to specify any other properties other than file name.

The Dynamic content returned from the "Create File" task is this:
DisplayName, ETag, FileLocator, Id (not the SPID), IsFolder, LastMOdified, MediaType, Name, Path, Size

So far I can't figure any way to filter by any of those returned values to get the SharePoint ID of the file I just uploaded.

You would think it would be as easy as Name eq 'FILENAME' but that returns an error saying that there is no column with the name "Name".

If anyone has figured this out, please let me know!!!

Was this reply helpful? Yes No
Verified answer

UKCAdmin 13 on at

Like (1)

Report
Copy link

Link copied!

This worked for me as a solution:
http://www.cleverworkarounds.com/2017/07/14/the-currently-best-way-to-update-sharepoint-document-metadata-using-flow/

Was this reply helpful? Yes No