Unanswered

Flow to refresh sharepoint list when a new item is added

(0) Share

Report

Posted on by kkb19

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

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report

Hi @kkb19 ,

Is your Role column a personnel column?

If so,please check this test:

The Result:

My Flow:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
kkb19 on at

Like (0)

Report

Hi Sunshine,

My flow is getting configured as below but not sure why TestList 1 data is not getting updated from TestList 2

and also ID column is that the System generated ID or my column named ID that I should consider

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @kkb19 ,

Could you please show me screenshots of your SharePoint List 1 and List 2? Private information can be coded.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @kkb19 ，

In the case where you are already using Title as the ID column, I recommend that you use the Title column.

Replace the ID in Filter Query with Title.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
kkb19 on at

Like (0)

Report

Hi @v-yetonggu-msft

Testlist 1 is where i want the information to refresh, I will be adding other columns as well later.
Testlist 2 is the dump data.

Was this reply helpful? Yes No