Answered

Form fields not visible when running the app

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have created a table in excel sheet with 1 column - "Names". I have connected the data using OneDrive.

In power apps, I created a simple UI with 1 input field "Name". I want user to type the name, click submit. The name should get stored in the excel sheet. For every new name entered, a new row should be added to the table in excel sheet.

When running the app, the form is not showing up. What am I missing?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Pstork1 69,127 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
It looks like you added a TextInput box, not a form with a field. So there is nothing binding that input to the excel column in the table. In the ONSelect action of the button you need to add a Patch() that will submit the record to the Excel table. Depending on the table name it would look something like this.

patch(datasourcename, defaults(datasourcename), {Names: TextInput1.Text})

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

Set your form default mode to New.

It is currently showing to be in Edit mode and you are not providing an Item in the Item property of the form.

If you are only concerned with creating records, then place the form in New mode.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you.

Was this reply helpful? Yes No