Answered

Collect Function - creating records

(0) Share

Report

Posted on by kmo20

I built a power app by creating an excel sheet with information I have and information I need from users. I imported that sheet into SharePoint. I connected SP as a datasource in my powerapp. Currently, when users enter information into the app it updates the SP list. However, if in a months time, a user updates something in the app, the data in the SP list is replaced with the new submission. I would like to create records of the submissions. I know one way to do this is using the collect function, however I am having difficulty. Because there is a datasource involved, it is not as simple as if there wasn't. I have questions that users fill out that are populated from the SP list. I have choice drop downs and text entry etc. I'm not sure which control to write the collect function for. If anyone is able to help point me in the right direction, I would greatly appreciate it.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@kmo20

Here are my suggestions, start with a fresh SharePoint list but:

Use only single line of text, Date/time and number columns.

Change the choice columns to single line of text .

Do not use spaces or special characters in the field names

Do not change the name of the Title column in the SharePoint list.

If it is required, change that property to false

If required can't be changed, put a dummy value in the default

In PowerApps, you can hard code the Items property for comboboxes and dropdowns with your choices.

To get a better idea of how to design your app, go to make.powerapps.com and select the start from SharePoint to make a new app. It will create a three screen app that will allow users to create new records, view the record details, edit and save the changes. It sounds like this will solve your problem and give you some good ideas about how to create apps on your own.

Was this reply helpful? Yes No
kmo20 23 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I will look into the rest of your suggestions. Unfortunately, I do not have access to make.powerapps.com due to my account type. Unless there is a workaround.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@kmo20

You can create the app from inside the SharePoint list.

Was this reply helpful? Yes No