I'm trying to filter 3 column data using "ComboBoxes" and "Search Input". I pull the data from main table using the filters in a collection specifying the filter conditions applied on the ComboBox. But it throws me this error saying "Error when trying to retrieve data from the network", and none of the data is getting populated.
I used this query to pull the data. It worked very well when I had not yet added the "Total revenue" column. Can someone please let me know why the filter fails when I add the columns I want the data for?
ClearCollect
(
Collection_Show_Data,
Search(
Filter(
Filter
(
MMStoreListAutomate,
Region=ComboBox_Region.Selected.Result || IsBlank(ComboBox_Region.Selected.Result),
Retailer=ComboBox_Retailer.Selected.Result || IsBlank(ComboBox_Retailer.Selected.Result)
),
Total_x0020_Revenue
),
GLID_Input.Text, "Global_x0020_Location_x0020_ID"
)
);
Data_Export_Flow.Run
(
JSON
(
Collection_Show_Data,
JSONFormat.IncludeBinaryData
)
);
