Skip to main content

Notifications

Community site session details

Community site session details

Session Id : gErPIE+MPvuzWBOU0h/FaU
Power Apps - Building Power Apps
Answered

Update project status

Like (0) ShareShare
ReportReport
Posted on 19 Aug 2020 20:52:22 by

Hello guys am new to powerapps, just trying to build an app that updates my project tasks status, i need 2 drop lists to select a specific task in a specific project. then i need a toggle to change the task status from "not complete" to "complete" to update the task status

 

Your help is highly appreciated

Categories:
  • Community Power Platform Member Profile Picture
    on 31 Aug 2020 at 00:43:45
    Re: Update project status

    Man I really appreciate you help.

    But i need to make some changes as you can see in this pic,,

    test 111.PNG

      I want to divide the screen into 2 parts, where in the left part, i want To choose From the drop lists (where we already done Correctly and it's working Thanks to your help)

     

    according to the selected items in the drop list there will be a window in the right where it shows me all the data in my database but filtered with the drop lists items ( so when i choose for example project 1 and  Tasks 1 and assigned to Mr.hariri , it will show me all the  tasks in this window), with a check box for each row to change the status from not complete to complete, and a date picker to change the end date if needed.

     

    your support is highly appreciated.

    And thanks again for your previous solutions

     

  • Verified answer
    PowerAddict Profile Picture
    7,314 Most Valuable Professional on 27 Aug 2020 at 15:48:39
    Re: Update project status

    Set a variable to false either on the App OnStart or the screen's OnVisible property. Something like this:

    Set(varVisible, false)

    Add a button and set its OnSelect to

    Set(varVisible, !varVisible)

    Set the date picker's visibility to 

    varVisible

    Let me know if this works. 

     

    ---
    If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

     

    Thanks!

    Hardit Bhatia

    Microsoft Business Applications MVP

    Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

     

     

  • Community Power Platform Member Profile Picture
    on 27 Aug 2020 at 12:06:20
    Re: Update project status

    Thanks for your assistant, 

    I want to add a button that when it's clicked it shows me the date picker that we just added.

    if the button isn't clicked, the date picker will be invisible.

  • Verified answer
    PowerAddict Profile Picture
    7,314 Most Valuable Professional on 27 Aug 2020 at 02:08:24
    Re: Update project status

    Set the default property of your date picker control to

    LookUp(Table2, 'Project Name' = Dropdown1.Selected.'Project Name' && Tasks = Dropdown2.Selected.Tasks).'Finish Date'

    This way the date picker will show the date from excel, but if the user wants to change it, and you use this formula (that I had posted earlier) for the OnChange of the date picker, it should update the finish date to the new date: 

    Patch(Table2, LookUp(Table2, 'Project Name' = Dropdown1.Selected.'Project Name' && Tasks = Dropdown2.Selected.Tasks), {'Finish Date': DatePicker1.SelectedDate})

     

    Let me know if this helps. 

     

    ---
    If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

     

    Thanks!

    Hardit Bhatia

    Microsoft Business Applications MVP

    Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

  • Community Power Platform Member Profile Picture
    on 26 Aug 2020 at 09:53:25
    Re: Update project status

    Thanks for your time,

     

    But i want the date picker to show me the original date in excel Sheet (DefaultDate) for the task selected in the selected project (from Droplists) 

    Then i want to have access to change this date from date picker  (OnChange)

     

    ((The purpose for this is that I want the user to update the status of the Task from Incomplete to complete,, or giving him the option to change the finish date if there is any delay))

     

    Please Advice, Your Support is highly appreciated.

  • PowerAddict Profile Picture
    7,314 Most Valuable Professional on 24 Aug 2020 at 18:26:51
    Re: Update project status

    In the OnChange of the date picker control, I would add the following code: 

    Patch(Table2, LookUp(Table2, 'Project Name' = Dropdown1.Selected.'Project Name' && Tasks = Dropdown2.Selected.Tasks), {'Finish Date': DatePicker1.SelectedDate})

    Or if you want to add a date picker and a button, the above code will be in the OnSelect of the button. DatePicker1 is the name of my date picker control. Replace that with yours. 

     

    Let me know if this works. 

     

    ---
    If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

     

    Thanks!

    Hardit Bhatia

    Microsoft Business Applications MVP

    Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

     

  • Community Power Platform Member Profile Picture
    on 24 Aug 2020 at 10:11:05
    Re: Update project status

    Yes Exactly.

  • PowerAddict Profile Picture
    7,314 Most Valuable Professional on 21 Aug 2020 at 09:09:35
    Re: Update project status

    So you want a date picker control to be available that allows setting of Finish Date? Are you trying to get to the Patch funxtion that you will need to set the date? Just trying to understand the question here. 

  • PowerAddict Profile Picture
    7,314 Most Valuable Professional on 21 Aug 2020 at 09:06:48
    Re: Update project status

    Glad I could help! Please consider marking the toggle answer as a solution as it will also help people find answers to similar questions. 

     

    Thanks,

    Hardit Bhatia

  • Community Power Platform Member Profile Picture
    on 21 Aug 2020 at 09:02:47
    Re: Update project status

    One more thing,

    I want to add a date (Finnish Date), and give the app the accessibility to edit this date with (Date Picker Control)

    Just like in the pic Data BaseData BaseAppApp 

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 78 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 42

#3
mmbr1606 Profile Picture

mmbr1606 41 Super User 2025 Season 1

Overall leaderboard