cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeterZigante
Helper II
Helper II

Sharepoint updating file log

I would like to update an excel file stored on sharepoint with the file properties in that library. However it seems to not be updating, am i missing a step? The folder contains 10 files, but when i run this flow, it does not reflect any rows in the excel file i have uploaded there.

PeterZigante_0-1652906450398.png

 

PeterZigante_0-1652889570415.png

PeterZigante_1-1652889742334.png

 

 

8 REPLIES 8
eliotcole
Super User
Super User

Have you tried wrapping those values in a string() function within an expression, instead of placing them directly in there?

 

I'm not under any illusions that it would resolve this issue, but it's worth a shot. 😉

I can give it a try, did you mean something like below (i typed "string()" then placed "value" dynamic content inside brackets)

string(outputs('Get_files_(properties_only)')?['body/value'])

Yeah, give that a shot as an expression ... except it looks a bit malformed. Lemme just get the exact syntax for that.

Name

string(items('Apply_to_each')?['{Name}'])

Link

string(items('Apply_to_each')?['{Link}'])


Modified

string(items('Apply_to_each')?['Modified'])


Path

string(items('Apply_to_each')?['{FullPath}'])

 

Again, I don't think this will solve it, but it might help.

Still does not update the table.

Thanks though

Dang.

 

What shows up in the results when you run the flow, are there any errors?

 

Is there a chance that this is updating a duplicate file?

No errors, it just does not populate the excel file. This wouldnt remove rows if a file is removed from the sharepoint library would it? 

eliotcole
Super User
Super User

I don't think so.

 

Is there a chance you could update the original question with your full flow, please?

 

Maybe we'll see something obvious.

It is just those, plus a recurrence trigger to start. (I ran the flow to test it). 

But i would like the excel sheet to populate the rows with current data, maybe i should be looking at creating an excel file each time from scratch and have it overwrite the old one, so if a file is deleted from a folder, then the excel table will not reflect that deleted file. Essentially i am looking at creating an excel table that will act as a log of everything in the sharepoint folder. A log that reflects the current data, not anything that has been removed. Should i close this thread and start a new one? 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,818)