Answered

How to store partially data entered by users

(0) Share

Report

Posted on by JohanSmith-07

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
JohanSmith-07 59 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@JohanSmith-07 you would do the same on every screen. Use the lookup() function to retrieve the item from sharepoint.

Was this reply helpful? Yes No