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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Set the date when an o...
Power Apps
Unanswered

Set the date when an option is set(Model driven app)

(0) ShareShare
ReportReport
Posted on by 13

I have an application for case attention, however I have problems to define an attention date (which would be when a support agent is assigned) and a solution date (when the case is set as solved).

 

I also analyzed the possibility of taking the closing date when the case is closed but I can't find this variable to store it in the table.

The objective is to establish an analysis of the response and solution times without the support agent defining when the ticket was attended or closed.

 

How could I address this problem?

 

I have the same question (0)
  • AhmedSalih Profile Picture
    6,678 Moderator on at

    Hello, @Jayser_blanco ,

    Few questions to better assist you:

    1. How does the support agent is assigned? 
    2. How do you set a case as solved? 
    3. How would you set the case as closed?

     

     

    Regards,
    Ahmed
    If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.

     

  • 365-Assist Profile Picture
    2,324 Moderator on at

    I would suggest doing the following:

    1 - Add 2 new date columns Attention Date and Solution Date.

    2 - Create a Power Automate flow that has a trigger for when the record is modified and add an action to update the new date columns (based on what the response is)

    365Assist_0-1658194998826.png

    --------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

  • Jayser_blanco Profile Picture
    13 on at

    Greetings, thanks for the quick response.

     

    The agent is assigned by assignment of the new owner.
    My initial logic was that when creating the case this enters

    the state ¨in queue¨, once someone from support opens it

    changes the state to in progress (the time and date of initiation

    is recorded), and once completed the state passes to ¨solved¨

    (the time and date of solution is recorded), in this way I could

    carry the analysis of response times, once the case is completed

    it is closed by means of the action of the action ¨Save & close¨

    that integrate the model driven app.

  • Jayser_blanco Profile Picture
    13 on at

    It is an option but unfortunately I do not have the necessary version to use these automate capabilities with dataverse.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard