Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Governance and Administ...
Unanswered

Help!!! Powerapps

(0) ShareShare
ReportReport
Posted on by

 

Hello community,

Thanks for the final fix.
but I still have questions, I have already designed an app, but now I want to record the working times and I have the following problems:

1. I would like to convert the times into working hours
 and displayed in a decimal number (example: from 07:00 to
 4:00 p.m. minus a break = 8.0 h

2. I have created a Submit button and now I would like to
 that the data I entered in an Excel spreadsheet
 be written (I have already tried this according to the
 Video unfortunately only with the formula "Patch(table1;"appname")
 don't hit it
3. In the data table, he only tells me the names of the fitters
 [object_object] to it's a drop down list though
 fitter list

I hope you can help me with my problems.
Kind regards
 
Categories:
  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on at
    Re: Help!!! Powerapps

    Hello, @Basti1987, for your first question:

    You will have to use DateDiff function that returns the difference between two date/time values.

    DateDiff( TimeValue("07:00"), TimeValue("4:00"), Hours )

     

    The second and third questions are not clear. Can you please explain more and maybe use some screenshots.

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Featured topics