Power Platform Community Forum Thread Details

Hi, i have sharepoint list name demo and has a field with choice ,draft,approved,rejected, by default its draft but i am developing a sharepoint form which on which i wnat that on click of button in the form the status changed to be approved. what will the procedure to do this

Categories:

Building Power Apps

Hi @Anonymous,

Do you want to change the value within the Status column (Combo box control) when you click the Check icon?

I have made a test on my side, please take a try with the following workaround:

Set the OnNew property of the SharePointIntegration control to following formula:

NewForm(SharePointForm1);
Set(IsClicked,false) /* <--- Add this code */

Set the OnEdit property of the SharePointIntegration control to following formula:

EditForm(SharePointForm1);
Set(IsClicked,false) /* <--- Add this code */

Set the OnSelect property of the Check icon to following formula:

Set(IsClicked,true)

Set the DefaultSelectedItems property of the Combo box control within the Status Data card to following formula:

If(
 IsClicked=true,
 {
 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 Value:"Approved"
 },
 Parent.Default
)

The GIF screenshot as below:

Best regards,

Kris

Community site session details

Sharepoint dropdown choices

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates