web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Power Fx function "Tim...
Copilot Studio
Unanswered

Power Fx function "TimeValue" stops Topic processing

(0) ShareShare
ReportReport
Posted on by 2

I've been stepping through the quickstart instructions to familiarize myself with building PVA ChatBots, from here: https://learn.microsoft.com/en-us/power-virtual-agents/quickstart-preview

 

I was able to get through the instructions (which need to be updated) and the bot worked as described.  I then wanted to break up the reservation date & time into 2 separate variables.  For the date value, I created a new variable "reservationDate" using the "Variable Management -> set a variable value" node and used this formula: "DateValue(Topic.reservationDateTime)" and this worked with no problems.  I then created a new variable called "reservationTime" and used the fx formula: "TimeValue(Topic.reservationDateTime)" and that's where the problem started. 

 

When running through the chatbot to test, I can see the checkmarks showing up at each step and when it gets to the node that populates the reservationTime variable it also gets a checkmark, however this is where the processing stops.  The variable doesn't get populated with the time and the process never goes to the next node.  

 

If I use DateValue instead of TimeValue, the reservationTime value is populated with the date, and processing  continues.  I also tried using DateAdd and that also works to populate the reservationTime variable and processing continues. But as soon as I add TimeValue into the mix, the process fails.

 

I used a workaround to do what I needed: Text(Topic.reservationDateTime, "h:mm AM/PM")

Am I not understanding the TimeValue function or something else...?

I have the same question (0)
  • stuermer Profile Picture
    64 on at

    Hey @Royalh13 . Can you may post a screenshot from your topic and nodes?

     

  • Royalh13 Profile Picture
    2 on at

    @stuermer , not sure what exactly you're looking for...

    2023-08-29_14-58-57.png
    2023-08-29_14-53-26.png
    2023-08-29_14-58-35.png

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 271

#2
Vish WR Profile Picture

Vish WR 167

#3
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 153 Super User 2026 Season 1

Last 30 days Overall leaderboard