cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mqi
Regular Visitor

set manual value to form by button code

Greeting everyone

i'm new here

and here i have this form (source come from excel table)

mqi_0-1619531661565.png

 

anyway i want change status value of this form by code

for example when user pressd approve i want change (modify) status value by code to approve

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

Hi @mqi,

Do you want to modified Status value of a record from your datasource?
What is the Item property of your DetailForm? Formula like "BrowseGallery1.Selected"? Are you opening this screen from your gallery screen?
If yes, you can try this formula in your Approve button(I have tested this formula when Status column is a dropdown field or a Text field in my Excel, but pay attention, if this is a dropdown field, make sure "Approve" is one of the selections of your dropdown):

Patch(TableName,BrowseGallery1.Selected,{Status:"Approve"})

v-albai-msft_0-1619574088013.png

 

Best regard,

Allen

View solution in original post

1 REPLY 1
v-albai-msft
Community Support
Community Support

Hi @mqi,

Do you want to modified Status value of a record from your datasource?
What is the Item property of your DetailForm? Formula like "BrowseGallery1.Selected"? Are you opening this screen from your gallery screen?
If yes, you can try this formula in your Approve button(I have tested this formula when Status column is a dropdown field or a Text field in my Excel, but pay attention, if this is a dropdown field, make sure "Approve" is one of the selections of your dropdown):

Patch(TableName,BrowseGallery1.Selected,{Status:"Approve"})

v-albai-msft_0-1619574088013.png

 

Best regard,

Allen

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,915)