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

All responses (10)

Answers (1)

ajithd6368 496 on at

Like (0)

Report

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

Thanks Bof ,

Managed to make it work as you advised.

rgds
AD
ajithd6368 496 on at

Like (0)

Report

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

Hi Bof ,

appreciate your advice on this

rgds
AD
ajithd6368 496 on at

Like (0)

Report

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

Hi Bof ,

still i get some errors ..

here is the flow

appreciate your advice

rgds
AD
Verified answer

v-bofeng-msft on at

Like (0)

Report

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

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 (0)

Report

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

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
v-bofeng-msft on at

Like (0)

Report

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

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 (0)

Report

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

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 on at

Like (0)

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

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 (0)

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

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 on at

Like (0)

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

Hi @ajithd6368 ,

Please try:

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

Best Regards,

Bof