Hi All,
Kindly need your help to get the solution :
I have two sharepoint list, called EOS and EOS Item and I want to edit and update the data for those two.
The screen separate into two; at the top is 'Form' (Form2_4) with 'EOS' data source, at the bottom is 'gallery' (Gallery2_1) with 'EOS Item' data source.
I stuck when i want to edit then patch the gallery of EOS item to EOS Item Sharepoint list.
This is my formula :
In the Form of EOS Data Source --> On Success :
ForAll(Gallery2_1.AllItems,Patch('EOS Items',Defaults('EOS Items'),{Title:Label1_3.Text,Status:Toggle2_1,'Agreed Terms':TextInput2_1.Text,'Master ID':Form2_4.LastSubmit.ID}))
and I also try this formula
ForAll(Gallery2_1.AllItems,Patch('EOS Items',LookUp('EOS Items','Master ID'=varFormData.ID,{Title:Label1_3.Text,Status:Toggle2_1,'Agreed Terms':TextInput2_1.Text,Department:"GA",'Master ID':Form2_4.LastSubmit.ID}))
I using Master ID to create in same ID refer to EOS sharepoint list data source, then hopely when I edit it will update in same ID too.
Then in the same screen I have the button to submit the form :
SubmitForm(Form2_4)
but it's not working.
Kindly need your advice how to edit gallery with sharepoint list data source directly in gallery then patch it.
User | Count |
---|---|
148 | |
94 | |
85 | |
78 | |
57 |
User | Count |
---|---|
193 | |
175 | |
104 | |
95 | |
91 |