Create dynamic subfolders then trigger sharepoint list to update if subfolder has a file

(1) Share

Report

Posted on by Kehong

When email arrives, auto download the attachment from the email and add item on sharepoint list, also generating a dynamic folder

It then creates a subfolder in the dynamically folder that was generated earlier with a suffix "signed" added (e.g. SQ123 signed).

I need to sign the quotation manually and upload this signed quotation into this subfolder that's generated (e.g. SQ123 signed) and this will prompt the sharepoint list to update the "quotation signed date" to be the time stamp that the file is uploaded to this folder. How do I achieve this?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

I am sorry i do not follow you said.

Create dynamic subfolders then trigger sharepoint list to update if subfolder has a file

What does Trigger SharePoint list mean?

How does a file get into the Subfolder?

I think you are having the flow create the file, but you won't be able to "trigger" it which sounds like another flow.

after you create the file in this flow, update the record yourself in sharepoint from this flow.

Was this reply helpful? Yes No
Kehong 43 on at

Like (0)

Report
Copy link

Link copied!
My flow is:

When I receive an email, it saves the attachment

Add a row on the sharepoint list with the name of the row being the attachment name (e.g. SQ123)

the flow also creates a folder in the sharepoint library based on the date this flow was triggered (in the format of attachment name concatenated with the date yyyyMMdd e.g. SQ123-20240906)

it also creates a subfolder e.g. SQ123-20240906-signed. This is the folder where I need to drop a file in, and the file will trigger the sharepoint list to be updated. This should update the list with the date the file is added to this folder under the column "quotation signed date". I am not sure how to do this step.

Was this reply helpful? Yes No