Creating a Form for Excel

[JosefBod]

Want to create a Form for updating stock on the excel table when I tried it says no item to display.

[v-micsh-msft]

Hi @JosefBod,

If here you are using the EditForm control with Edit mode, you need to to configrue the following property:

1. Data Source property: Excel Table Name

2. Item property: Single record within the Excel table,

You could take use of Lookup(), for example:

Lookup(TableName, Condition)

This will return the first record which meet the condition.

For more information about form control, please check:

Edit form and Display form controls in PowerApps

Regards,

Michael

[JosefBod]

Im still confused as to what to put as the item in the form to get it to allow the gallery data to be editied i got the ability to input new data to the gallery easily but not editing or deleting

[JosefBod]

.

[JosefBod · Accepted solution]

The problem I was having is that the excel file had corrupted upon remaking the file it started working