Answered

Updating "File type" column for existing files in Sharepoint

(0) Share

Report

Posted on by waterni

Hi everyone,

I'm trying to use PA to update a column for a host of files already in Sharepoint. My idea was to use "For a selected file" as a manual trigger and just apply it to a folder containing just files or the lowest folder depending on how I can get this to work. I wanted to do this by getting the folder's properties using "Get file properties", run "List folder" to see what's inside, then use "Apply to each" to grab the file extensions then use that to update the "File type" column that I made.

When I try to use "Name" as the identifier, "Apply to each" nests itself like so

and returns this error when I test it.

I feel like the solution should be obvious, but I can't get past this part. Please help 😞

All responses (13)

Answers (1)

abm abm 32,472 Most Valuable Professional on at

Like (1)

Report

Re: Updating "File type" column for existing files in Sharepoint

Hi @waterni

Glad that all sorted and working. Thanks for accepting the solution.

Thanks
waterni 26 on at

Like (1)

Report

Re: Updating "File type" column for existing files in Sharepoint

@abm
I got it to work, the problem was the "Include nested items". If I change it to "No", it works but only for the items in that specific directory. Leaving it on gives me empty output. Thank you for your help.
waterni 26 on at

Like (0)

Report

Re: Updating "File type" column for existing files in Sharepoint

@abm
I tried the box templates but the return was the same.
abm abm 32,472 Most Valuable Professional on at

Like (1)

Report

Re: Updating "File type" column for existing files in Sharepoint

Hi @waterni

Try to create that flow using out of the box templates like in my video. See the initial part of the video. Then delete those unwanted steps.

Thanks
waterni 26 on at

Like (1)

Report

Re: Updating "File type" column for existing files in Sharepoint

@abm
I followed along with your video, the only difference is for "Get file properties", the "Id" in your video and mine was different so I entered for function you had associated there (triggerBody()?['entity']?['FileId']). I've tried it with just the regular Sharepoint "ID" but the results were the same.
abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: Updating "File type" column for existing files in Sharepoint

Hi @waterni

So that means you are not getting the anything from Get File properties step? You sure you mapped the right mappings in that compose?

Thanks
waterni 26 on at

Like (1)

Report

Re: Updating "File type" column for existing files in Sharepoint

@abm
Thank you for the video.
I've been following it but I'm running into a problem with the compose around 7:56. My outputs does not look like yours and just returns nothing.
Verified answer

abm abm 32,472 Most Valuable Professional on at

Like (1)

Report

Re: Updating "File type" column for existing files in Sharepoint

Hi @waterni

I made a tutorial video based on this. Please have a look and comment.

https://youtu.be/c192fYIGCXU

Thanks
abm abm 32,472 Most Valuable Professional on at

Like (1)

Report

Re: Updating "File type" column for existing files in Sharepoint

Hi @waterni

I will post something soon. I understood your requirement. Thanks for the clarification.
waterni 26 on at

Like (0)

Report

Re: Updating "File type" column for existing files in Sharepoint

@abm
It's something I found in a different post where someone was having problems with their path not being in JSON. turns "/" into "%2F"

Ideally, yes I am looking into folders within folders but I was prepared to run this only on folders without nested folders. I'm not certain how low many levels it goes up to but the highest I found was 10.