Hi @Anonymous,
Could you please share a screenshot of the run history of the flow when an item has been created and the email is sent out?
What is the type of the "NoOpportunity" column in your sharepoint list?
What is the value in the "NoOpportunity" column when an item has been created?
I afraid that the "Create record" action haven't run due to the Condition 2 in your flow.
Do you want to create the record when the value in the "NoOpportunity" column isn't equal to No?
Please share more details so we would try to provide a proper workaround for you.
Best regards,
Alice