Skip to main content
V
vyshnavig0001
March 12, 2025
Question

Bulk upload using excel and write to records

  • March 12, 2025
  • 2 replies
  • 0 views

Hi All. I hope all are doing good. I have a scenario and for that i need an idea on how to execute it. 

I have an excel sheet with data. I upload the excel sheet and fetch the data using expression rule and write it to records.

Here the output of expression is - List of dictionary :  Item 1 -  a:{ data in it } b: { data in it } ; item 2 - a:{ data in it } b: { data in it }.etc............

Here the data in "a" should be stored to a record and the data in "b" should be stored to b record.

Any ideas please let me know. Thank you in advance.

    2 replies

    mathieud0001
    mathieud0001
    March 12, 2025

    Have you taken a look at the following functions in the Excel Tools plugin?

    • Read Excel Cell by Name
    • Read Excel Cell by Number
    V
    vyshnavin653512
    March 13, 2025

    Hi [mention:213d84d7e74a4c32847efd6906fcf281:e9ed411860ed4f2ba0265705b8793d05] ,

    In addition to what Mathieu mentioned, you can also use readexcelsheetpaging() to retrieve the data, then iterate through the list to extract values for "a" and "b" separately. After that, you can use a!forEach() to loop through the extracted data and convert it into the appropriate format for storing in records.

    Terms & ConditionsAccessibility statement