Unanswered

use power automate to find last modified date of various files on sharepoint.

(0) Share

Report

Posted on by Sofiyan

171

On a sharepoint site, i have two columns called location_link and last_updated. In the location_link column, there are urls to documents stored in various locations in the sharepoint. I am using power automate to go through each link and find the last modified date. I want the flow to then update the last_updated field with the modified date. I'm using a scheduled flow. Then I use an apply to each activity. In the activity, I have a Compose activity with the following expression:
split(replace(triggerOutputs()?['body/Location_Link']?['Url'], 'https://de.sharepoint.com', ''), '?')[0]

Then I use a Get Properties activity, Get file metadata, and Update Item activities however, the flow doesn't make it that far and fails right after the Compose activity because it's sending Null values to Get Properties.

Am I going about this all wrong? Is there another method that would serve better?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Sofiyan

Please share your flow. Share your errors, show your configuration.

Specifically show the flow run, so we can see what failed and why.

not enough information to guess why you have null errors.

You also explain it as if you want to update the first table you talk about with the Modified Date of the Last update.

But if each row in Table A, has 1-Many files to look at, which specific one are you wanting to us the modified date from to update the Last Udated column in the list?

Its a bit confusing what you are try to do and how, based on what you explained.

Please share some pictures and do a walk through of steps would help.

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Sofiyan

Instead of storing the file link, you should store the site address and the path.

Using those together with get file metadata using path action, you can get the modified date.

Hope this helps.

Cheers!

Was this reply helpful? Yes No
Sofiyan 171 on at

Like (0)

Report
Copy link

Link copied!

Hey @narayan225:
The trouble with using the file path is my userbase. They are not techsavy enough to find the location path. It's easier for them to copy and paste the link.

However, for testing purposes, I tried your method. See the screenshot below. The error suggests that no files exist. I can confirm the file does exist.

In my original post, I shared the expression I used in Compose to extract out the path from the URL. My preference would be to use this method for the concern with the userbase described above. However, using that method hasn't worked either. What could you suggest?

Thank you.

Was this reply helpful? Yes No
Sofiyan 171 on at

Like (0)

Report
Copy link

Link copied!

hey @Michael E. Gernaey, here are the workflow and comments:

Error:

About your comments "You also explain it as if you want to update the first table you talk about with the Modified Date of the Last update.

But if each row in Table A, has 1-Many files to look at, which specific one are you wanting to us the modified date from to update the Last Udated column in the list"

My response: You are misunderstanding. The sharepoint list has two columns. One with the Link and the other a date field called Last_Updated. I want the power automate to run each row in the list, find the file location using the provided link and retrieve the Modified Date. Then, I want the flow to update the Last_Updated field with the modified date.

Was this reply helpful? Yes No
narayan225 2,547 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Sofiyan

You are getting the error when using the file path because you have not replaced the %2b and %252f with / and space.

Use this formula in there and get file metadata using path should work fine.

replace(replace(outputfromCompose,'%252f','/'),'%2b',' ')

Hope this helps.

Cheers!

Was this reply helpful? Yes No