Powerautomate to read a list and get the respective record and update another List item related to first list

(0) Share

Report

Posted on by ajithd6368

496

Hi Dear ,

I have two Sharepoint lists .

1. MobileInvoice.

2. Limits

I have a flow as below .. What i need here is .. i need to update the Limit field in below flow to be updated with the corresponding value in Limts List .. Would you pls help me to write a expression for this .

rgds

Categories:

Building flows

All responses (10)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ajithd6368 ,

Please try:

Items('Apply_to_each')?['Limit']

Best Regards,

Bof
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks Bof ..

Items('Apply_to_each')?['Limit']

Above expression is not mentioning any where that Limit value should be taken from Limits List ..

pls advice

rgds
AD
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ajithd6368 ,

Are the two tables linked by title? If yes you can try:

Expression:

(1)

outputs('Get_items_2')?['body/value'][0]['Limit']

Best Regards,

Bof
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Bof for your response ..

Just a concern on your below comments

"Are the two tables linked by title? "

I'm using Sharepoint Lists .. Is there a way we can link the two lists together on Title field ? Pls appreciate your advice .

rgds
AD
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ajithd6368 ,

I'm just wondering about the relationship between the two tables, you don't need to do anything extra.

Maybe you could try the solution first and check if there is any problem.

Best Regards,
Bof
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof ,

Tried below flow , but get an error

Could not find list item.
clientRequestId: 243c407e-263b-495c-a4f0-ce396bc4e0b5
serviceRequestId: 243c407e-263b-495c-a4f0-ce396bc4e0b5

here is my flow

pls advice

rgds
AD
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ajithd6368 ,

You need to add an other get items . In my solution , the get items 2 is in the apply to each action.

Best Regards,

Bof
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof ,

still i get some errors ..

here is the flow

appreciate your advice

rgds
AD
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof ,

appreciate your advice on this

rgds
AD
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Bof ,

Managed to make it work as you advised.

rgds
AD