How to populate a SharePoint list column based on multiple columns Status

(0) Share

Report

Posted on by AppDeveloper

142

Hellow,

It is much appreciated if someone can help me in sorting this out please.

I have a Canvas App with SharePoint List as backend. There are 5 columns with Choice Based (Incomplete or Complete). Each of these columns is accessible by 5 different departments. When they do their job, each one of them update this columns by selecting "Complete" from the drop down through canvas app. There is another columns where I want to record "Overall Completed" option only when all 5 Status column show "Complete".

Can I do this through Canvas App OR should I use PowerAutomate? And most importantly How?

Kind Regards

Categories:

General Questions

All responses (2)

Answers (0)

AppDeveloper 142 on at

Like (0)

Report

Re: How to populate a SharePoint list column based on multiple columns Status

Hi @LaurensM

Thanks for your reply. I should have mentioned that the SharePoint list is being populated by MS Form independently at first time. Then staff from each department comes in PowerApp and see their Screen only (They see and edit only the column which is their department column) and update their column status. So I am basically using 5 different screens as they need to see different set of data for them. and using 5 different Forms (one for each screen to edit). It looks an ugly way but this is how it is now setup.

In this Scenario , do you think this solution will work? OR it need a different approach?

Thanks for your time.

Regards
LaurensM 12,510 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to populate a SharePoint list column based on multiple columns Status

Hi @AppDeveloper,

Are you using a Form to save the data? In this case we may be able to use the Form OnSuccess property that checks the current status of all 5 columns (after the save) and only updates the total status when all columns are set to completed:

//Form OnSuccess property If( //Add the other columns in a similar fashion... Self.LastSubmit.ChoiceColum1.Value = "Complete" && Self.LastSubmit.ChoiceColumn2.Value = "Complete", //If all are set to complete, update the last column Patch( ListName, Self.LastSubmit, {ChoiceColumnFinal: {Value: "Complete"}} ) )

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!