You’re offline. This is a read only version of the page.
59
Hi, I need to automate a excel form that has about 35 questions using PowerApps, users don't answer all the questions at once, they could answer 5 today, 5 tomorrow and so on,
I created a SharePoint list (SP list) to store the data entered by users through PowerApps, when they start the process (submitForm in PowerApps), a new item is created a SP list, but I don't need to create new items when tomorrow they continue and answer another 5 questions, I just need to take the same item in my SP list and fill it with those additional answers.
When I submit a form in PowerApps, they create a new item in SP every time but this is not the desired behavior,
How can I enable users to continue filling the form they already started until they have it completed without creating new items in SP?
Any ideas would be highly appreciated,
Thanks and regards
@JohanSmith-07 you would do the same on every screen. Use the lookup() function to retrieve the item from sharepoint.
Thank you @PowerRanger I will try it, it sounds about the right approach, any suggestion related to the fact that I will have my questions in about 6-8 screens, so I will need to retrieve data from SP list to 6-8 forms to show only some questions per screen?
@JohanSmith-07 so basically you want to edit an existing item. To do so you need to get the item from SharePoint. Use the Lookup() function in the items property of your Form.
E.g. Lookup(datasource,columnEmail = User().Email)
This Formular would receive the item from SharePoint where the value of the column columnEmail equals the email of the current logged in user.
In addition you have to put your Form in Edit Mode
EditForm(formName)
Your Form will display the item and you can edit it. SubmitForm() will now update your item in Sharepoint and does not create a new one.
Share
Report
All responses (
Answers (
