A user asked for guidance in their ControlUp Workflow, which involved retrieving data from Intune and ControlUp Desktops and merging it into a single array using the Union action. They had several questions about the process and whether they needed to explicitly convert the results into arrays, iterate through the lists manually, or use the output arrays from previous actions. The user also asked about how to specify matching based on serialNumbers. Another potential approach was suggested, but the user preferred a cleaner array-based solution. A ControlUp team member explained that the feature to merge properties for one object from two arrays is not currently available, so the loop option is the only option for now. No specific solution was provided in the discussion.
Read the entire ‘Exploring ControlUp Workflow: Guidance on Merging Data’ thread below:
I’m working on a ControlUp Workflow and could use some guidance.
Within the workflow I retrieve all devices from Intune and all ControlUp Desktops. My goal is to merge these into a single array using the Union action, but that doesn’t seem to work as expected.
A few questions:
• Do I first need to explicitly convert the results into arrays?
• If so, do I need to iterate through the lists manually, or can I directly use the output arrays from the actions?
• In the Union action, how can I specify that matching should be based on serialNumber?
The idea is to build a dashboard showing BitLocker data, based on a custom index, and only for devices that exist in ControlUp.
Alternative approach would be:
- Retrieve all ControlUp devices
- Iterate through them
- Look up the corresponding Intune device by serial number (filter option)
But that feels inefficient, so I’d prefer a cleaner array-based solution if possible.
Any suggestions or best practices would be greatly appreciated 🙏
Hello, as far i understand you want a union for elements from devices group with elements from Intune , where the serialNumber is "the same" , indicating we are talking about the same device.
That feature is currently not available so only the loop option exists for now, for the "merge props, for 1 object from 2 arrays/lists"
Continue reading and comment on the thread ‘Exploring ControlUp Workflow: Guidance on Merging Data’. Not a member? Join Here!
Categories: All Archives, ControlUp Dashboards