Share
ReportHi,
I have created a flow which follows the below procedure.
1. Capture responses from Microsoft Forms.
2. Compare the Form response of a particular question with MS Excel on OneDrive and pick details of a particular Row.
3. Create Work items in Azure DevOps if based on the values available in the MS Excel details captured on that row. (Create if 'Yes' else terminate flow)
4. Send an email notification to the User who submitted the form along with details of the work items created.
There are inconsistencies with #3; the MS Excel which is used to create the work items has Yes and No marked in its values. However, the work items are not created for everything that is marked as "Yes" consistently. I have tried to check if there are any spaces in the values, 0 or 1 instead of Yes or No, case sensitivity and still the result is inconsistent as few work items for Yes and created and others are not. It varies differently for each test run.
Has anyone come across with something similar in your experience?
All responses (
Answers (
516
