Answered

Update project status

(0) Share

Report

Posted on by Community Power Pla...

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:

Building Power Apps

I have the same question (0)

All responses (24)

Answers (4)

PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
No knowing what your data sources and data structure, I can simply suggest this approach:

Add a dropdown for projects

Add a dependent dropdown for tasks, or simply type in a Filter expression for tasks based on the project selected in the 1st dropdown

Add a toggle control

On the OnCheck property, write something like this Patch(DataSource, TaskDropdown.Selected, {Status: Complete})

On the OnUncheck property, use something like Patch(DataSource, TaskDropdown.Selected, {Status: Incomplete})

This is just a high level approach. Let me know some more details and we can come up with a more detailed approach.

---
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

We store our database in excel where (Project Name, Tasks Name and Task Status) is in a separate columns

Your support is highly appreciated

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

We store our data in this form
Example

Was this reply helpful? Yes No
Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Let's see if this approach meets the needs:

Add a dropdown1 and set its Items property to Table2.'Project Name'(Table2 is the name of my excel table)

Add a dropdown2 and set its Items property to Filter(Table2, 'Project Name' = Dropdown1.Selected.'Project Name').Tasks

Then add a toggle and set its OnCheck to Patch(Table2, LookUp(Table2, 'Project Name' = Dropdown1.Selected.'Project Name' && Tasks = Dropdown2.Selected.Tasks), {'Task Status': "Complete"})
and set its OnUncheck to Patch(Table2, LookUp(Table2, 'Project Name' = Dropdown1.Selected.'Project Name' && Tasks = Dropdown2.Selected.Tasks), {'Task Status': "Not Complete"})

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thanks for your time, i really really appreciate it but i think i missed something.
It seems that its working but, i did put the 2 Dropdown List and toggle on an empty screen, i think i should put it on Editscreen with submit form Button to update the database in excel sheet, but i don't know how to use it with drop down and toggle in EditScreen. Please Advice. Thank You

Your Help Is highly appreciated !!

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report

Thats awesome! Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Please give kudos if you liked the replies and mark the reply that helped solve the problem as a solution. This helps others to find the solution.

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thanks but it didn't work yet
how can i edit the cells in excel, i think it should be in edit screen, and with submit button. i tried but it didn't work . please advise

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report

Where is your excel located? Is it a static excel on your computer's hard disk or is it on OneDrive? If it is a static/standalone excel file on your computer's hard disk, you will not be able to 3dit the data as it is a read only data source.

Also, the location of dropdowns and toggle control shouldn't matter. Can you please tell me what error you are getting?

Thanks,

Hardit Bhatia

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Yeah i have my excel file in onedrive.
But when i run the app, in Droplist when i choose project name, then task name then i click the toggle to change it from not complete to complete, nothing changes back in excel file.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

What formulas do you have on the OnCheck and OnUncheck of your toggle?

Was this reply helpful? Yes No