You’re offline. This is a read only version of the page.
235
Hi Everyone, I have a cascading dropdown base on my SP lists. Now, I wanted to extend it by using textinput field. Dropdowns were fine, however, adding the textinput field into it doesn't work and give this kind error. Any advice? Thanks in advance.
Share
ReportDistinct(
Filter(
Source,
JobCategory = DropdownJobCategory.Selected.Result &&
EntityType = DropdownEntityType.Selected.Result &&
JobType = DropdownJobType.Selected.Result
),
InvoiceDescription
)
Distinct() creates a single-column table, not a single text string. If you want all the distinct values strung together try:
All responses (
Answers (
Concat(
Distinct(
Filter(
Source,
JobCategory = DropdownJobCategory.Selected.Result &&
EntityType = DropdownEntityType.Selected.Result &&
JobType = DropdownJobType.Selected.Result
),
InvoiceDescription
), Result, ", "
)Hope that helps,
Bryan
