web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps patch() not add all fi...

Power Apps

Unanswered

patch() not add all fields when creating new item and does not change existing item

(0) Share

Report

Report

Posted on by mbc1998

14

so i want to do

if items in sharepoint list -> add the current quantity+ arrived items quantity

if items not in sharepoint list -> create new item.

this is what i have

Set(arrivedItem,
LookUp('inventory obat,makanan,vitamin', Title = ProductNameDOCText.Text));
If(
IsBlank(arrivedItem),
Patch('inventory obat,makanan,vitamin', Defaults('inventory obat,makanan,vitamin'), {Title:ProductNameDOCText.Text,jumlah:First(DOCRecord).jumlah,hargabeli:First(DOCRecord).hargabeli}),
Patch('inventory obat,makanan,vitamin', arrivedItem, {Title:ProductNameDOCText.Text,jumlah:Value(jumlahbeliDOCText.Text)+arrivedItem.jumlah,hargabeli:Value(hargaBeliDOCText.Text)}));

but i only got the title added to my sharepoint list, not the whole fields. does anyone know why?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
To see why it only created the title, check if the other fields are empty. For example, this:
First(DOCRecord).jumlah

might be empty.. We don´t know for sure.
To create the item, I've only changed the lookup.
Set(arrivedItem,LookUp('inventory obat,makanan,vitamin', Title = ProductNameDOCText.Text)); If( IsBlank(arrivedItem), Patch('inventory obat,makanan,vitamin', Defaults('inventory obat,makanan,vitamin'), { Title: ProductNameDOCText.Text, jumlah: First(DOCRecord).jumlah, hargabeli: First(DOCRecord).hargabeli }), Patch('inventory obat,makanan,vitamin', LookUp('inventory obat,makanan,vitamin', Title = ProductNameDOCText.Text), {Title: ProductNameDOCText.Text, jumlah: Value(jumlahbeliDOCText.Text)+ arrivedItem.jumlah, hargabeli: Value(hargaBeliDOCText.Text)}) );
If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!
shoog 2,164 on at

Like
a
(0)

Report
Copy link

Link copied!
Why don't you take the amount and price from the same entry fields as for existing records?
It would seem you could change the patch for new items to be similar to the existing items like:
Patch('inventory obat,makanan,vitamin', Defaults('inventory obat,makanan,vitamin'), {Title:ProductNameDOCText.Text,jumlah:Value(jumlahbeliDOCText.Text),hargabeli:Value(hargaBeliDOCText.Text)})

Join the conversation