Microsoft Power Automate RPA Developer — Question 42

A list of accounts pending payment is generated from SAP as a Microsoft Excel file on a local machine.

Data must be converted into JSON format for a bulk upload to a customer relationship management (CRM) system.

You need to recommend a solution.

Which solution should you recommend?

Answer options

• A. Run Excel macro action.
• B. Get selected cell range from Excel worksheet action.
• C. Run VBScript action.
• D. Run script action.
• E. Read from Excel worksheet action.

Correct answer: D

Explanation

The correct answer is D, 'Run script action,' as it allows for the execution of a script that can handle the conversion of data into JSON format. The other options, while useful for various tasks in Excel, don't directly facilitate the required conversion process for the bulk upload to the CRM system.