How do I manage permissions with a try/otherwise?

[Netrelemo]

I am pulling data from a series of SharePoint lists. using a custom function. It may happen that I don;t have permission to a particular list. How do I manage that? 

...
try
     GetProducts([URL])
otherwise
      Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8svPS1WKjQUA", 
      BinaryEncoding.Base64), Compression.Deflate)),
      let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t])
...

This doesn't work. 

Sure, if the list has no contents it's fine and a create a "None" response, but if I don't have permission to the list, then I have a fail.

How do I work with that?  

[parry2k · Accepted solution]

@Netrelemo maybe use try otherwise in your function GETPRODUCTS

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy. 

[Netrelemo]

Sounds right, but what is the syntax? 

let
    Source = (FM_URL as any) => 
    let
        // listSource = OData.Feed(FM_URL, null, Implementation="2.0",IncludeAnnotations=""]), 
           Source2  = try 
                            SharePoint.Tables(FM_URL, [ApiVersion = 15])
                      otherwise
                            .....
    in
        #"Renamed"
in
    Source