web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

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

(0) ShareShare
ReportReport
Posted on by 28
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
 
I have the same question (0)
  • Verified answer
    ShaunP Profile Picture
    28 on at
    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 Profile Picture
    Microsoft Employee on at
    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 LearnThe 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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 825 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 763 Super User 2025 Season 2

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 601

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans