Hi @Shoaib_PAD ,
This could be a delayed revert for your post, But It would help some other aspirants who wants to achieve this use case.
I recently read your post and attempted to create a workflow for your post in PAD, similar to Config Variable we use in UiPath RE-Framework.
However, I was not able to find a direct action in PAD for creating a Dictionary object for our scenario. Nevertheless, I was able to achieve the same result by converting the Excel data table to a valid JSON file and then using the 'Convert JSON to Custom Object' action.
To create a config dictionary, please follow these steps:
- Read the Excel file.
- Loop through the data to create a JSON-like string.
- Ensure that you replace the backslash symbol with double backslash ( \>\\ ) to avoid errors while accessing file paths.
- Drag and drop the 'Convert JSON to Custom Object' action, pass the previously created JSON text, and use the Output variable as 'config'. This can then be used as a config variable, similar to the UiPath RE-Framework.
- To access the data, use Config['Key'] to return the value associated with the key.
Please check the below PAD screenshots with the steps I have used to achieve the same.
Happy automation!
Flow Dev screenshots in PAD :
Flow dev Screenshot 1
Flow dev Screenshot 2
Flow dev Screenshot 3
Output Screenshots :
Screenshot Display message input screenshot
Display message output screenshot.
