Hi everyone,
I'm looking for a solution to fill up a lookup column based on a Value, not Id. In my list the LookUpColumn (bad name choice, right?) is a LookUp column with a single value (not check allow multiple values checkbox). Any thoughts ?
Thank you !
Solved! Go to Solution.
Does the "Value" that you have match with a record in the table that is the lookup? If so before the create item step perform a "Get Items" action with an odata filter query to match your value. This should hopefully only bring you back a single result. You can get the ID from that lookup and then use that in your create item action. Does that make sense?
Does the "Value" that you have match with a record in the table that is the lookup? If so before the create item step perform a "Get Items" action with an odata filter query to match your value. This should hopefully only bring you back a single result. You can get the ID from that lookup and then use that in your create item action. Does that make sense?
Yes ...There is more then logic ! Where was my mind ?
Thank you very much for your input and once again sorry for disturbance !
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
10 | |
10 | |
7 | |
4 | |
4 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |