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 (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 (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 (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