good morning, i've created a flow to send out an email from a table with specific attachments dependant on the previous options selected. the name of the attachment is generated using if statements dependant on previous cells. this should then be passed to flow where the result of that is used as the name of the attachment, however instead of passing the results of the cell it just passes #value! i've tried using a 2nd cell that trims the output of the previous cell again whilst the cell contents look fine it is passing #value!. tried value to text but again nothing.
unfortunately #value! searches only come up with results for value which is quite a few.
Is there any known issues that would prevent the actual results being exported?
this is the formula in the cell (edited to hide identifying info but the logic is same)
=IF(
AND(B2="var1",L2="Yes"),
CONCAT(
"company var1 under 5GWh T&C- ",
IF(AND(F2>=DATEVALUE("1/11/2020"),F2<=DATEVALUE("25/07/2020")),"Nov 2020",
IF(AND(F2>=DATEVALUE("26/07/2020"),F2<=DATEVALUE("7/07/2022")),"July 2021",
IF(AND(F2>=DATEVALUE("8/07/2022"),F2<=DATEVALUE("8/05/2023")),"Nov 2022",
IF(F2>=DATEVALUE("9/05/2023"),"May 2023")))),
".pdf"),
IF(
AND(B2="var2",L2="Yes"),
CONCAT(
"company var2 under 2m T&Cs - ",
IF(AND(F2>=DATEVALUE("1/11/2020"),F2<=DATEVALUE("25/07/2020")),"Nov 2020",
IF(AND(F2>=DATEVALUE("26/07/2020"),F2<=DATEVALUE("7/07/2022")),"July 2021",IF(AND(F2>=DATEVALUE("8/07/2022"),F2<=DATEVALUE("8/05/2023")),"Nov 2022",
IF(F2>=DATEVALUE("9/05/2023"),"May 2023")))),".pdf"),
IF(
AND(B2="var1",F2<DATEVALUE("9/05/23"),OR(I2="Guard",I2="Fixed",I2="Standard",L2="No")),
"var1 Terms and Conditions - Fixed.pdf",IF(
AND(B2="var1",F2>=DATEVALUE("9/05/23"),OR(I2="Guard",I2="Fixed",I2="Standard",L2="No")),
"Fixed var1 Terms and Conditions - 09.05.23.pdf",
IF(
AND(B2="var2",L2="No",F2<DATEVALUE("9/05/23")),"var2 Terms and Conditions - Fixed.pdf",IF(
AND(B2="var2",L2="No",F2>=DATEVALUE("9/05/23")),"Fixed var2 Terms and Conditions - 09.05.23.pdf"
))))))
Thanks in advance.
