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
Man I really appreciate you help.
But i need to make some changes as you can see in this pic,,
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
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
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.
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
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.
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
Yes Exactly.
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.
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
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 Base
App
WarrenBelz
78
Most Valuable Professional
MS.Ragavendar
42
mmbr1606
41
Super User 2025 Season 1