Need help for a simple try otherwise query

[andi2333]

Hello, I am pretty new to powerBI and this forum and I am seeking help for a seemingly easy case.

I am trying to load data from multiple excel sheets which are all in a folder. Each sheet has multiple tabs with changing names. I only need data from one tab from each file.

I was trying to handle this with the following statement, but now I have problems with the syntax for the 2nd error case....basically I am trying to create a nested try-otherwise statement, but I am not sure if such a thing even exists.

#"Order List_Sheet" = try Source{[Item="Order List",Kind="Sheet"]}[Data] otherwise Source{[Item="OrderList",Kind="Sheet"]}[Data] otherwise Source{[Item="Order list",Kind="Sheet"]}[Data],

Any help on this is much appreciated.

Thanks

[AndrewPF · Accepted solution]

I think you may need another "try": 

#"Order List_Sheet" = try Source{[Item="Order List",Kind="Sheet"]}[Data] otherwise try Source{[Item="OrderList",Kind="Sheet"]}[Data] otherwise Source{[Item="Order list",Kind="Sheet"]}[Data],