Error creating app from data: 404 not found

[Mario_Leung]

I do not believe the reason is 404 as my list is present in the site. Is my list too complicated?

{"status":404,"message":"404 FILE NOT FOUND","source":"https://gocuhk.sharepoint.com/sites/service_SpaceInventory/_api/web/lists(guid'2092542d-3798-415d-91...":[]}

Session ID: 1af4ba49-aade-4052-f92e-ea1c2e0acfbd

[v-yamao-msft]

Hi Mario_Leung,

To reproduce this issue, please provide information about:
1.What is the data source your App based on? Is it a SharePoint list?
2.How is your SharePoint list configured? What are the columns contained in the list?
3.How do you create the App? Do you create the App from data with SharePoint list or create a blank App then create a connection to SharePoint list?

I had a SharePoint list named Country1, there are Choice column, Text column, Date/Time column in this list. When I create an App from data with this list on PowerApps studio on Windows, I don’t get any error message. I also try to create an App from data with SharePoint list on PowerApps studio for Web, it can be created successfully.

Could you try again to create an App to see if it works now? If you still get the issue, please feel free reply.

Best regards,
Mabel Mao

[Mario_Leung]

>> 1.What is the data source your App based on? Is it a SharePoint list?

A SharePoint Online List

>> 2.How is your SharePoint list configured? What are the columns contained in the list?

It contains 32 custom columns, including the following data types:

- Number

- Single line of text

- Multiple lines of text

- Yes/No

- Calculated (calculation based on other columns) (text type)

- Calculated (calculation based on other columns) (number type, used as writing HTML in List)

- Lookup (from different list libraries)

- Hyperlink

>> 3.How do you create the App? Do you create the App from data with SharePoint list or create a blank App then create a connection to SharePoint list?

The App is created directly from data with SharePoint list

>> Could you try again to create an App to see if it works now?

Yes, I can create an App from the simple list, not the complex one I have mentioned.

[v-yamao-msft]

Hi Mario_Leung,

I have seen that you have a lookup column, does the different list come from the same site or different site?
Could you try with a SharePoint list without this column to see if it works?
-Calculated (calculation based on other columns) (number type, used as writing HTML in List)

I have seen an article about known issues about SharePoint list, hope this could be a reference for you:
https://powerapps.microsoft.com/en-us/tutorials/connection-sharepoint-online/

Best regards,
Mabel Mao

[Mario_Leung]

Hi Mabel,

The column looks up from the column in the same site.

I've tried to create a power app with look up column after your reply. It can create the app but it cannot find the look-up column. The field only show "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference".

Anyway, thanks for your help.

Regards,

Mario

[v-yamao-msft]

Hi Mario_Leung,

In the App, on the right navigation pane, select the Lookup field, then click the ellipsis, change the Value type from @odata.type to Value, then the lookup items would be shown.

Please if this works for you.

Best regards,
Mabel Mao