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 / Power Apps / Determination of weekl...
Power Apps
Answered

Determination of weekly target

(0) ShareShare
ReportReport
Posted on by 194

Hello all,

 

I have a somewhat complex problem that I need to implement in my PowerApp.

My project is to determine the key figure calculation in production.

We have weekly targets that have to be reached in one week. Now the user has to enter the corresponding values for a shift, be it early shift or late shift.

However, I do not want the user to always enter the weekly target again.

How can I set the field weekly target as default in the PowerApp, so that the weekly target must be entered only once. I was thinking of the calendar week for example, if the calendar week of Monday is the same calendar week for Tuesday then take the week target of Monday as the value.

e.g.

Week 1 Monday Week target 500 (One time input of the user)

Week 1 Tuesday (entered by the user) Week target 500 (determined by the app)

Categories:
I have the same question (0)
  • jorge.daniel Profile Picture
    1,430 Super User 2024 Season 1 on at

    Hi,

     

    What is your datasource and how are those values for weekly targets being stored in it?

     

    Regards.

  • Ömer Profile Picture
    194 on at

    The data source is a sharepoint list. The item is saved as a sharepoint list item

  • jorge.daniel Profile Picture
    1,430 Super User 2024 Season 1 on at

    Can you post a screenshot of that list?

     

    I am assuming you are using a TextInput control, if you set its Default property to the field where you store the target, does that meet your need?

  • Ömer Profile Picture
    194 on at

    I have not set a default or anything like that. This is now in German but I think should not be a problem. So the calendar week is my "Kalenderwoche" and the week target is my "Wochenziel" and now I want that the next entry within the calendar week in the app at the text field week target somehow sets the default to this calendar week.

     

    mer_0-1658306684464.png

    This is the field I am working with and I have to set something here in the default somehow. I already thought to work with a gallery or something like that.

    mer_1-1658306723002.png

     

  • Verified answer
    jorge.daniel Profile Picture
    1,430 Super User 2024 Season 1 on at

    Ok,

     

    So in the Texinput try something like this:

    If ( WeekNum( Today() ) = Lookup ( YourTable, SchichID = TheIdInTheApp.Text ).Kalenderwoche, Lookup ( YourTable, SchichID = TheIdInTheApp.Text ).Wochenziel, "" )

     

  • Ömer Profile Picture
    194 on at

    The LookUP-Function worked for me thank you 🙂

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard