PL-500 · Question #160
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…
The correct answer is D. Run script action. The 'Run script' action in Power Automate for desktop executes Office Scripts (TypeScript-based scripts) within Excel. Office Scripts can read Excel worksheet data, transform it, and return structured output including JSON - making it ideal for converting tabular account data…
Question
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?
Options
- ARun Excel macro action.
- BGet selected cell range from Excel worksheet action.
- CRun VBScript action.
- DRun script action.
- ERead from Excel worksheet action.
How the community answered
(25 responses)- A4% (1)
- B4% (1)
- D84% (21)
- E8% (2)
Explanation
The 'Run script' action in Power Automate for desktop executes Office Scripts (TypeScript-based scripts) within Excel. Office Scripts can read Excel worksheet data, transform it, and return structured output including JSON - making it ideal for converting tabular account data to JSON for a CRM API bulk upload. 'Read from Excel worksheet' (E) retrieves data as a table but does not convert it to JSON. 'Run Excel macro' (A) runs VBA macros which are less suited for producing JSON. 'Get selected cell range' (B) is a basic read action. 'Run VBScript' (C) could work but is a less modern and less maintainable approach compared to Office Scripts.
Topics
Community Discussion
No community discussion yet for this question.