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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,962)