Skip to main content

Hi everyone! I need to build an action flow which will send an excel file attached, I followed the steps on the documentation, but I am getting an error and I am not sure how to solve it. I took step by step on the process.... Any advices? thanks a lot

It looks like the error is saying the data you're trying to insert into the sheet doesn't have the same shape. Based on the module, you need to insert values in those rows.

 

Right now, those rows are returning NULLs/No data, so it does not have a shape to insert. You'll likely need to insert data points to be able to insert rows.


It looks like the error is saying the data you're trying to insert into the sheet doesn't have the same shape. Based on the module, you need to insert values in those rows.

 

Right now, those rows are returning NULLs/No data, so it does not have a shape to insert. You'll likely need to insert data points to be able to insert rows.

Thanks Matt! I could solve it!!

one question, I do have in the sheet a column for price, but it's coming as euros, I a trying to find a way to convert it to USD. Do you have any ideas? thanks!

 


Also, it´s sending several emails with the information, I just need the file to be sent once...


Thanks Matt! I could solve it!!

one question, I do have in the sheet a column for price, but it's coming as euros, I a trying to find a way to convert it to USD. Do you have any ideas? thanks!

 

You can do this in the data transformations. There should be a currency conversion transformation that allows you to convert. If not, you should be able to do some mathematical functions to adjust them within the action flow


Also, it´s sending several emails with the information, I just need the file to be sent once...

You have to tell the "Create XLSX file" or whichever module that creates the Excel file to make the Query Data Module the source.

 

imageEssentially, you're telling the action flow to wait until each bundle goes through the execution and then build the Excel file


Reply