Hello,
I have developed a PowerApps application for the warehouse. Due to the abundance of personal data in my company email, I have set up a Gmail connection for my program and configured it to send information emails to my corporate email. However, there is a missing piece, and since I couldn't solve it myself, I need your assistance. I have briefly explained the situation below.
I have created two different gallery views on a page. I connected one of them to SharePoint, which contains data for warehouse entries. For the other gallery, I created a collection to write selected data from the gallery to gallery.sharepoint, aiming to generate a shipment/consumption list. However, the quantities do not always match each other. To address this, I assigned a TextInput value, but for any input data, it writes the same quantities to the entire list that I last entered. When I changed it to "Title" and connected it to "ThisItem.Quantity," there was no confusion. How should I set the variable here? I would greatly appreciate it if you could assist me.
Photos are atteached
The commands are also below
ForAll(Sevkiyat_list.AllItems;Patch(testdb1;Defaults(testdb1);{Başlık:Title6_5.Text;Adet:TextInput3.Text;Tarih:Today()}));;
UpdateContext({PopUpVis: false });;
Navigate(depo_cikis);;
Gmail.SendEmail("Batuhan.Donmez@Hidromek.com.tr";
{Subject:"Ambar Sevkiyat Listesi";
Cc:"";
Importance:"High";
Body:Today()&"<h3>Tarihli ESB sevkiyat bilgileri aşağıdaki gibidir.</h3>"&"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>"&"<tr style='background-color:#efefef'>
<th>Parça Kodu</th><th>Adet</th><th>Tarih</th>
</tr>
<tr>"&Concat(
testdb5;
"<td>"&'Parça Kodu'&" </td>
<td>"&TextInput3.Text&" </td>
<td>"&Today()&" </td>
";"
</tr><tr>")&"</table>"});;
ForAll(RenameColumns(Sevkiyat_list.AllItems;"ID";"urun_numarası");Patch(testdb;LookUp(testdb;Kimlik=urun_numarası);{Adet:Adet-Value(deneme)}));;
Clear(testdb5)

Report
All responses (
Answers (