@Keegancurrie
Hello and thank you kindly for the great explanation.
Is your struggle with sending them to Power Automate, or from Processing them once you get them there?
To just send,
1. Use the Power Automate (V2)
-Create 2 input parameters (both strings) -- please note, feel free to add whatever else you want also as extra inputs
--let's call the first one EquipmentJSON
--let's call the second one EmployeeJSON
NOTE: If you used a different trigger such as the V1 trigger, please delete that trigger, and re-add the V2 trigger.
2. Add your Flow to the Application.
If you have already, and you will need to go to the Flow Tab (clicking the Flow Icon on the left side) and click the ... and choose refresh from the popup. This will make it understand that you changed the flow.
If you have not, just add it here by clicking Add Flow.
NOTE: please make sure you created the Flow In your Solution or you wont see it.
3. To pass it to the Flow, pass it like this
MyFlow.Run(json(myequipmentcollection), json(myemployeecollection))
using the json expression to convert the string to a JSON string
4. We want to use Parse JSON to turn these into nice JSON objects, but right now they are just json Strings. To do this will take a couple of pre-steps.
Step A) Create a Dummy Flow inside your Solution, (there are other ways, Im just showing you a trick you can use later on)
Step B) set the Trigger to Power Automate (V2)
Step C) Add your inputs EquipmentJSON and EmployeeJSON
Step D) Add to Compose Actions
In each one put one of the Inputs (doesnt matter the order)
Step D) Add this to your Application
Step E) Call this (instead of the real flow)
Run the app one time.
--We want this so that we can have an example of what the JSON will look like.
Now that you have that, change your App to call your real flow and start back at step 5
5. In your flow, you can add 2 Parse JSON actions.
--In the first one you would have the input as your Trigger Input Equipment JSON
--In the second one you would have the input as your Trigger Input Employee JSON
Now, you will want to click the Create Schema from an Example button.
We want to use the JSON string that you created in the Compose OUTPUTS, in your dummy flow, but we also want to validate the JSON.
NOTE: a great way to validate the JSON
i) download and installed Notepad++
ii) install the jsonviewer plugin (its free and safe)
iii) once installed click File/New in Notepad++. On that tab paste in the one of the Compose outputs from the tab. Then click Plugins, select JSON Viewer, then select Format as JSON. You can also paste this into your
So once you have validated it, copy it and paste THIS into the Schema Example Button Popup for its respective Parse JSON
6. Now you have both objects as nice Parse JSON objects and you can see its dynamic properties etc.
What I do not know is how you want to loop through etc. So please do the above steps and then explain how you need to loop through and join the data together? so that it can then be output into excel
Steps for Excel
A) you need to have an excel file already existing, with a Sheet and a Table in the sheet for you to add data too. You could create a file (that is sort of used as a templet). When this flow runs, it would make a copy of that file, and then modify/add/delete rows in THAT copy/table instead of your "template".
NOTE: its not really a template in the true sense, its just a file you dont change.
B) loop through your collections, which are easy now thats in a Parse JSON format
C) use the Add a row to a Table (Excel) action to write the data
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
