Flow sending forms results in a sharepoint list: error invalid template

%3CLINGO-SUB%20id%3D%22lingo-sub-2759497%22%20slang%3D%22fr-FR%22%3EFlow%20sending%20forms%20results%20in%20a%20sharepoint%20list%3A%20error%20invalid%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2759497%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20flow%20that%20collects%20data%20from%20a%20forms%20and%20creates%20an%20item%20in%20a%20sharepoint%20list.%3C%2FP%3E%3CP%3EData%20in%20the%20form%20are%20collected%20correctly%20but%20I%20get%20an%20error%20when%20Creating%20the%20item%20in%20the%20list%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EInvalidTemplate%3C%2FSTRONG%3E%3CSPAN%3E.Template%20language%20expressions%20cannot%20be%20processed%20in%20the%20%22Create_item%22%20action%20entries%20in%20row%20%221%22%20and%20column%20%2246284%22%3A%20%22The%20template%20language%20function%20%22formatNumber%22%20requires%20two%20parameters%20(plus%20an%20optional%20third).%20The%20first%20parameter%20must%20be%20the%20number%20to%20be%20formatted%2C%20the%20second%20a%20numeric%20format%20string%2C%20and%20the%20third%2C%20which%20is%20optional%2C%20a%20locale%20string%20(by%20default%2C%20%22en-us%22).%20The%20function%20was%20called%20with%20the%20parameter(s)%20%221%22.%20For%20usage%20details%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Flogicexpressions%23FormatNumber%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Flogicexpressions%23FormatNumber%3C%2FA%3E.%C2%BB.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20only%20have%2070%20columns%20so%20I%20don't%20understand%20where%20column%2046284%20comes%20from...%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAny%20ideas%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBelow%20is%20my%20flow%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Charlotte_Somny_0-1631867498097.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311007iC5C68FEFA27C42CE%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Charlotte_Somny_0-1631867498097.png%22%20alt%3D%22Charlotte_Somny_0-1631867498097.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Charlotte_Somny_1-1631867513105.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311008iC7D20FF78D0016A9%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Charlotte_Somny_1-1631867513105.png%22%20alt%3D%22Charlotte_Somny_1-1631867513105.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Charlotte_Somny_2-1631867539994.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311009i124CFB37A517D7ED%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Charlotte_Somny_2-1631867539994.png%22%20alt%3D%22Charlotte_Somny_2-1631867539994.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Charlotte_Somny_3-1631867565299.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311010i0817317822993ED2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Charlotte_Somny_3-1631867565299.png%22%20alt%3D%22Charlotte_Somny_3-1631867565299.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Charlotte_Somny_4-1631867597182.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311011i8F487825A0251C27%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Charlotte_Somny_4-1631867597182.png%22%20alt%3D%22Charlotte_Somny_4-1631867597182.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2759497%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2759634%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20sending%20forms%20results%20in%20a%20sharepoint%20list%3A%20error%20invalid%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2759634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1158776%22%20target%3D%22_blank%22%3E%40Charlotte_Somny%3C%2FA%3E%26nbsp%3BI%20think%20you%20created%20the%20flow%20from%20a%20Power%20Automate%20template%2C%20and%20the%20one%20for%20forms%20has%20an%20error%20as%20it%20puts%20the%20get%20response%20details%20action%20inside%20an%20apply%20to%20each%20which%20is%20incorrect.%20The%20get%20response%20details%20shouold%20follow%20immediately%20after%20the%20trigger%20but%20not%20be%20in%20an%20apply%20to%20each%2C%20as%20shown%20below%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Flow.png%22%20style%3D%22width%3A%20635px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311015iB650CA700E9B1180%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-Flow.png%22%20alt%3D%221-Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I have a flow that collects data from a forms and creates an item in a sharepoint list.

Data in the form are collected correctly but I get an error when Creating the item in the list:

 

InvalidTemplate. Impossible de traiter les expressions de langage de gabarit dans les entrées d'action « Create_item » à la ligne « 1 » et à la colonne « 46284 » : « La fonction de langage de gabarit « formatNumber » nécessite deux paramètres (plus un troisième facultatif). Le premier paramètre doit être le nombre à mettre en forme, le deuxième une chaîne de format numérique et le troisième, qui est facultatif, une chaîne correspondant aux paramètres régionaux (par défaut, « en-us »). La fonction a été appelée avec le ou les paramètres « 1 ». Pour obtenir les détails d'utilisation, consultez https://aka.ms/logicexpressions#FormatNumber. ».

 

I only have 70 columns so I don't understand where column 46284 comes from...

 

Any ideas?

 

Below is my flow:

Charlotte_Somny_0-1631867498097.pngCharlotte_Somny_1-1631867513105.pngCharlotte_Somny_2-1631867539994.pngCharlotte_Somny_3-1631867565299.pngCharlotte_Somny_4-1631867597182.png

 

4 Replies

@Charlotte_Somny I think you created the flow from a Power Automate template, and the one for forms has an error as it puts the get response details action inside an apply to each which is incorrect. The get response details shouold follow immediately after the trigger but not be in an apply to each, as shown below:
1-Flow.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Thanks for your reply.

 

I tried to take out the "get response details" and put it right after the trigger as you said.

I face 2 problems then:

- #1: it automatically creates an "apply to each" section as soon as I fill in the Response Id.

Charlotte_Somny_1-1631880563087.png

- #2: once I remove the get response details from the original apply to each section, I cannot find any data to link:

Charlotte_Somny_2-1631880759770.png

Do you have any idea why?

 

You must have the get response details. I would copy your actions to your clipboard then create a new flow from scratch and add the trigger and the get response details.

@RobElliott  Hi Robb,

 

Thanks, I tried building one from scratch as suggested.

Charlotte_Somny_0-1631884682922.png

Charlotte_Somny_1-1631884737969.png

I am getting an error, but I don't understand why...

Charlotte_Somny_2-1631884789475.png