Power Platform Community Forum Thread Details

Hi PowerApp pros, I followed the video posted by one of the best power app expert Reza Dorrani on Power apps exporting Large Data to email, CSV or PDF, it is an amazing video and solved many of my problems. However, I need little help in achieving my result, appreciate your help in this. After creating the flow to run from the power app he uses the command.

//'ExportEmployeeIT-New'.Run("startswith(Title,'"& txtTaskTitle.Text &"') and Department eq '"& drpDepartment.Selected.Value &"'",User().Email); which works perfectly fine, my question is in the above command it's a must to fill the txtTaskTitle, if we leave empty and just use data from drpDepartment filter i get a blank email with the header but no data through flow.

My project is, I have 3 filters and search input, I need a formula to successfully run the flow even if i choose any one filter or even if I leave it blank all the 3 filters and enter any search term. Note currently all these are working perfectly fine and ima getting the results in my gallery galEmployeeListIT. But unable to send the results using Power automate