Power Platform Community Forum Thread Details

I have a sharepoint list to keep track of the ordering status with the supplier.

I already had a flow where when the supplier gives me the quotation, it will download the file and create a folder for that quotation. The flow also generates the subfolder with suffix 'signed'. This is for me to sign the quotation manually, and deposit into this subfolder.

For example, the supplier will provide a quotation with a file name SO24-2502.pdf, then the flow generates an empty folder called SO-2502.pdf_signed.

Another example will be, a quotation with a file name ABC.pdf generated, then the flow generates an empty folder name called ABC.pdf_signed.

Now I want to create a flow that triggers the sharepoint list (shown below) to update the 'Quotation Signed Date" column (based on the date and time the file is uploaded to the folder), when the signed quotation pdf is uploaded into the 'quotation signed' file, which is dynamically generated in my separate flow.

Can someone suggest how to do this?

Thanks for your help.

Categories:

Building flows

Hi,

There is a way to do this.

In reality, there is no such trigger which helps to trigger when file is moved to another folder, as create/modfied trigger does not work in this case. So workaround would be you have download the file and then upload it to same sharepoint folder location by which you can use when file is created trigger and thus helps in running the flow. Something like below

Suppose i have created a folder quotations under document librray which has any subfolders for each signed files

Now Coming to flow design- see below

1. Use trigger when file is created so that it trigger when file uploaded to signed folder location as shown below

Also use this trigger condition in trigger so that it executes the flow when the file is created under specific folder which has the name of file _signed

Trigger condition - @endsWith(triggerOutputs()?['body/{Path}'],concat(triggerOutputs()?['body/{FilenameWithExtension}'],'_signed/'))

2. Now use get items action to get items in Sharepoint list based on name of file from below sp list

Use get items with below filter query

3. Use condition to check whether any items with name of file exists in SP list before updating date field as shown below

Expression -

length(outputs('Get_items')?['body/value'])
 
If condition is true, it means file details exists in SP list, so in yes branch use update item
 
Expression - 
first(outputs('Get_items')?['body/value'])?['ID']
 
Else other way would be to use modfied trigger so that when you signed , file becomes modified, for that you have to keep file in signed folder, modfiy it if you don't prefer download and upload of file.
 
Hope it helps !
Thanks & Regards,

Nived N 

LinkedIn: Nived N's LinkedIn

YouTube: Nived N's YouTube Channel

Blog: Nived Nambiar's Blogs

 Found my answer helpful? Please consider marking it as the solution!

 Your appreciation keeps me motivated. Thank you!