You’re offline. This is a read only version of the page.
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
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.
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.
Share
Report
19
All responses (
Answers (
Title eq '123'
or
Title eq 'dynamicContentOrExpression'
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.
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.
