Testing flows

[N-Larose]

I want to implements an automated testing policy for flows.

However, I didn't really find a convenient way that :

• can garantee data isolation between test and production data
• allows testing in every environnement
• can be launched from ci-cd pipelines
• don't require to edit the flows

I was wondering, as we already planned to use it for apps, can testEngine be used to indirectly test flows by using a dedicated proxy app ? The most miraculous thing would be that a mocked connection in the proxy app would be usable in the child flow. But I don't believe such a magic can exist, right ?

The closest solution that I could imagine was :

• testEngine call the proxy app with preconfigured test data and test parameters in JSON format.
• The proxy app then insert the test datas into dataverse specific test tables (like the table used in the flow with a "-test" suffix)
• The proxy app then call the child flow with a "testMode" parameter enabled.
• The flow, previoulsy edited for such a case, update the variables that contains the table names in order to use the test tables instead.
• Once executed, the proxy app reads the written data, do the assertions logic (based on the JSON), clean the test tables and return a simple true/false state signal to testEngine.

I don't like this solution because it requires to edit the flows to test, also table suffix isn't the best data isolation strategy that we could dream.

Did anyone has any suggestion about this flow testing problematic ?