Hi all ; hi @trice602 , sorry to ping you here, I decided to find another way to do this flow. To put it again in context. Originally, this flow was working correctly. The main function was that in a group chat in Teams and when someone writes "OPP-XXXXXXXXXX" the flow will lookup details in excel and return specific data about that specific OPP.
Text inputs such as:
I want to view OPP-XXXXXXXXXX
Need update on OPP-XXXXXXXXXX
So the flow will look up the word "OPP" and then get the rest 10 digits, then proceed to look that number in excel and return the message in Teams.
this is my flow:
I am getting Error in the ParseJson part it says the error is :
{
"errors": [
{
"message": "Invalid type. Expected Object but got Array.",
"lineNumber": 0,
"linePosition": 0,
"path": "",
"schemaId": "#",
"errorType": "type",
"childErrors": []
}
]
}
Not sure where to change or extra step to do? Thank you in advance.
