Answered

"Comparing POS Values in PowerApps: Displaying Only One Entry and Syntax Error with ForAll"

(0) Share

Report

Posted on by Ensosim

i have a dataverse table displayed in powerapps. in this dataverse table there is a pos that is unique.
I would now like to compare the pos with the other datasource that I have also included in the powerapps.

If(pos.Text = Text(ThisItem.Pos) , stueck.Text, "")

Unfortunately, it only shows me one item in the piece column.
When I try to use Forall I constantly get a syntax error

ForAll('VK-EK_1', If(pos.Text = Text(ThisItem.Pos) , stueck.Text, ""))

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

AhmedSalih 6,678 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hello, @Ensosim, ForAll function returns a table not a text value. Also, you can't use the Data table control to calculate values in the Canvas App. If you use a Gallrey, you can achieve this instead.

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

Microsoft Business Application MVP

Was this reply helpful? Yes No
Ensosim 38 on at

Like (0)

Report
Copy link

Link copied!

Thank you :), i also tried gallery control. How can i use the functions now for all rows?

Was this reply helpful? Yes No
Shashank Bhide 946 Moderator on at

Like (0)

Report
Copy link

Link copied!

What type is this other data source? Sounds like you are looking to "Filter" the other data source with "ThisItem"'s value?

Was this reply helpful? Yes No
Ensosim 38 on at

Like (0)

Report
Copy link

Link copied!

The other data source is a json file that I have converted into a table, where I display the individual columns in a gallery.
But I need the same columns with the values in the dataverse table, they should only be displayed there.

I need length width from the table for my dataverse table and a few more columns.

This is the Dataverse Table where i want to display a few columns of the tst.response
pos.Text and stueck.Text are from the tst.reponse. With this if function i get only one row, but i need all rows from the tst. response. The pos from dataverse and the json table are the same. So i thougt i can compare this both to get the correct value

Was this reply helpful? Yes No
Verified answer

Shashank Bhide 946 Moderator on at

Like (1)

Report
Copy link

Link copied!
Ok, so that sounds like joining two tables on "pos" column? it'll need a POC to do exact logic, but something like below might be of help?

ClearCollect( JoinedList, ForAll( List1, Patch( List1, LookUp(List2, Id = List1.Id) ) ) )

Was this reply helpful? Yes No
Ensosim 38 on at

Like (1)

Report
Copy link

Link copied!

Thank you ❤️

Was this reply helpful? Yes No