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:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report

Hi @firda59,

I have seen that there is space in your column name, like this 'SO/PO/WBS ', could you please check your column name?

You could add a Gallery, set the Label within the Gallery with "ThisItem" search for that collumn.

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

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.

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

@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'.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

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:

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (1)

Report

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.

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

@v-qiaqi-msft
yup!

do you know why this happen? is it because the database or PowerApps?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report

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.

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

@v-qiaqi-msft

Okay, thankyou!!

Was this reply helpful? Yes No