Unanswered

Power Apps - Preview does not show the items

(0) Share

Report

Posted on by Krodriguez1

Hello,
I am starting to use Power Apps and I have created a form based on Excel data from OneDrive, but when I want to see it in the Preview I don't see anything, only this message: “No item to display”.
Could you point me to where the problem is, maybe I need a specific License?

Categories:

Topic creation & management

I have the same question (1)

All responses (3)

Answers (0)

Suggested answer

Robu1 1,459 Super User 2025 Season 2 on at

Like (0)

Report

Hi ,

Thank you for choosing Microsoft Community.

The “No item to display” message in Power Apps can be caused by a few different issues.

Here are some common reasons and solutions:

1. Data Source Issues
Check Data Source Connection: Ensure that your Excel file is correctly connected to Power Apps. Go to Data > Connections and verify that your OneDrive connection is active.
Table Formatting: Make sure your data in Excel is formatted as a table. Power Apps requires data to be in table format to read it correctly.

2. App Configuration
Items Property: Verify that the Items property of your form or gallery is set correctly. It should be something like TableName if your table is named TableName.
Default Mode: Ensure that the form’s DefaultMode property is set to FormMode.New if you are creating new items, or FormMode.Edit if you are editing existing items.

3. Data Availability
Empty Data: If your Excel table is empty, Power Apps will show “No item to display”. Make sure there is at least one row of data in your Excel table.

4. Permissions
OneDrive Permissions: Ensure that you have the necessary permissions to access the Excel file on OneDrive. Sometimes, permission issues can prevent data from being displayed.

5. Licensing
Power Apps License: While a specific license is not usually required to display data from OneDrive, ensure that your Power Apps plan supports the features you are using. Most basic operations should work with a standard license.

Troubleshooting Steps

Reconnect Data Source: Sometimes, simply removing and re-adding the data source can resolve connection issues.

Check Data in Excel: Open your Excel file and ensure it contains data and is formatted as a table.
Review App Settings: Double-check the settings in Power Apps, especially the Items property of your form or gallery.

If this fixes the issue, please mark as resolved to help others with find it.

Happy to help
Robu 1

Was this reply helpful? Yes No
Krodriguez1 16 on at

Like (1)

Report

Thank you Robu,

I have checked everything and it seems correct.

If I change the DefaultMode from FormMode.Edit to New I can see the form in the Preview, but only the labels not the records I have in the Excel file, and if I change from New to Edit I can't see anything, neither labels nor data.

It is strange because my Excel file has data in table format and I want to see them and add new ones from the App, that is why I am using the Edit mode.

Was this reply helpful? Yes No
Robu1 1,459 Super User 2025 Season 2 on at

Like (0)

Report

Hi Krodriguez1 ,

Looks like the issue is to do with the form modes in Power Apps.

Here are a few things to check and try:

Data Source Connection: Ensure that your Excel file is correctly connected as a data source in Power Apps. Sometimes, reconnecting the data source can resolve issues.

Form Mode Behaviour:

FormMode.New: This mode is used to create new records. It won’t display existing records from your Excel file, which is why you only see labels.

FormMode.Edit: This mode should display existing records for editing. If you see nothing, it might be due to the Item property of the form not being set correctly.

Item Property: For FormMode.Edit, the Item property needs to be set to the record you want to edit.

For example:
EditForm1.Item = Gallery1.Selected

Ensure that the Item property is pointing to a valid record from your data source.

Form Fields: Check if the fields in your form are correctly bound to the columns in your Excel table. Sometimes, fields might not be automatically bound, especially if the table structure changes.

Data Cards Visibility: Make sure that the data cards within the form are set to visible. Sometimes, data cards might be hidden due to conditional formatting or visibility settings.

Error Messages: Look for any error messages in Power Apps that might give more insight into what’s going wrong. These can often point you in the right direction.

If these steps don’t resolve the issue, you might want to try creating a new form from scratch and see if the problem persists. This can sometimes help identify if there’s a specific configuration causing the issue.

Was this reply helpful? Yes No