Parsing inbound phone number in an SMS Workstream with PVA bot

(0) Share

Report

Posted on by rtraver

I have an Omnichannel SMS Workstream configured with a PVA bot. I am able to trigger the bot topics with a text message to a particular phone number, which is great. I am trying to discern if the PVA bot can grab the incoming phone number and pass it to a Power Automate Flow to filter a table in our Dataverse.

When I review the session logs in the PVA analytics area for my bot, I can see my phone number is captured in the ChatTranscript column (I've blocked it out in red):

I think that payload is getting passed from Dynamics/Omnichannel though, so I'm not sure how to grab the "PrimaryDisplayValue" key. Thanks in advance.

I have the same question (0)

All responses (2)

Answers (0)

Steve Zhao2 on at

Like (0)

Report

Hi rtraver,

Is that payload valid JSON data? If yes, you could parse it to JSON Object and then get it.

Was this reply helpful? Yes No
rtraver 5 on at

Like (0)

Report

I believe it is valid JSON, and I'm comfortable parsing JSON. I just don't know how to get to it, or if it's available from PVA or Dynamics. Does that make sense?

Was this reply helpful? Yes No