Forum Discussion
Record.Field(_, projNo) as parameter for a JSON Document Web Contents
I use the Json.Document(Web.Contents(....)) to request data. I created a function where I can extract the information for a single project using [projNo]="01" I have a separate table with the ...
Thank you latimeria, I figured out my issue. I was calling my function incorrectly!
Instead, I needed to Invoke Custom Function (Add Column tab) to call the function.
This is my solution:
= Table.AddColumn(Source, "getProjectURI", each getProjectURI([projNo], "rooms", #"101mapRooms"))I had tried to simplify the function but eliminated a key component as you noted:
#"FilterColumnTable"
Thank you for your patience. I am learning slowly.