Unanswered

Updating File Properties based off SharePoint List

(0) Share

Report

Posted on by ccolletti

Hi All,

I am working on a flow for my company that would update the properties for a file within a SharePoint folder. How I'm trying to get this to happen is based off a SharePoint list that is pulling data from our database system.

For context, the folder we have set up is loading up with purchase orders to be worked and we have multiple columns added in to help determine how they are worked. One column I'm attempting to update is our Direct Deliver column, which is a Yes/No column set as a check mark (Yes = check mark).

In order to update this automatically, I want to utilize a report that has it's own flow to fill in a SharePoint List. I'm looking to connect the list to the folder by looking for the PO number. However, I am currently having issues actually accessing the folder in SharePoint. In my research I was seeing the use of the "Get Folder Metadata." This got me to the point that my "Get Files (Properties Only)" wouldn't come back with a null value, but it is not pulling in the correct folder and files.

Is there a better way, or something I'm missing to pull in the specific folder I want to access? Also, I have my current flow below, does anyone have any additional advice to help me get this flow to work correctly? Thank you all for your help!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-jefferni on at

Like (0)

Report

Hi @ccolletti ,

Could you please share more details about your scenario? If you know the exact folder and need to limit files to that folder, why not directly set in the "get files" action by picking up the folder?

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
ccolletti 60 on at

Like (0)

Report

@v-jefferni , thank you for getting back to me. I actually was able to figure out why I wasn't able to go directly to that folder using the Get Items (originally I was getting errors saying the list didn't exist). I needed to updated the Pagination to allow this action to gather the large number of files.

However now, I'm having difficulty connecting this folder and my SharePoint list in the Apply to Each 3. I have another flow that utilizes the query of Title (folder) equals the Title (list) using
items('Apply_to_each_3')?['Title']. In this other flow it does work to connect both items to allow me to make edits through the flow.

I ran a test where I utilized the Compose action to record the total number of records from the Get Items (list), but this came up with 0 records. I know there are some that do match, just not sure what I am missing to make sure they register.

Thank you for your help!

Was this reply helpful? Yes No