Table.InsertRows based on a condition

[MarkusEng1998]

I want to create a list of Architectural Sheets.

I have an input form, where an "x" means to create a sheet for that item.

In PowerQuery I map that Excel cell to a variable.

I am using the statement to insert a row for the sheet name.

= Table.InsertRows(#"GeneralSheets", 0, {[Sheet Name = "Overall Plan - Level 1"]})

However, I only want to insert the row, when the cell is checked with an "x"

Can I insert an if then else statement in this?

Thank you.

[amitchandak · Accepted solution]

@MarkusEng1998 , is adding a filter on that column is possible ?

[MarkusEng1998]

I see what you mean. In other words, I can add all of the rows to correspond to the Excel form, and then filter the column storing the "x."

Thanks!