Building an App from Scratch

(0) Share

Report

Posted on by Community Power Pla...

Dear Community

I will need your support to build up a power app with one page

App features:

Users can submit the following information

Product ID: formatted as numerical values
Product Origin: as a drop down
Delivery place: as a drop down
Date: formatted as date

For the “Product Origin” and “Delivery Place” information: I have an excecl list with all available locations that I would like to connect to this drop down
Once these information are submitted, it will be written in the SharePoint list (named: “product info”)

Can you please support how to create this app as I am still a beginner 😊

Screenshots can also be helpful

Thank you in advance

Kind regards

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

VaidasG 469 on at

Like (0)

Report
Hi @Anonymous ,

In no particular order 😀

"For the “Product Origin” and “Delivery Place” information: I have an excel list with all available locations that I would like to connect to this drop down" - Two options here: 1st - get these two formatted as tables in Excel, and you can import this file as data source... 2nd - even better 😉 get Product Origin and Delivery place, as your "product info" SharePoint list choice column (Single source of truth always better...)
For the rest, it is up to you - use a form for data input, or make your own input fields with a Submit button with Patch function...

Let me know if you need further support

VaidasG

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @VaidasG
For delivery place and product origin, it is the same excel file with one column as a source

thanks and regards

Was this reply helpful? Yes No
VaidasG 469 on at

Like (0)

Report

@Anonymous ,

As mentioned, if you choose to go with Excel file, make sure you format your data as tables. During static data import from file, as per screenshot, you will be asked to choose tables where your data is located.

p.s. I still recommend to go with SharePoint list Choice columns

Regards
VaidasG

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thank you for your guidance. I am still a beginner and this is my first App creation 🙂
Still need to figure it out how to perform all above tasks

Was this reply helpful? Yes No
Verified answer

v-zhoqian-msft Microsoft Employee on at

Like (0)

Report

Hi @Anonymous,
Based on your description, I have made a simple test for your reference.

Excel table for test:
SharePoint list for test:
Add data source to app:
Add dropdown controls:
Settings of dropdown:

Formula of submit:

Result:

Best Regards,
Community Support Team _ habsburg Qian
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Dear @v-zhoqian-msft
As per your screenshot the dropdown are connected to the sharepoint list. Is that correct?
How does it show the information on the excel sheet though

Thank you to clarify as I was a bit confused how they are connected 🙂

Excel table for test:

SharePoint list for test:

Add data source to app:

Add dropdown controls:

thank you

Was this reply helpful? Yes No
v-zhoqian-msft Microsoft Employee on at

Like (1)

Report

Hi @Anonymous ,

Dropdowns are connected to the excel table:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hello,

I wanted to know
Is it possible to have all above field repeated 5 times, so that user can submit 5 items at once
Second, I get the following error messages can you please help

The field Default and update refers to TargetList "Sharepoint" and the other higlighted field to the excel.
The excel I am using has one column called "Port Codes" to determine the locations
I have also changed the names on the fields highlighted below, which I believe is fine.

Thank you in advance

Was this reply helpful? Yes No