ปรากฏว่า

But after investigating, it turned out that the facts were different from what we thought.

I thought his assumption was correct, but it turned out he lied.

He deceived us so seamlessly that nobody suspected, but it turned out that the plan failed.