Unanswered

Unable to save PowerApps input date into a sharepoint list and syncing this.

(0) Share

Report

Posted on by Xnolbay123

Hi,

I created a PowerApp-Canvas app which works as a form for me. Its pretty massive and I just need some Data in the actual Sharepoint list to be an list-column. So I startet to add more and more textinputs (that just need to be visually here) etc. and just took the list important ones into an actual form to suck the data out of the (visual) textinputs. Worked easy. Now is the problem, If i want to Edit an existing form it doesnt show me any date from the just visual Textinputs and the data seems kindof lost once the Listitem is created.

How can I save those items into my Sharepoint list and still have them visually be there when I view or edit an Listitem.
Please take a look at the attachments, then you hopefully understand where my issue is.

Thanks alot!

Categories:

Building Power Apps

image.png

I have the same question (0)

All responses (10)

Answers (0)

Xnolbay123 13 on at

Like (0)

Report

For Example: you can see TextInput1_31 . This one is important visually in the Form always once its saved. But I cannot save it somewhere and display it once i saved it

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Xnolbay123,

Do you have a SharePoint custom form in your canvas app?

Could you please tell me if you want to submit form to your SP list? Since you have created such many controls, I will provide a solution as well.

Actually, I don't think a custom form is a good choice to save data back to SP list. Since you have created such many controls, I will provide a solution as well.

1). Add a "+" icon to change the form into a new form when you want to create a new record by setting the OnSelect"

NewForm(YourSPForm)

2). Set the Form Item property as below:

YourSPForm.LastSubmit

3). Add a save button to save data by setting the OnSelect:

SubmitForm(YourSPForm)

In addition, if you want to auto-select the record you want to edit in your form, I suggest you add a Gallery to display all the records and set the OnSelect property of it as below:

Navigate(YourSPForm)

In this situation, you should change your Form Item property as below:

Gallery1.Selected

Was this reply helpful? Yes No
Xnolbay123 13 on at

Like (0)

Report

Hi,

Thank you for your reply ! The issue I have is, that all those controls and textinputs are not inside a form. They are just inside the Canvas App. How can I sync it then with Sharepoint, or is this not possible at all? Is the data that is not inside a Form lost after saving.

Was this reply helpful? Yes No
lewisbaybutt 12 on at

Like (0)

Report

Hi @Xnolbay123 ,
To be able to push the data in your fields to SharePoint, you should ideally use a form. Create a new 'edit' form and set the form type to 'new'. You can then select your data source in this case SharePoint, and select your SharePoint list. The form will generate your fields, you can then remove fields you don't want or add missing fields. Then you can do things around validation etc inside of your form i.e. a submit button with an OnSelect like this If(DateValue1 > Today(), SubmitForm(Form1)) . That would only allow the form to submit if a date input had a date selected in the future. You don't have to do this, but it is a nice trick depending on your scenario!

I hope this helps!

Was this reply helpful? Yes No
Xnolbay123 13 on at

Like (0)

Report

Hi Tanks for your reply.

The issue I have right now is that I have many Textinputs that are not a field in my Sharepoint list, but need to be displayed when I open an existing form. So thats why i thought it would be stupid to add them into a form which is connected to the Sharepoint list, because those textinputs are no fields inside the list, but need to be there visually after you open the form, but dont contain informations that are relevant enough to be a field inside the Sharepoint list after all. ( there are over 50 Textinputs and the List would be massive if those are all fields inside the SP-List)

I just need them to be filled with the information when I edit a form. Everything else seems to work. But I think the data in those textinputs is lost after I submit.

Was this reply helpful? Yes No
lewisbaybutt 12 on at

Like (0)

Report

Ah ok I see. So am I right in thinking you just want almost text boxes with data in them for users to see when they're filling out the main form? In that case could you not just use text labels and have no action on them to change the data? Or do you need users to fill them? I'm confused why you need a user to fill out the box if you don't need the data afterwards. If you do need the data, you need to include the fields in your form as columns in your list and save it that way. The data has to save somewhere, and in your case it is a SharePoint list.

Was this reply helpful? Yes No
Xnolbay123 13 on at

Like (0)

Report

Yes the users need to fill them with Data that is not necessary to be displayed in the SP-List at first glance. They just need to appear when they Display the saved SP-List-Item to get those Data, thats why I didnt put them as List-Items. I tried to remake an Infopath-Form in our old SP2010 onPrem and thats how it worked there. Those non-List-Item Textinputs saved inside the Form rather than inside the SP-List and thats not possible as you said?
Thats unfortunate and will be alot of work trying to get all those list items in the right place.

Was this reply helpful? Yes No
lewisbaybutt 12 on at

Like (0)

Report

No unfortunately your form will not save any data like this. You need to push the data somewhere. Power Apps is the front end for the user, and your datasource i.e. SharePoint is where all data gets saved. You could add all the columns and fields to your form and then simply hide the columns you don't want to see on your SharePoint list.

Was this reply helpful? Yes No
Xnolbay123 13 on at

Like (0)

Report

To not rebuild the entire thing with the List-items, could I just save them into the List items on submit to have them stored somewhere and then on edit, save them backwards into the textinputs? This would atleast save me valuable time rebuilding the visuals on this form

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @Xnolbay123,

Sorry for the late reply.

Have seen all the follow up, if you insist on saving this temporary data from your text input controls to your SP list and display them when you edit a record, that's will be a huge job too.

I could concatenate all strings using a separator from all the text input controls and save this concatenated string into a Text column in your SP list. Every time you edit an record in the form, you could fill in the text inputs with one part of strings.

The tedious part of this job is that you need to set the Default property of each control. The concatenated string will be split into a Table, and each record from this table will display in each Text input.

Was this reply helpful? Yes No