web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get difference value o...

Power Apps

Answered

Get difference value on collection

(0) Share

Report

Report

Posted on by CU25090443-0

I have a collection to get data before and after submit form like this

I want to find some difference value in two row such as: Specifications: "blank value"-> test

to get history of change when someone edit item.

Pls give me some suggest. thanks a lot

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @DTL ,

I made a sample for you.

ClearCollect(Col2,If(First(Col).Col1<>Last(Col).Col1,"Col1: " &First(Col).Col1&"->"&Last(Col).Col1),If(First(Col).Col2<>Last(Col).Col2,"Col2: " &First(Col).Col2&"->"&Last(Col).Col2),If(First(Col).Col3<>Last(Col).Col3,"Col3: " &First(Col).Col3&"->"&Last(Col).Col3))
Concat( Filter(Col2,!IsBlank (Value)),Value,Char(13))

Best Regards,

Wearsky
CU25090443-0 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft very helpful. thanks a lot

Join the conversation