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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

@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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

@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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

@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 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

@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 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

@v-qiaqi-msft

Okay, thankyou!!

Was this reply helpful? Yes No