TC-43-003 - Excel selection and magic button
| Test Case ID | TC-43-003 |
| Author | Alena Galysheva |
| Date of creation | 13.06.2023 |
| Class | Functional |
| Type | --- |
Update history
- version 0.1 - 13.06.2023 - Alena Galysheva - test case created
- version 0.2 - 22.06.2023 - Alena Galysheva - test case updated
- version 0.3 - 05.07.2023 - Alena Galysheva - test name fixed
Test case description
This test case verifies the functionality of the FEA-43-power-automate-emailing.
Source for the test
This test is based on the following feature requirement:
- Use case: Use Case # 1 Creation of Hashes, Automated Email Generation and Delivery
- Feature: FEA-43-power-automate-emailing
Prerequisites and test steps
Prerequisites
- The feature implementation has passed the TC-43-001 test.
- Test data is prepared and entered into the Excel sheet.
- The basic functionality of Power Automate is operational.
Test steps
| # | Action | Expected result |
|---|---|---|
| 1 | Go to the Excel sheet. | The test engineer successfully accesses the Excel sheet. |
| 2 | Select a few users (not all). | The selected users are successfully chosen. |
| 3 | Hit the send button. | The send button triggers the Power Automate workflow for email generation and delivery. |
| 4 | Check the emails of all users. | The selected users receive an email, while the non-selected users do not receive any emails. |
| 5 | Select 0 users and click the send button. | The system provides an error message indicating that no users were selected and does not perform any further actions. |
| 6 | Check the emails of all users. | No new emails are received on any email addresses. |
| 7 | Change a couple of entries in the main Excel sheet to have invalid email addresses. Try to send emails again. | The system detects the invalid email addresses and prompts the test engineer to review and correct them before sending the emails. |
| 8 | Select at least 3 users in the main table, 2 of which have a duplicate email address. Click the Send button. | Only 1 email is sent to every email address. |
| 9 | Remove a hash from one of the email address. Click the send button. | The system detects the absence of a hash and prompts the test engineer to review and correct it before sending the emails. |
End state
Power Automate is triggered in the Excel sheet and functions as expected.
To be taken into account during test
N/A
PASS/FAIL Criteria
- PASS: All test steps are completed successfully, and the output matches the expected results.
- FAIL: Any of the test steps fail, or the output does not match the expected results.