Flow to capture form with wrong details keyed

%3CLINGO-SUB%20id%3D%22lingo-sub-2806622%22%20slang%3D%22en-US%22%3EFlow%20to%20capture%20form%20with%20wrong%20details%20keyed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806622%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20anyone%20have%20any%20recommendation%20for%20a%20flow%20to%20capture%20forms%20that%20were%20submitted%20with%20wrong%20details%20from%20responder%3F%20(*For%20example%2C%20if%20responder%20filled%20in%20the%20wrong%20Project%20ID%20and%20ended%20up%20with%20data%20not%20updated%20in%20excel.%20Therefore%2C%20email%20is%20triggered%20to%20responder%20about%20the%20error)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2806622%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFlow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2808892%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20to%20capture%20form%20with%20wrong%20details%20keyed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2808892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1141995%22%20target%3D%22_blank%22%3E%40qyaj9891%3C%2FA%3E%26nbsp%3Bthe%20only%20way%26nbsp%3B%20to%20do%20this%20-%20but%20it%20is%20a%20very%20good%20way%20-%20is%20to%20build%20a%20flow%20in%20Power%20Automate.%20I%20would%20have%20all%20the%20Project%20IDs%20in%20a%20list%20in%20SharePoint%2C%20perhaps%20in%20the%20Title%20column.%20The%20flow%20would%20look%20up%20the%20Project%20ID%20given%20by%20the%20responder%20and%20if%20it%20exists%20then%20the%20flow%20would%20carry%20on%20with%20whatever%20actions%20you%20want.%20But%20if%20it%20didn't%20exist%20the%20flow%20would%20send%20the%20responder%20an%20email%20asking%20them%20to%20re-submit%20the%20form%20with%20a%20correct%20ID.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!

1 Reply

@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