Hi everyone,
I'm developing an XLSX extractor for bulk changes in my sales APP. To do this, I'm using a Power Automate solution that places the Query in the OnSelect of the button.
I started by extracting CSV and everything worked fine. Then, within P. Automate, I built the path to fetch the CSV and transform it into XLSX via Script.
When testing in Automate it works normally, but when using the button in Power Apps it throws an error.
Problema ExportOpps.Run com falha: {"error": ["code":"MissingConnectionReference", "message":" referência de conexão 'shared_excelonlinebusiness' não foi fornecida pelo chamador."]} ##LINKO## Saiba Mais ##/LINKO## Local BtnExportCVS .OnSelect
I tried adding the Excel Online connector, but it asks me to specify the file location. However, the template I'm using in the flow is empty, it only has the Script. Here is the image of the Flow (it's in Portuguese - BR):
And the query I'm using in the onselect (power app Button):
ExportOpps.Run("OppCompany eq '"& DdwnExportCompany.Selected.Nome &"' and AbrrNomeOPP eq '"& DdwnExportCustomer.Selected.Value &"' and Customer eq '"& DdwnExportClient.Selected.'Nome do Cliente' &"'and OpptDescription ge '"& Text(DataInicioExport.SelectedDate; "yyyy-mm-dd") &"' and OpptDescription le '" & Text(DataFimExport.SelectedDate; "yyyy-mm-dd") & "'"; User().Email)
I'd like to know which path to take. What was supposed to be simple is getting more and more complicated. This solution will help me in the import process I will build next.
