cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Safifaruqi
Level: Powered On

Connecting PowerApp with Excel Sheet Hosted within OneDrive

Hi Everyone, 

 

I have built a log/app with cascading drop downs where-in the information is being pulled in from multiple SQL tables, to now test the writing ability of the app. I have set-up an excel sheet to capture my entries which is being hosted within One-drive. I set the sheet up with just fields that correspond to fields in the form. 

 

When I go into submit my log entry image.png thats the error I receive.

 

I double checked all the fields and there is only 1 required field which is auto-populated and not empty, hence I am stuck, not sure exactly that the issue is, can you please help me out here. 

 

additional info :

 

  • The field and the excel sheet is setup as table
  • I mapped the fields on the app with the fields on the excel sheet they equal each other
  • I am not certain on the naming convention but for now I have it setup to match the datacard name of each field, i dont know if that could impact the writing ability of the application 

The objective is to simply use the application to write information into an excel sheet for tracking purposes. 

 

Please let me know if you require any information above and beyond, seems like a very rudimentary problem to have. 

                        

 

7 REPLIES 7
GarethPrisk
Level: Powered On

Re: Connecting PowerApp with Excel Sheet Hosted within OneDrive

When writing to Excel, and many other data sources, you may need to invoke the the Defaults() function.

 

Patch(ExcelDestinationName, Defaults(ExcelDestinationName), {column1: value1, column2: value2})
Safifaruqi
Level: Powered On

Re: Connecting PowerApp with Excel Sheet Hosted within OneDrive

Hi, 

 

@GarethPrisk 

 

Thank you for your response. 

 

I am a new powerapps user so please pardon my ignorance here. Where do I input the formula and how ? 

 

image.png <-- Is that where Invoke the default function? I understand that its based

 

This is how my properties look like :

 

 

 

image.png

 

 

GarethPrisk
Level: Powered On

Re: Connecting PowerApp with Excel Sheet Hosted within OneDrive

Ahh, you're using a Form.

What is Table2?

To confirm, you have two connections (one to SQL, one to Excel)?

Then you are trying to populate data in Excel (presumably, using a Form)?

 

What I was describing was if you were using a Patch function.

Safifaruqi
Level: Powered On

Re: Connecting PowerApp with Excel Sheet Hosted within OneDrive

 @GarethPrisk 

 

Yes Sir! 

 

Apologies for the confusion, I could not provide you the right information. 

 

Yes Two Connections, SQL is to pull data from SQL tables to have a cascading drop downs to auto-populate the form. Then I am trying to populate the data in excel, using the said form. 

 

Any idea on how to make it work ? 

GarethPrisk
Level: Powered On

Re: Connecting PowerApp with Excel Sheet Hosted within OneDrive

How many fields are on your Form?

Have you customized those fields? Assuming so, since you are setting the values, we may need to explore those.

The alternative would be to formulate a Patch function with the same data you're using in the form, to Patch the Excel data source.

Safifaruqi
Level: Powered On

Re: Connecting PowerApp with Excel Sheet Hosted within OneDrive

There are a total of 26 Fields in my form, Considering the form was pretty built from Scratch, I would assume that all fields are custom. 

 

I have no knowledge of how to take it forward from there, simply want the log entries to be recorded and contained within Excel. How do you suggest we go about patching the fields? How does one start doing so?

 

Thank you so much for your help? 

eka24
Level 10

Re: Connecting PowerApp with Excel Sheet Hosted within OneDrive

Insert a button on the screen where your form is.
Then select the button, on the Onselect of the Button put that formula: SubmitForm(TheNameofYourForm)

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,593)