Power Platform Community Forum Thread Details

Hi All,

I have a form where there are two columns Status(choice column but in form I have used radio button to display colors) and Observation(single line of text). I have a Excel file where there are 6 columns - Phase, Area , check item, Code(these four are constant with 40 rows), and rest of the two columns are Status and observation which needs to get updated from the PowerApps form. Based on the code in the Excel file it must compare the code with the column name and update the two values. For Eg (the Code is PMC_BOB_BO and the column name would be PMC_BOB_BO_Status and PMC_BOB_BO_Observation). Comparing the code and column name it must update the Excel. Can anyone help or suggest what should be done on this. Thanks in advance.