I want to create a flow which refreshes other column data based on ID
I have 2 lists and when any one adds a new item in List A it should get the relevant column details from List B
only List A access is granted to users and they will only enter the ID and all other relevant column values should be sourced/Look up from list B, Also Write Access whould only be on ID Column and all other columns should be read only as data is sourced from List B
Eg.
List A Column Names
Id DOJ Role
1 Should get from List B Should get from List B
List B
ID DOJ Role
1 1/1 Abc
