Unanswered

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

I have the same question (0)

All responses (5)

Answers (1)

eka24 20,923 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
JukeNuke 59 on at

Like (0)

Report

Yes it is. it generated a __PowerAppsId__ column.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report

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

Was this reply helpful? Yes No
JukeNuke 59 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (1)

Report

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.

Was this reply helpful? Yes No