Answered

'Expected Text Value' on Gallery label

(0) Share

Report

Posted on by JD-27111646-0

Hi,

I have connected to a power automate flow in a power app and created a collection. I have checked the collection in power apps and I can see its returning the correct data. I have used a flow because I'm trying to consume an Open API and JSON in Power Apps.

The data in the collection is a list of purchase orders, PO date, number etc from an ERP database.

When I add a gallery I have set it to use the collection mentioned above. However, when I try to add a label in the gallery for the purchase order number for example I get the error shown below - 'Expected Text Value'

The autocomplete finds the collection item as I’m typing so not sure what the issue is.

When looking at the collection the data is on sub table shown on the 2nd screen shot, not sure if this is relevant.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Your purchase order list is table type data. Label expects text. try something like this:
Concat(ThisItem.PurchaseOrderList , DocumentNo)

Was this reply helpful? Yes No
JD-27111646-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks 👍 When I do that, the PO numbers are on a single Row (see below). I would like each PO number on a separate row in the gallery if that's possible? I'm a bit of a novice when it comes to Power Apps

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

They are in a single record. One Order has multiple document no so they can't be in a different row in gallery. If you want them in new line you can do this:
Concat(ThisItem.PurchaseOrderList , DocumentNo,"
")
after documentno when you press comma it asks for a delimiter which serrates entries. You have to provide that delimiter in double inverted comma. So write commas and put your cursor between them and press shift+Enter. So your code will look as below. This will put every doc no in new line in one gallery template

Was this reply helpful? Yes No
JD-27111646-0 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, couldn't see any code on your reply.

Screen shot below shows a sample of the collection data. Essentially I want to replicate this in an app. Perhaps using a gallery is the wrong option here?

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Concat(ThisItem.PurchaseOrderList , DocumentNo,"
")

In the delimiter section in the bold above press shift + Enter so every new doc num will be in new line. But they can not be in the different rows.

Was this reply helpful? Yes No
Verified answer

JD-27111646-0 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks, managed to solve using the suggestion below on this topic: https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-access-nested-table-values/m-p/314208/highlight/true

Do you want to access the values within the dll column in your AddedActivity collection?
Have you solved your problem?

If you want to access the values within the dll column directly in your AddedActivity collection, please consider take a try with the following workaround:
Add a button control within your app, set the OnSelect property to following:
Clear(ActivityCollection); ForAll( AddedActivity, Collect( ActivityCollection, dll ) )
then within your app, you could use the ActivityCollection as data souce to access your Activity records.
You could consider add a Gallery within your app, set the Items property to following:
ActivityCollection
then all Activity records would be displayed within the Gallery.

Was this reply helpful? Yes No