Excel not updating after form submitted

(0) Share

Report

Posted on by JerryH

431

hi,

I have managed to edit a record via a edit form. When submitting - the excel (Datasource) is not reflecting the change.

Please can someone help me?

Thanks

Categories:

Building Power Apps

SubmitForm.PNG

I have the same question (0)

All responses (10)

Answers (0)

eka24 20,923 on at

Like (1)

Report

Ensure that before submitting the record or save button, the Excel in the Ondrive is closed.
If the file is opened, the record will not be submitted to the Excel Table
------------

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
JerryH 431 on at

Like (0)

Report

Hi, The file is definitely closed. Please advise?

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

Like (0)

Report

If it had originally worked before. That is you have been able to submit/save before, then refresh the datasource or Delete the excel connection inside the poowerapps and reconnect again.

If this is the first time of saving into the datasource, the please show sample columns in your Excel table
------------

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
JerryH 431 on at

Like (0)

Report

Hi,
This is a new app so has not worked before.
Below - i am wanting Test Location to be updated.

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

Like (0)

Report

Do you have automatically generated powerappsId column in the Table you have shown?
------------

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
JerryH 431 on at

Like (0)

Report

Hi, yes i do

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

Like (0)

Report

Then try an remove the excel table connection inside powerapps and reconnect again. Excel as a datasource in powerapps is not stable
------------

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
JerryH 431 on at

Like (0)

Report

Thanks, done this but did not work.
No problem, thanks for your support

Was this reply helpful? Yes No
Maheswari_p1 6 on at

Like (0)

Report

@JerryH can you help out. I have the similar issue

Was this reply helpful? Yes No
JerryH 431 on at

Like (0)

Report

Disconnect your data source.
Then Reconnect again
Then, Can you share your code for the submit button.

Was this reply helpful? Yes No