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 :
Not sure where to change or extra step to do? Thank you in advance.
Hi, I just updated, it is working now, all good ! thank you !
Your PARSE JSON schema is incorrect.
You first node should be an array if you want to parse items returned by the Filter.
Regenerate the JSON schema or share the output of your Filter array and I will create a schema for you.
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional