You’re offline. This is a read only version of the page.
8
Hello, I am new in Power Automate so it is hard for me to find out why I am receiving this error: The execution of template action 'Create_CSV_table' failed. The column values could not be evaluated: 'The template language expression 'item()['Data_compensarii']' cannot be evaluated because property 'Data_compensarii' doesn't exist, available properties are 'Angajat, Cerere_ID, Coef_Plata, Data, Data_Cererii, Echipa, Employee, End_Date, ModCompensare, Nr_Ore, Sef_Echipa, StatusV, Tip_ore'.
My flow looks like this:
The error that appears is:
but if I am looking at the Content step outputs I could find this type of records:
{"Angajat":"Boberschi Victor","Cerere_Compensare_ID":2,"Cerere_ID":1,"Coef_Plata":1,"Data":"2022-01-31","Data_Cererii":"2022-02-09","Data_compensarii":"2022-02-02","Echipa":"Automation","Employee":"Victor Boberschi","ModCompensare":"Compensat","NrOreCompensate":2,"NrOreNecompensate":0,"Nr_Ore":-2,"Sef_Echipa":"Cristina Dascalescu","StatusV":"Aprobat","Tip_ore":"Ore invoire"},{"Angajat":"Boberschi Victor","Cerere_ID":1,"Coef_Plata":1,"Data":"2022-01-31","Data_Cererii":"2022-02-09","Echipa":"Automation","Employee":"Victor Boberschi","End_Date":"2022-03-02","ModCompensare":"Necompensat","Nr_Ore":-2,"Sef_Echipa":"Cristina Dascalescu","StatusV":"Aprobat","Tip_ore":"Ore invoire"},{"Angajat":"Boberschi Victor","Cerere_ID":2,"Coef_Plata":1,"Data":"2022-02-02","Data_Cererii":"2022-02-09","Echipa":"Automation","Employee":"Victor Boberschi","ModCompensare":"Nu e necesar","NrOreCompensate":2,"NrOreNecompensate":0,"Nr_Ore":2,"Sef_Echipa":"Cristina Dascalescu","StatusV":"Aprobat","Tip_ore":"Recuperare invoire"}, etc
which contains 'Data_compensarii'.
If I Create CSV table with automatic columns the flow works fine and the csv file contains 'Data_compensarii':
but when I use custom columns for Create CSV table appears error mentioned above.
Please let me know if more details are needed to understand my issue. Is the first time when I am asking for support.
Try the following expression in the Custom action for the Data_compensarii property:
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Hi @CristinaD ,
The value in column "Data_compensarii" is only available in first object and when you do custom mapping it needs to be non null to be mapped. If you are not intending to export this column you can ignore that field in mapping.
Thanks
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
