Answered

Adding new Data to the excel in the same row

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have excel stored in Google Drive as my data Scource. In my excel I have (TINumber, CustomerName, SupportDepartment, From, To,Details, Category, Employee, Manager, and UniqueId). In the app I have a DataForm which only includes: TINumber, CustomerName, SupportDepartment, Category, From, To, and Details to ask the user to fill these fields. However, When I want to store them I want to add the Employee , Manager and UniqueId to the same record as well. I tried :

SubmitForm(NewEntry);
Patch(SubmissionForm, Defaults(SubmissionForm),
{
    TINumber: DataCardValue2,
    Details: DataCardValue6,
    CustomerName: DataCardValue5,
    From: DateAdd(FromDate, TimeZoneOffset(FromDate), Minutes),
    To: DateAdd(ToDate, TimeZoneOffset(ToDate), Minutes),
    SupportDepartment: DataCardValue7.Selected.Value,
    Category: DataCardValue8.Selected.Value,
    Employee: MyEmail,
    Manager: DefaultManagerEmail,
    UniqueID: NewUniqueID+1
        }
);

Which is creating 2 seperate rows. (attached screenshot)

I tried to use only either Patch or SubmitForm but nothing.

I will be more than happy if anyone could help me out regarding this issue.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

What type of fields are Employee, Manager and UniqueID?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The Employee and Manager are General and UniqueId is Number.

Was this reply helpful? Yes No
Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

In PowerApps, if you want to create one record, you whether use the SubmitForm function, or use the Patch. If you use both at one time, then of course it will create 2 records.

For your case, the formula should be:

Patch(TableName, Defaults(TableName), { TINumber: DataCardValue2.Text, Details: DataCardValue6.Text, CustomerName: DataCardValue5.Text, From: ?, To:?, SupportDepartment: DataCardValue7.Selected.Value, Category: DataCardValue8.Selected.Value, Employee: ?, Manager: ?, UniqueID: ? } )

I'm not sure that you value you need in the From/To/Employee/Manager/UniqueID fields. It seems that you want to have date value in the From/To fields. If so, you can have date picker controls, and then the formula should be:

From: DatePicker1.SelectedDate, To: DatePicker2.SelectedDate,

For Employee/Manager/UniqueID, you need to use something that could be recoginized by PowerApps. For example it could be:

Employee:"XXX@XXX.com",
Manager: "XXX@XXX.com",
UniqueID: Value(TextInput1.Text)

Regards,

Mona

Was this reply helpful? Yes No