Share
Report
9I have a button in PowerApps that starts a flow to extract data from a list and send it to an email. The button starts the flow and provides data to the "Get Items" filter. This is the code:
ExportarTareas.Run("
substringof('"& FiltroLotis.Value &"', Licitaci_x00f3_n)
and substringof('"& FiltroLic.Value &"', Title)
and substringof('"& FiltroAdjudicasio.Value &"', Adjudicatario)
and Desierto_x002f_Adjudicado eq '"& FiltroEstado.Selected.Value &"'
and Avisos eq '"& FiltroAlertas.Selected.Value &"'
";
User().Email
)
This is based on a great video by Reza Dorrani: https://www.youtube.com/watch?v=UZdngrwWsqA&t=1078s
The problem is that I have introduced several filters that, if empty, return 0 records. How can I check if they are blank or empty and not use them? I don't know how to build the logic, but I understand that it should be something like this:
ExportTareas.Run("@if(not(empty(substringof('"& FiltroLic.Value &"', Title))), substringof('"& FiltroLic.Value &"', Title))");;
this is not admited in powerapps, but I think its just a syntax problem, cause I'm really new in this.
Sorry if I'm posting in the wrong side. Please. help me! Thank you"
All responses (
Answers (
