Power Platform Community Forum Thread Details

Hi There, This is Sanket!!!

I'm new to Power Automate, but still want to create a little complex flow (complex for me).

We have form created using Power Apps, Users are updating required fields along with excel template as attachment, once uploaded attachment/ other details are getting uploaded on SharePoint list.

The expectation is that the user should upload a predefined excel template, if it is not a predefined template, flow should trigger an email saying, "Invalid attachment template, please upload a correct template".

Excel template has many sheets one of them is “Backend” flow to go to "Backend" Sheet >>> table “Validation” and check “B2” if cell" B2" contains "Valid" then it should pass the attachment else trigger email as shared in above line.

Also it should delete the line ( Details / attachment) which are uploaded on SharePoint. ( Or we can create flow in such a way that it will check validity of attachment first, if it is valid template then only it will get uploaded in SharePoint list

Requesting you to help me build this functionality in Power Automate.

Thanks in Advance.

Regards,

Sanket Katdare

Categories:

General topics