Regression Suite Automation tool - Excel parameter values not being picked up

(0) Share

Report

Posted on by ShaunP

I hope someone has come across this before.

When I run RSAT on any of my automated test cases, its picking up the value I entered on the task recording, but not picking up the value I set it to in the excel parameter file.

Example

Create a test case to create a new PO, on the task recording I set the Business unit to 1000.

On the excel parameter file for that test case, I set the value of the Business unit to 1001, save the file and run the test case.

When checking the PO, its created it with the Business unit 1000.

Some info

I am not using LCS or BPM, just creating the test plan in Dev Ops, attaching the Recording to it, reloading RSAT to refresh the test cases, then generate the test execution and parameter files
I'm running the latest version of RSAT - 2.6.16196.59 HF 2
I tried putting a single quote at the beginning of the values I entered

All responses (2)

Answers (2)

Verified answer

ShaunP 28 on at

Like (1)

Report

Regression Suite Automation tool - Excel parameter values not being picked up

Thank you Kevin

In reviewing that document, I found my answer.

What I was missing was to select Generate AFTER updating the parameter file.

Its now working
Verified answer

Kevin Xia Microsoft Employee on at

Like (1)

Report

Regression Suite Automation tool - Excel parameter values not being picked up

Hi,

You can refer to this official document: Upgrade parameter files - Finance & Operations | Dynamics 365 | Microsoft Learn, the format of parameter Microsoft Excel files that are used with RSAT changed in the 2.0 release. or you can also refer to this official document: Use formulas as parameters - Finance & Operations | Dynamics 365 | Microsoft Learn. The RSAT uses parameter files where values can be changed for tests. You can specify fixed values or even use Microsoft Excel formulas to make values more dynamic.

Best regards,

Kevin