cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johndoe_
Regular Visitor

Submit/Collect Data to a Specific Cell of Excel Files

Dear All,

 

I have a large excel table and one of the columns must be filled by users.
In the example below, there is a similar table.
"E" Column - Number of Siblings must be filled by users.

johndoe__0-1601082095043.png

 

I planned add list view that connected with each other, like as cascade. ("Name List";"Last Name List";"City List")
Finally, I planed to add a edit box as depends on the lastest list chosen.

Does anyone have any ideas on it?
Or better solution?

Thanks

1 REPLY 1
VijayTailor
Resident Rockstar
Resident Rockstar

Hi @johndoe_,

As I understood the requirement you mentioned.

You are planning to build an app with an Excel data source. 

For that requirement, I can suggest you to use the Source As OnDrive and Upload Excel file to OneDrive Folder.

and create a New App with DataSoruce. as OneDrive. 
The Power of PowerApp gives you prebuild Add, Edit, View Screen functionality. and Customize as you want after that.

VijayTailor_0-1601133405580.png

VijayTailor_1-1601133466553.png

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

 



Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,436)