Share
Report
70I'm not sure where I did wrong.
The flow works but it won't get all the items based on all the filters. The exported file should have all the items that is shown in the filtered gallery.
It works when Country is only the filter or if Country and Launch Year/Brand Name, but incorporating the rest doesn't. Below is the code I used.
// run flow
Set(_varExcelFile,
Export_Dev_V2.Run("Country eq '"& Country_cb.Selected.Value &"' and (substringof('" & LaunchYr_inp.Text & "', LaunchYear) or LaunchYear eq null) and (Category eq '"& Category_cb.Selected.Value &"' or Category eq null) and (substringof('"& Brand_inp.Text &"', BrandName) or BrandName eq null) and (Source eq '"& Source_cb.Selected.Value & "' or Source eq null) and (Status eq '"& Status_cb.Selected.Value &"' or Status eq null)").linkoutput);
// download the file to Excel
Launch(_varExcelFile);
Below is the flow.
I was thinking of a workaround (exporting by putting them in a Collection first) but I'm not really sure how to collect all items in a paginated gallery
Categories:
I have the same question (0)
All responses (
Answers (
