web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to populate a Shar...

Power Apps

Unanswered

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

(1) Share

Report

Report

Posted on by AppDeveloper

146

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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!

Was this reply helpful? Yes No
AppDeveloper 146 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation