Skip to main content

Notifications

Copilot Studio - Calling Actions from Copilot S...
Answered

Chatbot to return Date value from CRM

(0) ShareShare
ReportReport
Posted on by 788

Hi Guys,

 

I have a very simple scenario that I'm trying to create. I want to create a chat bot that returns from Dynamics CRM the expiration date of subscription.

I'm imagining the bot should be very simple (just as a concept) and will ask the customer only for Subscription Number (string)

The WF logic is something like this:

4.PNG

 

But I need help with to set Flow to search in CRM for the Customer's input (Subscription number)

I'm not sure if i the configuration is correct .

Subscription number field schema name in CRM is new_subscriptionnumber

2.PNG

1.PNG

I must return to the bot Expiration Date of the Subscription.

1.PNG

 

Let me know if there is anything unclear.

Best Regards

Kiril

Categories:
  • Ashish2012 Profile Picture
    Ashish2012 478 on at
    Re: Chatbot to return Date value from CRM
    JSON does not support in PVA, SO you need to use Power Automate.
  • Verified answer
    MarKol Profile Picture
    MarKol on at
    Re: Chatbot to return Date value from CRM

    JSON does not support Date or Timestamp variable types, so you would need to convert your Date variable to a String in your flow and pass it to PVA bot as a String to display in a Dialog.

     

    There is a string (value) conversion function under Expression in flow that will cast your Date or Timestamp to a String, if this is needed. See example below on how to return Date or a Timestamp as a String in a flow:

     
     

    DateAsString.jpg

     

    In PVA, the date shows up as a String and can be displayed to the user:

    Get odays date Dialog.JPG

     

    Hope this helps.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics