Power Platform Community Forum Thread Details

Hi all,

I am trying to update an Excel sheet based on data in one column using Power Automate Desktop (PAD). In the example below, I need to update the ID column and Description column based on the Units column data. The ID column data should sequentially increase automatically in the format A1, B1, C1, D1, A2, B2, C2, D2, A3, B3, and so on. The Description column should update based on the Units column data. For example, if the Units column contains "KG," PAD should update the Description column to "Kilogram"; if it contains "ML," it should update to "Milliliter"; if it contains "CM," it should update to "Centimeter"; and if it contains a 9-digit integer, it should write "Sample." Please guide me on how to achieve this. Thanks in advance!