Unanswered

Expected Text value

(0) Share

Report

Posted on by Miguel36

Hi everyone,

I'm trying to filter data from a Sharepoint List 'Item Details' into a gallery that is using data from another Sharepoint List 'Record Details'.

The connection between Sharepoint Lists is the field Item Key

I'm getting 2 errors.
The First function should filter by the text input "search item name".
The Second Funtion also gets data from the 'Item Details' Sharepoint List, and should show the selected option from the Combobox above it.
Both functions are giving me "Expected Text value" error.

1st error:

2nd error:

Item Details:

Record Details:

Thank you 🙂

Categories:

Building Power Apps

All responses (13)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You are trying to filter a gallery in a Label.

Write this on the Itens property of the gallery:

If(IsBlank(TextInput2.Text),

'Item Details',

Search(

'Item Details',

TextInput2.Text,

"ItemName")

)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!
Miguel36 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response!
The Item Property of the gallery is already using the Record Details, which are the 2 labels that are showing a correct value right now in the gallery (date and status).
The labels in the gallery that are not working are not directly connected to the 'Record Details' and get their data from the 'Item Details' Sharepoint List, which should compare the 'Item Key' field with the Item Key field in the 'Record Details' Item Key field, as you can see in my original post
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

A label is expecting a Text or a Number.
You are giving it a Table or an item (Filter returns a Table)
Miguel36 52 on at

Like
a
(0)

Report
Copy link

Link copied!

So can I correct this? maybe with a lookup function? and how?

Thanks in advance 🙂
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

First one should be something like that:

LookUp(

'Item Details',

ItemName = TextInput2.Text && 'Item Key' = ThisItem.ItemKey).ItemName

Second one should be something like that:

LookUp(

'Item Details',

'Learning Platform'.Value = ComboBox4.Selected.Value && 'Item Key' = ThisItem.ItemKey).'Learning Platform'.Value

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!
Miguel36 52 on at

Like
a
(0)

Report
Copy link

Link copied!

The errors are gone, it worked but I think because of the function used in the gallery, it is not working. How can I correct this? any idea? 🙂
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The LookUp can also be empty, MAYBE, there is not any item that fills the condition.. Put the mouse over the lookup and see if it is empty or not..

Your formula on the gallery seens correct
Miguel36 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Found it, I need to add an "All" option in the comboboxes.
How can I add the ["All"] option in this combobox while still mantaining this function?
Something like ["All"] && Choices('Item Details'.Provider) (I know this doesn't work, but just giving the idea)
Sorry for the questions... and thank you for all the help!
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Write this on App OnStart:

ForAll(Choices('ItemDetails'.Provider),
Collect(CollectionValues, {Name: ThisRecord.Value})
);

Collect(CollectionValues, {Name: "All"})

After that set the source of your dropdown to the new collection.

For me, it worked

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!
Miguel36 52 on at

Like
a
(0)

Report
Copy link

Link copied!

The collection worked in the dropdown.

But the filter is only working for specific values.
If I select the "All" option it shows blank: