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

how to submit data to excel without form screen

err.PNGexcel.PNG

 

 

I have text input / dropdown menu and emoji button(with values)

 

how do I submit all this data on that page to excel table withou a FORM PAGE ?

 

what should I set on submit button at above right corner ? 

  below my code that I used at my submit button

 

Patch(Table1, Defaults(Table1), {NAME: User().FullName, TEAM_x0020_NAME : Dropdown1.Selected.Value, 
INNOVATION:innovation, EXPERIENCE:experience, IMPACT:impact,
COLLABORATION:collab, QUALITY:quality})

 any suggestion what should I changes in this code ?

 

 

Cc @CarlosFigueira

1 REPLY 1
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: how to submit data to excel without form screen

If you use the Patch function as you are doing, you don't need a form. Basically, this is a "custom form screen". There is an error on the formula, if you hover the mouse over the formula with the underlying squiggly lines, it will show a tooltip with more details about the error.

 

In the other thread that you started, there are more details and a complete example of this scenario working.