Answered

Excel Table in OneDrive

(0) Share

Report

Posted on by JukeNuke

Currently have an App that scans barcodes and inputs information into a SharePoint list. I am trying to convert this so it inputs the data into an excel table that is on a one drive business account. Getting no errors inside powerapps but no data is being loaded into the excel table. Any suggestions?

ForAll(CollectMultiScanFx, Patch(PTA_1,Defaults(PTA_1), { Recipient: ThisItem.DisplayName, Who:User().FullName, When: Today(), TN: BarcodeScanner3.Value, Company:"FedEx"}));Reset(TextInput1);Clear(CollectMultiScanFx);Navigate(Success)

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Is your Excel properly formatted as a Table. Does the table have powerappsId
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
JukeNuke 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes it is. it generated a __PowerAppsId__ column.
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Try
ForAll(CollectMultiScanFx, Patch(PTA_1,Defaults(PTA_1), {Receipient User().Email,Who:User().FullName, When: Today(), TN: BarcodeScanner3.Value, Company:"FedEx"}));
Reset(TextInput1);
Clear(CollectMultiScanFx);Navigate(Success
JukeNuke 59 on at

Like
a
(0)

Report
Copy link

Link copied!

So it seems that I got this to work. Only issue im running into now is if the file is open it wont fill anything in but if I have it closed and scan etc all info populates. Anyway around this?
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

This is a known issues, there is no workaround until the Microsoft team work on it. The file should be closed before data can be submitted.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.