Power Platform Community Forum Thread Details

Hello everybody, I am currently working on Inventory PowerApp.

My current progress (have done the export function

Export codes

Set(varExportCSV, "");
ForAll(
gallery_inventory_4.AllItems,
Collect(
colExportCSV,
{
DeviceName: inventoryLabel_title.Text,
Memory: inventoryLabel_memory.Text,
Storage: inventoryLabel_storage.Text,
SerialNumber: inventoryLabel_serialNumber.Text,
CurrentUser: inventoryLabel_currentUser.Text,
Location: inventoryLabel_location.Text,
LoanStart: inventoryLabel_dateIssued.Text,
LoanEnd: inventoryLabel_dateEnd.Text,
LoanStatus: inventoryLabel_loanStatus.Text,
PreviousUser: inventoryLabel_previousUser.Text
}
)
);
Set(
varExportCSV,
"Serial Number, Device Name, Memory, Storage, Current User, Previous User, Location, Loan Status, Loan Start, Loan End"
& Char(10) & Concat(
colExportCSV,
SerialNumber & ","
& DeviceName & ","
& Memory & ","
& Storage & ","
& CurrentUser & ","
& PreviousUser & ","
& Location & ","
& LoanStatus & ","
& LoanStart & ","
& LoanEnd & Char(10)
)
);
ExportCSV.Run("CSVFile", varExportCSV);
Set(varSuccess, ExportCSV.Run("CSVFile", varExportCSV).completed);
Clear(colExportCSV);
If(
varSuccess = "true",
Notify("CSV file created. Check your OneDrive to view the file.", Success)
);

Currently, now the App only have export function. My role now is to research and implement to allow users of this App to import their excel to update the list in the App. So the import function using my sharepoint list needs to be built.

I was told that I was able to reference from the export function to reverse it in order to import excel data. I have difficulty implementing the import function. Can anyone please help me out? Thank you in advance!!

Update: I have recently used

https://www.youtube.com/watch?v=P6yqIpjmPrs

My collection

Collect(
colDataImport,
{
DeviceName: inventoryLabel_title.Text,
SerialNumber: inventoryLabel_serialNumber.Text,
DeviceType: inventoryLabel_type.Text,
Memory: inventoryLabel_memory.Text,
Storage: inventoryLabel_storage.Text,
Processor: inventoryLabel_processor.Text,
DesktopImage: inventoryLabel_desktopImage.Text,
DesktopAddon: inventoryLabel_desktopAddOn.Text,
CurrentUser: inventoryLabel_currentUser.Text,
Division: inventoryLabel_division.Text,
Department: inventoryLabel_department.Text,
Location: inventoryLabel_location.Text,
Remarks: inventoryLabel_remarks.Text,
LoanStart: inventoryLabel_dateIssued.Text,
LoanEnd: inventoryLabel_dateEnd.Text,
LoanStatus: inventoryLabel_loanStatus.Text,
PreviousUser: inventoryLabel_previousUser.Text,
Quantity: inventoryLabel_quantity.Text,
UserEmail: inventoryLabel_email.Text,
Modified: inventoryLabel_modified.Text
}
);