Urgent Please Help..!! Getting an Error while adding a Sharepoint List datasource.

(0) Share

Report

Posted on by KarthikPrasanna

Hi All,

Can you please tell me why does this error popsup?

I am not able to perform lookup, and i tried adding a display form, datasource with the same list. I get the same error.

This list has Text columns, one lookup column and one yes/No column.

Thanks in Advance

-Karthick

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

hpkeong 2,944 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Please check if you are sign-in to the same username and pw as of the first created apps.
Then, if error persists, then, please close the apps and re-open.
It happened to me before the reason was due to server response from CDS or Excel in Cloud.

Hope this info helps.
KarthikPrasanna 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi hpkeong ,

I have created this app.. when ever i load this application, i get this error. I have sign out and sign in again, even though i can get the same error.
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi KarthikPrasanna,

What column types are there in your data source? To reproduce this issue, could you show details information about the column types in your SharePoint list?

Here is an article about types of columns are supported in SharePoint, please see this article below for a reference:
https://powerapps.microsoft.com/en-us/tutorials/connection-sharepoint-online/

Best regards,
Mabel Mao
CU11011415-0 472 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Not sure if this is the exact cause but I had the same issue, I had renamed the Title (linked to item) field in my SharePoint list and this caused a mismatch in the Data Connection I guess because the error message started appearing.

What I did to resolve this was extreme, but I recreated the list under a new name, deleted the existing data connection, created a new connection to the new list then reconnected my forms to the new connection. The yellow triangle persisted until I reloaded the app into the editor.

Keith
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Keith,

I have created a list and renamed the Title field with another name, then create an app based on this list. But I don’t get any error message.

How did you create your app? What functions did you use in your app? Could you show me your function to reproduce this issue?

Best regards,
Mabel Mao
CU11011415-0 472 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I could not recreate the error either by creating a new list and changing theTitle or by changing it back to Title

I tried to recreate the error in my original list, Requests but this is giving intermittent results.

As a test I added the connection to the Requests list to my app once again, the erorr appeared once more but my app's forms and fields do not rely on this connection anymore, so there are no functions it's connected to.

The error message I recieved "The query to field 'Region/LinkTitleNoMenu' is invalid"

Now in my Requests list I had forgotten I changed the Region field back to Title so I changed it once again back to Region and the error went away, but when I changed it back to Title the error appears.
I then changed it back to Region and the error appears now no matter if I change it back to Tilte or Region, so I'm not sure.
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Keith,

Could you show me how is your SharePoint list configured? A screenshot would be better for understanding.

I tried with several lists and I changed the name of the Title column, but I was not able to reproduce this issue from my side.

Best regards,
Mabel Mao
CU11011415-0 472 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mabel Mao,
Sorry for the late response.
This is specific to just this one list instance. I'm not experiencing this with any other list either.

so I created another list with the same columns and everything is ok.

Default settings for the list with the errors, Changing the title to Region has no effect now, error persists

Settings view

Regards,
Keith