I am building a PAD flow that is called from a Power Automate scheduled flow. The PAD flow checks various applications in use in our environment to check their status and attempt a sign in. The results are stored in a "child" list and that list is stored in a "master" list.
An example of how this data looks:
[
[App Name, Status Code, Status Message],
[App Name, Status Code, Status Message],
[App Name, Status Code, Status Message]
]
In trying to pass this data back to Power Automate, I found that it does not support passing array's to or from PAD; only strings. Trying to work with the string that's passed through is a nightmare. Ideally, the Power Automate flow after running PAD would iterate through the "master" list to append each "child" list to an Excel Spreadsheet.
Is there a known workaround to get this type of data from PAD to Power Automate? Or is there a better/easier way this data can be stored for passing back to Power Automate?

Report
All responses (
Answers (