Compare each row of table with another table and give difference

(0) Share

Report

Posted on by jinivthakkar

4,187

Hi All,

I have a two tables:

Table1: Red, Blue, Green

Table2: Red, Blue, Yellow

I need to compare both tables with their index, and create a string. For example table 1 and table 2 both have Red value at index 0 so I need to build the string: "Red" then compare Blue at index 1 and build string as "Red, Blue" and then compare "Green" at index 2 which is a mismatch so the string will be "Red, Blue, <b><font color=blue>Yellow<font></b>"

I am then going to use this final html string to be shown on HTML field on the app.

TIA

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey!
So why don't you create a flow a condition,2 get items and create a string var. Inside that condition you compare the item from list 1 and list 2
If it is equal, append to the string the name

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@Nogueira1306 thanks for your suggestion but I need to do this on the app and not on the flow.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,918 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@jinivthakkar ,

I will give you start on this (I felt like some coding on a Saturday afternoon)- this will get the items in Table2 that are not in Table1 and return it in a comma-separated string - also assumes the field name in both is Value

Clear(colMismatch); ForAll( Split( Table1, "," ) As aMatch, Collect( colMismatch, LookUp( Table2, !(aMatch.Value in Value) ) ) ); With( { wSet: Concat( colMisMatch, Value & "," ) }, Set( varMisMatch, Left( wSet, Len(wSet)-1 ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz thanks for your time and reply, I will try this and get back to you. Thanks again.

Was this reply helpful? Yes No