Hello Everyone,
I am creating and Application in Canvas which sends data of Items purchase and Repair into SharePoint list.
Structure of Application:
I have Screen with Name Purchase Requisition and in that screen one Form is present which is connected to "Purchase requisition" SharePoint list and one table grid that is also Connected to SharePoint list called "List Items", created using blank vertical gallery
Below is the Image of Screen
First Issue is with Table Grid :
Requirement is Table Grid should be able to perform CRUD Operations so for that I am creating a Collection and sending the data into SharePoint list in one go. At first I was able to fetch data from SharePoint list into Collection using this formula :
Applied OnVisible property of Screen
ClearCollect(
colLineItemsUpdates,
ShowColumns(
Table(Defaults('Line Items')),
ID,
Vendor,
'Item ',
Description,
Quantity,
Price
)
);
but now its not fetching data from SharePoint list into Collection, My gallery is connected to collection and all the textInputs formula are also correct.
Second Issue in Table Grid:
Another problem in this At First try when I was able to fetch data into collection I perform some changes in the record of gallery like Delete and Edit on deleting any record in gallery it was deleted in collection but not in sharepoint list and also when editing any record in gallery and On patching it in sharepoint list duplicate entry created.
Formula on my delete button:
Remove(colLineItemsUpdates, varRecordToDelete); // Remove the record from the collection
Set(varDeleteButtonPressed, false); // Hide the pop-up after deletion
Formula on my Edit Icon :
UpdateContext({varGridEditable: true})
Third Issue :
My form is connected SharePoint list "Purchase REquisition" the thing is when my form is submitted on button click of Submit button i want to fetch the ID from ID column of Purchase Requisition using last submit function and patch that ID into "PRID" column of SharePoint List "List Items" this process will also take place on submit button click.
Below is the image of SharePoint list "Purchase Requisition" And "List Items":
Please help me in resolving these issues.