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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (4,482)