TeamDesk.SelectView is a Power Query M function that retrieves data from a provided table and view. It also allows for the application of an additional filter for results.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
TeamDesk.SelectView(
url as text,
optional table as nullable text,
optional view as nullable text,
optional filter as nullable text,
) as tableDescription
Retrieves the data from provided table and view. You can also apply an additional filter for results.
Examples
Retrieve all meetings from List All view
TeamDesk.SelectView( "https://www.teamdesk.net/secure/db/57692", "Meeting", "List All" )
/* Output:
#table(
{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date( 2018, 10, 12 ), 10 },
// ...
}
)
*/
Retrieve today’s meetings from List All view
TeamDesk.SelectView( "https://www.teamdesk.net/secure/db/57692", "Meeting", "List All", "[Start Date] = Today()" )
/* Output:
#table(
{ "Starter", "Start Date", "Participants" },
{
{ ""Joe"", #date( 2018, 10, 12 ), 10 },
// ...
}
)
*/
Related functions
Other functions related to TeamDesk.SelectView are:
