You’re offline. This is a read only version of the page.
I am trying to create a flow that checks whether one Entity table column has more than one similar IDs.
Table 1
| Name | Date | ID | Unique Identifier |
| Test1 | 1/1/2019 | 12345 | aaa-bbb-ccc |
| Test2 | 3/1/2019 | 22233 | bbb-ccc-ddd |
| Test3 | 4/1/2020 | 12345 | ccc-ddd-eee |
In this case, Test1 and Test3 share similar IDs but on different dates.
On another table but with same fields, and added extra columns, the second date the ID got a new first date, and its GUID on the previous table,
I'd like to create a flow that updates the table as follows
| Name | Date | Date end | ID | Previous unique Identifier | Unqiue Identifier |
| Test1 | 1/1/2019 | 4/1/2020 | 12345 | aaa-bbb-ccc | aa-bb-cc |
| Test2 | 3/1/2019 | 22233 | |||
| Test3 | 4/1/2020 | 12345 | ccc-ddd-eee | cc-dd-ee |
Any help will be largely appreciated.
ps// both tables are stores in Dataverse.
TIA.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (