Hello all,
I have a Kaizala custom action where a teacher fill attendance form, and they have to record their location along with class name, subjects, etc.
I have created automated flow of "When someone responds to a custom action" -> "create sharepoint item" so our admin staff can work on the attendance data in sharepoint.
The problem is I cannot get the location data from Kaizala (named "Answer 5") to be stored in sharepoint column named "address" (a single text type column). When putting the dynamic content of "Answer 5" into Sharepoint create item action, Flow gives error:
Object must implement IConvertible.
clientRequestId: 39ca9e6a-a891-4dbb-9009-9c9f91febbee
serviceRequestId: 39ca9e6a-a891-4dbb-9009-9c9f91febbee
Looking at the error data, its seems that the output from Kaizala is something like this:
{
"lt": -7.984112,
"lg": 112.6589507,
"n": "Jl. Raya Ki Ageng Gribig Kav.No.1d, Lesanpuro, Kec. Kedungkandang, Kota Malang, Jawa Timur 65138, Indonesia",
"acc": 17.79400062561035
}
I want to put just the "n" data into the sharepoint column, ignoring other data (lt, lg, acc).
How can I achieve that? Thank you for the help.
