Export to Excel: OrderNum includes thousands separator (comma). App Studio way to stop that?

[Mark_Wonsil]

At least for BAQs/Dashboards, I will create a calculated field for anything I want treated like a string like this:

'="' + table.field + '"'

and that will preserve the leading zeros.

You can also skip copy/paste altogether by using @amurdock’s code that pulls BAQs directly into Excel.

Pull REST data into Excel based on values on excel?

Here is the sample file I presented at Insights. You can use this to generate a full REST url complete with filters, sorting, select columns, and the number of rows to return. EpicorQuery - zHomepage_SOOpen.xlsx (112.7 KB) The key is a function in Power Query Editor to read the full URL from a table and cell value. In the attached Excel example it is reading the URL from the ‘Parameters1’ table, and the 11th row of the ‘Value’ column and passing that into the EpicorBAQ query. [image] [ima…