I am looking to create a flow that:
1. Gets a specific record in Dynamics 365 and the field values of that record.
2. Then I would like it to take those field values and either populate a table inside an single excel model (think of this as a pricing model for an opportunity, rather than a table for aggregate analysis) that is stored in OneDrive.
I would like it to populate specific cell references inside of a single excel model i.e put Opportunity Name in cell A12 and Price in cell B9
So far, I have not been able to find an integration that does the latter. It seems like the "Add Record" excel action would do the trick, but to no avail so far. Seems like a straightforward task so I want to see if any in the community has done this already.
Hi there, welcome!
Short version: Yes, I think it's totally possible, but have a couple of clarifying questions.
Hi @ehatem ,
As far as I know, the existing actions in MS Flow can only insert data into Excel table, and cannot directly insert data into the cell specified in the Sheet.
If you want similar features to be supported by MS Flow, please consider submitting your suggestions in the Flow Idea forum:
You could also consider defining an Excel table in an Excel file and creating two fields, Opportunity Name and Price.
Then use Add a row into a table action to insert the data in the specified record into the table.
Definitely add the data to a table, but then couldn't @ehatem use a macro to copy the data to the appropriate fields? I think I saw somewhere about launching macros from PowerShell, and then running PowerShell scripts from Flow.
Inelegant, but doable. Depends on the mission, right?
Answers to your questions in italics:
1. What are you wanting to trigger the whole thing? Or is this a manual process?
The trigger would be clicking on "run a flow" from within a Opportunity record in Dynamics 365
2. What information will you use to select the correct record in D365?
The Opportunity record ID, although I am not sure of the mechanics of referencing the Opportunity ID of the record that a flow was launched from.
3. Are you looking to populate/update a specific row in Excel? Or just add a row at the end? In your second example, would it always be the same cells (ie A12, B9)? Or will that change for each record from D365?
My ideal solution would be populate specific cell references in the excel model. e.g. put Opportunity.Amount in cell B75. It would always go to the same cells in the excel model.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Find your favorite faces from the community presenting at the Power Platform Community Conference!