Unanswered

Please HELP - SP columns not found

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am having an urgent problem and have tried everyting to resolve it, yet have not found a solution.

When connecting to an on-premise SP list, PowerApps cannot detect a specific choice column (Business Stream) that I urgently need,but it can detect other choice columns... Similarly, it cannot find the text column (Town/City) while it can find other text columns. Yet there is no difference between those columns it can find and those it cannot find...

I tried everything from refreshing the data source, to removing & re-adding it, creating a whole new app to connect to it - yet still same result.

Strangely, even creating a calculated column based on those columns it cannot find results in PowerApps not finding those calculated columns either!??

While this might be difficult to troubleshoot without seeing my specific list, I wondered if others have experienced something similar in the past? Any ideas on what else I could test?

Capture 2.JPG Capture 3.JPG

The original column names for those are:

Business_x0020_Stream

Town_x002f_City

These columns, together with calc columns based on those, are not availalbe for selection:

Capture 4.JPG

I appreciate any help I can get on this, since I am out of ideas..

Thanks in advance,
Daniela

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

i just tried adding a Choice field which named to Business Stream, and Town/City from SharePoint online list, it could be loaded successfully from my side:

Besides, please take a try to add a Label control, then under the Text property, try the formula as:

First(SharePointList).Business_x0020_Stream.Value

See if it could load the value successfully.

Regards,

Michael
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Michael,

Thank you for your testing.
Creating a label and adding the formula below into the text field did not work unfortunatley,
because this column simply cannot be found.
First(SharePointList).Business_x0020_Stream.Value

I am starting to assume this may be a bug related to my specific list. Strangely, when creating a calculated column based on this column, the function does not detect the calculated column either.