I am trying to create a flow to copy a "Project Code" in plain text from a Control list to 2 other lists that use lookups to look at the control list "Project Code". The lookups will pull 3 other fields in corresponding to the "Project Code". The 2 lists in flow will only accept ID's for the lookup fields, and although itI pulls the correct ID when the flow runs, the value it returns for the "Project Code" is always null.
Any advice would be much appreciated,
Query the list you are trying to save into via flow Get Item for example and see the construct of what is returned in the field value.
This will be what you will need to pass in to the field when setting it.
Hi @MattEvs ,
When dealing with information like lookups and choice lists in Flow there is more than one type of data that comes back for a valid choice. As you mentioned, there is a difference between the ID and the Value in the Project Code. Sometimes this gets tricky to use when internal names are different than you expect, or an additional key value pair exists for a valid choice.
Create a test Flow or add the "Get Items" action in your existing Flow and then run that against your data. After it runs, open the run instance and find the Get Items action. You should see a body of information returned which you can look through to see what Flow thinks the ID/Value pairs actually are.
If this response provided an answer to your question please mark it as a solution.
If you liked my reply, please give it a thumbs up! Thank you!
Thanks for the reply, I have added a get items part previously, which returns the data correctly eg,
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!