Answered

Add value to same row in excel using Icon/Button

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

@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..

Was this reply helpful? Yes No
ali20 19 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ali20 19 on at

Like (0)

Report
Copy link

Link copied!

I have this:

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ali20 19 on at

Like (0)

Report
Copy link

Link copied!

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>

Was this reply helpful? Yes No
ali20 19 on at

Like (0)

Report
Copy link

Link copied!

@CarlosFigueira Can you please help here?

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
ali20 19 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @ali20 ,

I have made a test for your reference.

Here is my App.
Set(variableTB,"1");Set(variableMB,"");Set(variableBB,"")
Set(variableMB,"1");Set(variableTB,"");Set(variableBB,"")
Set(variableBB,"1");Set(variableTB,"");Set(variableMB,"")
Patch(datasource,EditForm1.LastSubmit,{'Tob Box':variableTB,'Middle Box':variableMB,'Buttom Box':variableBB});Set(variableTB,"");Set(variableMB,"");Set(variableBB,"")
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No