Exam PL-500 topic 5 question 56 discussion

BD - because they forgot to mention that the table has headers

BD is right .Tested

You must access via index for row by Index or Column name for columns

chatgpt: BD

B. %ExcelData[4][0]% D. %ExcelData[4]['Column1']%

anser is B& D > https://www.examtopics.com/exams/microsoft/pl-500/view/29/ but it is false it should be ExcelData[3][0] to access the 4th line and 1st column. Rows and Columns are indexed by 0

D is the only one correct. I tried with step - Read from Excel worksheet. and then Set Variable. You can only use index > 0 for both row and column.

According to this link https://learn.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types the structure is as follows: %ExcelData[rowNumber]['ColumnName']% %VariableName[RowNumber][ColumnNumber]% I replicated the exercise in desktop flow and B and D are correct. Consider that the "Read from Excel worksheet" action has the property "First Line of range contains column names". if it's false, it takes as the first row the headers, hence, you will have the fourth row with the information. But, if it's true, you will have the fifth row. Due to Index starting from [0] and in this case, you will change the Column1 to the Header Name Column.

%Datatable[RowIndex][ColumnIndex]% %Datatable[RowIndex]['ColumnName']%

I am not sure if this is correct at all. First as @BayerischerSchweizer said there is no such action, but additionally the fourth row is index 3. So correct answers should be %ExcelData[3][0]% or %ExcelData[3][Column1]% as there is not mentioned that there is a header or I am missing something.

AC. B can't be the answer. 0 doesn't refer to column 1.

Actually I am not so sure here. First of all there is nothing as "Read data from table" (PAD newest version Jan. 2023). There is an action which is called "Read from Excel Worksheet". Table would mean a formatted table in Excel which I cannot find anywhere in PAD. If you want to access a single value then it might be Answer C %ExcelData['Column1'][4]% at least this is what my tool shows.

correct.

Correct, IF the first column is called 'Column1'