Unanswered

Send table data from PowerApps to SharePoint List

(0) Share

Report

Posted on by Aeffe_91

Hi All,

I am involved in a project which aims to digitize the process of collecting Idea proposals and storing all in a repository.

As of now, the team to which I'm giving support in this project uses an Excel template as data input and a shared folder as repository.

My idea is to use PowerApps as data input and a SharePoint list as repository.

In the Excel, among other info, is present a table to be filled like the following one:

At the beginning my idea was to create a list with 44 columns (every index X every period) and then create either a table in PowerApps with 44 textinput boxes or a form mapped to the list and send all data through a SubmitForm.

I've received a suggestion to change the list structure initially thought in a column oriented one like the following example:

Unfortunately, I’m totally stuck and I can't figure out either how to replicate the excel table in PowerApp or how to link PowerApp to a list with only 4 columns.

Any help will be appreciated.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

BCLS776 8,994 Moderator on at

Like (0)

Report

I'm not 100% sure about your question, but the suggestion you received to restructure your data into a more compact table is a good one. Now you can do operations such as a Filter() to bring up specific items you want to use. For example, Filter(myTable, ProposalID = 1) will bring forth a new table containing only the records with matching ProposalID. Another handy function may be Sum(), which you could use to find totals of Value by Period and so on.

Does that help?

Bryan

Was this reply helpful? Yes No
Aeffe_91 2 on at

Like (0)

Report
Hi Bryan,
thanks for your reply!
I'm facing two different problems:
How can be rebuilt the same Excel table structure in PowerApps in order to permits to every user to fill it;
Once a user fills at his discrection the table on the App, how can I transfer all the cells filled to the list structured in that compact way (I think I should use a Patch command but I can't really figure out how to use it in this particular case).

Thanks for your support!
Andrea

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report

I think your questions get covered in one of Reza's videos: https://www.youtube.com/watch?v=8I0Pt_8I6k8

Hope that helps,

Bryan

Was this reply helpful? Yes No