Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Kelly Knecht]

Hi Everyone,

I’m creating a number of forms (one per machine) that are triggered when a team member scans a QR code.  The QR codes are on the front of each machine.
The form is then populated with the possible maintenance tasks for that machine and the tech choses which options apply.
I have a flow populating the form details to an excel spreadsheet ‘Maintenance Master. 
 
I need the form name to be populated on the excel spreadsheet as it represents the specific machine. 
I’ve not found a way to do this in PowerAutomate. 

Has anyone been able to add a form name to an excel file through PowerAutomate?

Template being used: Track Microsoft Forms responses in an Excel Online (Business) spreadsheet
File is not in OneDrive (for IP reasons cannot show actual file location) it is an excel file in a SharePoint location

——————————
Kelly Knecht
Operations Support
Redmond WA
4257038005
——————————

[Koen Mathijs]

Hi Kelly,

after you added the row into a table you can use the function “Modify a row in a table” and add the name of the form.
I’m not sure if the name of the form is a dynamic value which you can retrieve from the form but it seems to me that you have a specific form for every machine so maybe you can hard code the name into the excel file?

Does that solve your problem?

——————————
Koen Mathijs
——————————
——————————————-

[Kelly Knecht]

Thanks I’ll give that a try.

 

 

Thanks,

 

Kelly Knecht, (Quala, Inc)

 

Program Manager | Advanced Prototyping Center | P:+1 (425) 703-8005

This email message may contain confidential and privileged information.  Any unauthorized use is prohibited. 

If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

 

——————————————-

[Kelly Knecht]

Hi Koen, 

Thank you for the assist. Through trying your process I found a simple solution. 

I added a column in the excel spreadsheet titled “Machine”.
In each flow I manually entered the name of the machine in that field. i used Keyboard as a beta test. 

——————————
Kelly Knecht
Operations Support
Redmond WA
4257038005
——————————
——————————————-

[Koen Mathijs]

Glad to hear you got it solved. This seems indeed the easiest way. 
Thanks for the update!

——————————
Koen Mathijs
——————————
——————————————-