Patch function from Powerapps Canvas

[knsrinath]

Hi,

I have data in Excel 20 Rows and 5 Columns (Columns and Rows may vary based on available data). I want to copy (Ctrl C) all data from excel and past (Ctrl V) into Powerapps canvas and Patch to SharePoint along with few headers in Canvas with the help of button. or any alternate method.
Request your help in this regard.

[knsrinath]

Hi,

I have data in Excel 20 Rows and 5 Columns (Columns and Rows may vary based on available data). I want to copy (Ctrl C) all data from excel and past (Ctrl V) into Powerapps canvas and Patch to SharePoint along with few headers in Canvas with the help of button. or any alternate method.
Request your help in this regard.

[RandyHayes]

@knsrinath 

Are you speaking of a literal copy and paste, or are you wanting to have your PowerApp use the Excel as a datasource and then collect in your SharePoint list the records from that list?

[knsrinath]

Hi

Thanks for your reply.

Excel is my data source. My requirement is upload date to powerapps canvas, verify and patch to Sharepoint with few Headers.

Or

Upload Excel Data and I need to verify the excel data before patch to sharepoint.

Request your help in this regard.

[RandyHayes]

@knsrinath 

Yes, I had envisioned this already - my question though is that you specifically mentioned copy (ctrl-C) and Paste (ctrl-V).  Is that the operation you are looking for - for someone to manually open the Excel file, select a part of the worksheet, Ctrl-C copy it, then go to the PowerApp and Ctrl-V Paste it?

[knsrinath]

@RandyHayes 

Yes

[RandyHayes · Accepted solution]

@knsrinath 

Please see the attached App.  Download it to your computer and then in PowreApps studio, open or create an app, then (after in the designer) click on File->Open->Browse and open the file you downloaded.

Pretty much all of the work is done in the Items property of the Gallery in the app.  Take a look over that.

Here it is in action:

 

Once you have this in your app, you can then just submit the gallery values for your SharePoint list.

[knsrinath]

@RandyHayes 

Thank You.......Thank You.......Thank You!

It is working excellent as I required.

Request you help me, patch to share Point as mentioned below

Assume E ID, Name & Dept are headers and will enter in 3 ComboBox as I mentioned in earlier message.

[RandyHayes]

@knsrinath 

Actually, can you explain more about what you mean by combobox?  You didn't mention a combobox that I can see from this thread.

[knsrinath]

@RandyHayes 

My Input

In Share Point Data to be Saved [with Save (Button)]

[knsrinath]

Hi

Request you help me to create Ticket# in Sharepoint List and rest all are working fine.

Thanks for your support.....