Forum Discussion

qyaj9891's avatar
qyaj9891
Copper Contributor
Oct 03, 2021

Flow to capture form with wrong details keyed

Hi, anyone have any recommendation for a flow to capture forms that were submitted with wrong details from responder? (*For example, if responder filled in the wrong Project ID and ended up with data not updated in excel. Therefore, email is triggered to responder about the error)

 

Thanks!

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    qyaj9891 the only way  to do this - but it is a very good way - is to build a flow in Power Automate. I would have all the Project IDs in a list in SharePoint, perhaps in the Title column. The flow would look up the Project ID given by the responder and if it exists then the flow would carry on with whatever actions you want. But if it didn't exist the flow would send the responder an email asking them to re-submit the form with a correct ID.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources