Power Platform Community Forum Thread Details

I am quite new to PowerAutomate

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.

My current attempt of the flow is shown below:

Filter Query: substringof('@{triggerOutputs()?['body/{FilenameWithExtension}']}',QuotationNo)

What I want to do is when the file name contains a substring of the QuotationNo on sharepoint, it updates the item on sharepoint

(i.e. if the file uploaded has a name "SQ24-1213C Quote for Spare Parts.pdf_Signed.pdf", then I want the "Quotation Signed Date" column for item "SQ24-1213C Quote for Spare Parts.pdf" to be updated.