Forum Discussion

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 12, 2023

Re: Update a collum in Excel from a Microsoft Form Submitted

ryanc23 

On the flow first is "Get response details" step. It returns Response Id for the triggered answer. Returned value for the filed will be like outputs('Get_Response_details)?['body/field_name'] which could be inserted  from dynamic contents on next step.

 

If with above response you'd like to add new row in some table in other Excel file, step will "Add a row into table" where you map fields in this table on the values received on previous step. For the each field that could be inserted value from dynamic content or some expression based on it.

 

If you'd like to update some row in that table, when you need to have Key column and key values within it. Steps will be Get Row and Update Row.

 

Above assumes form wasn't created from Excel Online and you don't receive responses into that file automatically.

No RepliesBe the first to reply