Error Searching Column

(0) Share

Report

Posted on by firda59

372

Hi,

I have problem with my column, I always get this error when I want to get Data based on SO/PO/WBS column.

It say that cannot find the WBS column, meanwhile I dont have that column. I just have SO/PO/WBS column.

Does anyone know why this happen? and how to fix it? Thankyou!

Categories:

General Questions

Connecting to Data

Using Apps Using Formulas

Dataflows

All responses (11)

Answers (1)

timl 32,024 on at

Like (0)

Report

Re: Error Searching Column

Hi @firda59

This is most likely a bug that's caused by the presence of the forward slash "/" symbol. In terms of the way that Power Apps retrieves data from the back-end, this symbol has a special meaning.

If you were to rename your column so as not to include the 2 "/" symbols, this error will most likely go away.
firda59 372 on at

Like (0)

Report

Re: Error Searching Column

@v-qiaqi-msft

Okay, thankyou!!
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report

Re: Error Searching Column

Hi @firda59,

Not sure if it is a temporary isue, I think the problem is more likely to be in the data source, that's why I suggest you use SharePoint instead because it is common for Excel table to have this crash.
firda59 372 on at

Like (0)

Report

Re: Error Searching Column

@v-qiaqi-msft
yup!

do you know why this happen? is it because the database or PowerApps?
v-qiaqi@microsoft.com on at

Like (1)

Report

Re: Error Searching Column

Hi @firda59,

Okay... Now I get it.

I guess the LookUp() function reports error, right?

There is nothing wrong with your formula.... you could try it later, or if it is not necessary for you to use Excel table as the data source, please use SharePoint instead.
firda59 372 on at

Like (0)

Report

Re: Error Searching Column

@v-qiaqi-msft

the label is outside gallery, and I write the formula in 'Text' properties.

When Label I put in gallery, it error too.
v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Error Searching Column

HI @firda59,

I have asked that where you put in this Label?

I don't think it is a standalone Label control.

I have a similar test on my side, and it works:
firda59 372 on at

Like (0)

Report

Re: Error Searching Column

@v-qiaqi-msft

Ok, so this is my excel, column name is 'SO/PO/WBS'.
This is formula in gallery, it can work
and this is a textInput (name:SOPOWBS_8) and label text (contains formula).

I don't know why it happen, the formula always say that 'cannot find WBS column'. But I don't call that column, I called 'SO/PO/WBS'.
v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Error Searching Column

HI @firda59,

What is that SOPOWB_S for? A Label within the Gallery?

Is this TextInput existing in another Gallery? I have a test and if this TextInput is a standalone control, this formula works.

Show me more details.
firda59 372 on at

Like (0)

Report

Re: Error Searching Column

@v-qiaqi-msft

When I used gallery, it can work well. But, when I use text input, I got error message. Do you know why and how to fix it?