Answered

Extracting the URL of a Sharepoint List Item and Placing it in Another List

(0) Share

Report

Posted on by Simon_Watson

Hi PA Community,

Long time lurker, first time posting! I have 2 flows, both initiated by Forms - one is the authority to work, the other is the payment information once the task is complete - let's call them 'authority' and 'pay'. When the individual submits an authority to work and it is agreed, they receive a unique number which they then use as reference for the work conducted. So far, so easy(ish). To have a complete cross reference across both lists I currently have a member of staff who takes the URL of the list item from the 'authority list' and copies and pastes it into the 'payment list', so in the case of an audit the authority link is clearly visible within the pay list.

My question is this: is there a way to construct a flow that takes the unique number submitted on the pay form, runs a filter query against the 'authority list' for the number, extracts the URL and places it into a field in the 'pay list' thereby negating the copy and paste that is needed atm?

Kind regards,

Simon

I have the same question (0)

All responses (4)

Answers (1)

tom_riha 10,179 Most Valuable Professional on at

Like (1)

Report

Re: Extracting the URL of a Sharepoint List Item and Placing it in Another List

Hello @Simon_Watson ,

if I understand correctly you want to do a lookup to the other list and then use the information you get. The standard way to do a lookup in Power Automate is using the 'Get items' action with a Filter Query as described here. It'll return all items from the other list that fit the condition and display the columns among the dynamic content. You can take the 'Link to item' from the result and update it in the other item.

Was this reply helpful? Yes No
Simon_Watson 19 on at

Like (0)

Report

Re: Extracting the URL of a Sharepoint List Item and Placing it in Another List

Hi @tom_riha,

Thanks for your reply - I figured it had to be something to do with 'get items' but couldn't figure out how to implement it in my flow. I'll have a play with it and mark as a solution once successful. Thanks again.

Was this reply helpful? Yes No
Verified answer

tom_riha 10,179 Most Valuable Professional on at

Like (1)

Report
Re: Extracting the URL of a Sharepoint List Item and Placing it in Another List

Hello @Simon_Watson ,

the Filter Query is quite straightforward, you need to column internal name, operator (eq = equals in your case) and the value you're looking for in single quotes, e.g.

Title eq '123' or Title eq 'dynamicContentOrExpression'

Was this reply helpful? Yes No
Simon_Watson 19 on at

Like (0)

Report

Re: Extracting the URL of a Sharepoint List Item and Placing it in Another List

Hi @tom_riha , it worked perfectly, thank you. I figured it was something along these lines but I think my brain had stopped working! Thanks again for your help.

Was this reply helpful? Yes No