Flow to populate a word document from excel table with calculated fields/column issues.

[Haus]

I'm having trouble populating some fields of a word document within a flow. The flow is fairly simple, see the snip below. The challenge seems to be that my excel table has some calculated fields/columns which produce responses based on the submissions within the form. For example, the user chooses the name of the Supervising Officer within the form, a column within the excel table looks up the supervising officer's cell phone number (based on another table within the excel workbook) and inserts it into the table. To this point, this works great, I've double checked the excel table and the calculated fields/columns are present and correct. However, when I try to insert the Supervising Officer's cell phone (calculated field/Column) into a word document, these fields come up blank. All fields within the excel table that are calculated fields, will not populate in the Word document. All of these calculated fields from the excel table are present in the Dynamic content and there I'm not getting any error messages from the flow. Documents are generated, just continue to be missing those calculated fields. 

Thank you for taking a look at this issue. If what I'm trying is not possible, I would appreciate a suggestion for accomplishing the goal. 

Tom 

[DamoBird365]

Hi @Haus 

Looking at your flow I am struggling to understand where you get the supervisors number from?  You appear to add a row to the table but that will not return the telephone number?  You would need to have a "get a row" action from excel in order to obtain the number you mention.  I have tried the same scenario using a vlookup and the returned value is a string as expected, so you shouldn't have any problems updating your word template with that new value.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[Haus]

Hello, 

Thank you for your reply. Your description of how this works is completely correct. The excel table that is populated via the Form has additional columns that are populated via a vlookup function to another table in another sheet in the excel workbook. When a new entry is made, the excel table is populated via the Form fields and the additional columns are populated via the vlookup. All of this is working correctly. 

You seem to be saying that I need to add a "get row" action step following the "add row into a table" action. I've not done this before, I'll play around with it, but have some questions, I hope you don't mind. 

Other than the additional "get row" action step, do I need to add any other action steps?

How will the "get row" action, know which row to grab?

Is there an example of this I could look at? 

Do I need to be concerned with the rate of entries into the Form, i.e. users submitting entries at the same time?

My organization recently moved from Google to Microsoft 365, which is great, but I had several "flows" in google that now need to be moved. The google process was not so involved. If this specific issue can be resolved now, it will help me with my other Flows that need to be built. 

Thank you, 

Tom 

[DamoBird365]

Hi @Haus 

In my example, imagine list of numbers 1 column as your supervisor name, you add it in the first action and then get it using the supervisor name as the key column and the dynamic value for the key value.

The get row will return the 2nd column (in fact all columns) in my example which was a vlookup.

Regarding the rate of entries, test test test, but if you are concerned you can limit concurrency of your flow via the elipses (3 dots ...) of the cloud flow trigger.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here