Add value to same row in excel using Icon/Button

[ali20]

Hello everyone,

I’m trying to build this app for case documentation, but I struggle in this step. I want to add a new case and the feedback on it to the same form.

My goal is to get this data written to an excel file in the same row like this>

But when I click on the smiley face, it creates a new record in a new row as following>

I’m using this formula>

Can you please help me, how should I get this done, and which formula to use?

[Sunil-Narnaware]

@ali20 , when you are patching the new record, make sure you are passing the required field values everytime.. in your case you are just passing values for 'Tob Box' field and not others.. so add all the other fields and it should work.. but if you are patching an existing record then first you have to find that record and patch it..

[ali20]

Hi Sunil, thanks for your reply. I am already passing field values for columns.
Here what I want to achieve: 
1- Enter data in the app
2- Select one of the smiley faces (Which should add value "1" to excel after I save all)
3 Select Save

[Sunil-Narnaware]

@ali20 when you hit Save, what is the action you are doing? can you share that code ?

[ali20]

I have this:

 

[Sunil-Narnaware]

@ali20 but above you mentioned about Patch statement.. can you please share the purpose of it? How is your smiley thing tied to rating?

[ali20]

Hi Sunil, 

It's not an action for rating, but I use this to get the input "1" in the excel sheet where I have another table connected to this column to calculate the total user's numbers/performance based on the feedback he got from the customers.

So, as mentioned above my goal is to get this data written to an excel file in the same row like this>

[ali20]

@CarlosFigueira Can you please help here?

[v-yujincui-msft]

Hi @ali20 ,

You need to specify the record you just submitted for the Patch() function.

I have made a test for your reference.

Here is my App.

Set(variableTB,"1")

Patch(datasource,EditForm1.LastSubmit,{'Tob Box':variableTB});Set(variableTB,"")

Result Screenshot:

Best Regards,
Charlie Choi

[ali20]

Hi @v-yujincui-msft ,
thank you so much for your help. That's whated I want to do. I still have one quetion, how to do I get every varible under its column. For example: 
Set(variableTB,"1") > put the value in column "Tob Box"

Set(variableMB,"1")> put the value in column "Middle Box"

Set(variableBB,"1")> put the value in column "Buttom Box"

To be Like this: