web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps New to PA

Power Apps

Answered

New to PA

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I am looking to create an app that has input ability and then a "send" button to push it out to Excel or SharePoint for collection.

The way I have it set up now, it pushes it out to my destination when I refresh but the input remains in my app. Obviously I don't want the running "totals" to remain in the app.

Any thoughts?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

I would like to help but I don't understand your issue. Do you already have a SharePoint list or Excel table that you have configured to accept the data?
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@buteaur,
Based on the issue that you mentioned, do you want to save data to Excel/SharePoint and reset the App?
Could you please share a bit more about your scenario, is the Excel/SharePoint has the same data structure to your app?
I choose to create an App from Excel/SharePoint data which makes the App have the same data structure to the data source.
If you use SubmitForm(), please try the following workaround.
1/ Create an App from data(Excel/SharePoint), you will get 3 screens: BrowseScreen with BrowseGallery1, DetailScreen with DisplayForm1, EditScreen with EditForm1.
2/ Set the OnSuccess property of the EditForm1 as below:
NewForm(EditForm1)
After this, once you submit the form successfully, you will reset the EditForm1 where all the entries will be clear.
Note: If you use Patch() function, you just need to add a reset button and set the same formula to the OnSelect property.
Please check the Gif.
Best Regards,
Qi

Join the conversation