URGENT-How to retrieve data from kobo repeat group for email notification with attached file

[Maroon]

Hello, Is it possible to show data from kobo repeat group in word/excel attachment with email notification. If someone could help, please let me know. Thanks…

[Kal_Lam]

Hi @Maroon,

Welcome to the community! If you wish to retrieve data from within a repeat group you could do it as outlined in the post that has been discussed previously using some third party software:

Using SPSS to Merge Data from the Different Sheets in XLS from a Form that had Repeating Groups using SPSS

Hi @fieldwork19 To fully do what you are looking for i is important to note the following behaviors around KoBoToolBox & integrating IBM (SPSS) 1… If you have repeating groups KoBoToolBox stores each group within its own sheet in the excel. The repeats from one questionnaire administration (instance) will be linked to the main part (non repeating) questionnaire with the index (I believe you already knew this.) When working with SPSS or event STATA there are two data formats, long format a…

Have a great day!

[Maroon]

Hi @Kal_Lam, thanks for reply. Email notification (MS Flow). Following this link, I could extract data from kobo server but not data from repeat group even same kobo form by using ms flow. could you help with me in this issue?

[Kal_Lam]

Hi @Maroon,

Were you able to see the repeat group data while downloading your data in the xls version?

Have a great day!

[Maroon]

Hi @Kal_Lam, my question was different. I am trying to use ms flow for email notification which means I want to get auto emails whenever I submit data to kobo server. In this email, I also want to attach document (word or excel) that include data for particular submitted record. In this case, I could only extract data from kobo form exception of data from repeat group. The repeat group is also part of form. I want to include data from repeat group as well in attached document from auto email when submitted. Using three steps for email notification. See the screenshot which I attached. thanks.