Power Platform Community Forum Thread Details

Hi,

I have an excel sheet and i want to write a specific value to a row that I have searched for using 'find or replace in data table'

I have found the value I was looking for and now want to write a value to a specific column in that excel.

See the row and column index of the value i searched for. I now want to write a value to column 7 of that row I found. Thanks for the help

Categories:

Power Automate Desktop

%DataTableMatches2% is a data table, so you also need to indicate a row index, and not only a column name. Use %DataTableMatches2[0]['Row']% instead.

If it fails saying it requires a numeric value, it might be because the indexes in %DataTableMatches2% are returned as strings (no idea why PAD still does that). You would probably need to convert %DataTableMatches2[0]['Row']% to a number using Convert text to number and then use the resulting number as the row index in Write to Excel worksheet.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.