Edit a field by pushing a button

[HiImNewbie]

Hi everyone,

I have spent a lot of Time looking for this but I only found differents cases or answers that I do not understand... Sorry I am a begginer. 

I have a SharePoint list form modified with power apps. 

What would be the easiest way to update a field (yes/no toogle choice) of an item by pushing a button ?

Do not hesitate to be specific, the more informations there are the more easy I Can understand.

Thanks for your help 🙂

Regards,

[Amik]

@HiImNewbie - for SharePoint only, below is a simple example you can apply to the OnSelect property of a Button.

Patch(
    'Your SharePoint List',
    LookUp(
        'Your SharePoint List',
        ID=1 //ID here refers to the SharePoint List ID
    ),
    {
        'Your Yes/No Column': Toggle1.Value
    }
)

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

[v-qiaqi-msft]

Hi @HiImNewbie,

Since you want the steps to be more specific, I just do something add on.

Could you please tell me if the column you want to update is a Choice type or Yes/No type?

Go to the settings and follow as below to check your column type:

1). Assuming that you have a Yes/No column to be updated based on the Toggle value, just refer to the solution from @Amik 

2). Assuming that you have a single-line-text column needing to be updated with Yes/No based on Toggle value,

Patch(
    list,
    LookUp(
        list,
        ID=xxx 
    {
        Column: If（Toggle1.Value，"Yes","No")
    }
)

[HiImNewbie]

Hi @Amik and @v-qiaqi-msft 

Thanks for taking the time to reply.

My collumn is a Yes/No type and in fact I have replaced the toogle by a checkbox which is ticked when Yes.

I used code below on the OnSelect property of my button and I have no errors but this does not tick my checkbox.

(If I use ',' I'm having an error message on my formula but it works when I use ';')

Patch(
    'MyList';
    LookUp('MyList';
    ID = ThisItem.ID
    );
    {
        'EmailSent': Value(true)
    }
)

 To give more context because maybe I'm not taking the good path to achieve what I want :

I have a ticketing tool working with sharepoint list. When I open the form I have all my informations.

I want to create a button which will tick the box and so change the value of my "email sent" field of my item.

Once this value will be modified, it will trigger a power automate flow which will send an email from a shared mail box with some informations who are in the item like ID, a resolution code etc etc... AND update the status of my ticket (a choice field).

Is this to much complicated to do ?

Am I taking thoe good path ?

Thank you very much for your help !

Best Regards, 

[v-qiaqi-msft · Accepted solution]

HI @HiImNewbie,

Confused...

The way you did is very complicated.

To patch to a Yes/No column based on the Checkbox, you need to tick the checkbox firstly and then click the button to update the Yes/No column.

The logic should be as below:

1). Use the original toggle control for the Yes/No column, toggle it as on if you want

2). Hit the submit button to submit form so that you can update the Yes/No column

3). Set the OnSuccess property of the form as a variable to check if the last submit Yes/No column is updated as Yes:

Set(varCheck,Form.LastSubmit.Yes/No)//OnSuccess

4). Add a Checkbox and set its Default property as this variable, and set its OnCheck property as the formula that triggers the flow.

varCheck//Default property of Checkbox

<Flow formula>//OnCheck

[HiImNewbie]

Hi,

I thinks the way I wanted to use was a bit complicated and very not clear.

I gave up for the moment and juste decided to show a popup when user change the status to resolved.

This change of status will trigger a flow which it send resolution mail.

Thank you very much for your time !