Unanswered

Geting data and updating data to and from a Sharepoint list

(1) Share

Report

Posted on by Frigge__

Hi,

So I made this app built on text input boxes. Everything is labeled and saving all this data to a list is no problem using patch.

Name_textinput: Nametextinput.Text and so on...
I'm currently patching data from 10 pages in this "form-like" app to that list.

But! What if I want to get all that data back to the app, edit it, and store it/update it? I know this can be done by using form. But nothing is set up with form in mind.

So I set up a new page, kind of a start page, with the option to create a new protocol or edit an old one.

And then used a dropdown list to try to get the old from based on unique ID's.

So now, how do I fill in the blanks? All them "text input boxes"...

Example pictures:

All attendees:

Start page with dropdowns:

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Frigge__,

Do you want to select an ID to naviaget you to this form-like control?

Could you please tell me that you want to create/edit in this form-like control?

Was this reply helpful? Yes No
Frigge__ 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,

I would like to retrieve all the information in the list back to the app and continue to work on the and adding more information. Without using editForm och viewForm.

When the user is using the app, it's not always possible to finish the protocol. So they have to be able to continue working at a later date (might even be weeks).

Best Regards
Fe

Was this reply helpful? Yes No
BideyYusuf 387 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @Frigge__
From what you want to achieve, Excel-Like Grid control would really help with this process. There you have Grid list that works to create New records, edit, view the old record, update the record if possible and save it back.

Pls take a look at this youtube video by @RezaDorrani on Editable grid like Excel galleries.
(2060) Editable Grid in Power Apps | SharePoint List - YouTube
(2060) Power Apps Editable Table/Gallery like Excel (Tutorial) - YouTube

I believe it would really help you with this.

I hope this helps.

Was this reply helpful? Yes No
Frigge__ 32 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hi @BideyYusuf,

Well, there might be a solution in those videos. I'm just realizing it will be a tremendous work editing all the input boxes IF it's not possible to do it in any other way (a more lazy way) 😂.

Maybe collection or container?

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

Like
a
(1)

Report
Copy link

Link copied!

Hi @Frigge__,

I would still suggest a form.

Loading all the records at a time do cause the performance issue, and it may mess up the cell update because users may fill in wrong place.

Editing a single record in a form would be a better direction, set the Item based on ID from the Dropdown selected using the LookUp(0 function.

Also, to create a new record, you just add a new icon like +, and set the OnSelect property as NewForm(Form1)

Was this reply helpful? Yes No
Frigge__ 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,

Doing it with a form would probably make life easier. But since I started, with forms and without thinking a head, I'm left with this situation. I currently have 200+ columns with different options in this list.

Would it make a difference using Datavers and divide it into several tables,

Best Regrads,
Fe

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Frigge__,

You could consider using multi forms to arrange these 200 fields, using Patch() to save the Form.Updates back to data source.

To be honest, more than 200 fields, whatever you choose a Gallery or a Form, that's a tremendous work😂

Was this reply helpful? Yes No
Frigge__ 32 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,

I appreciate the honesty!! 🙈😂

*Back to the drawing board*

Best Regards,
Fe

Was this reply helpful? Yes No
Frigge__ 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Update:

So, I might have found a dirty workaround for this.
I set a variable and then started a flow to find the item I specified. The flow runs perfectly and puts out an array of the information I want.

Now, I just need to extract the information from the array variable.

Does anyone know how?

Was this reply helpful? Yes No