629
I have a manual flow that I would like to read two columns on a spreadsheet and matching the first column to the Sharepoint Column add a numeric value to another column but I cannot get the update item to show the Excel Value as a selection.
My Flow is as follows:
Hi @jamescosten ,
I've noticed the same issue today. Maybe it's another bug from the New Designer...
An alternative for that is to click in the expression button (Fx):
And then select the "Dynamic content" tab:
There you will find all Excel column references. After select the desired one, click "Add", and the problem is solved 🙂
If you still cannot find the column in the dynamic content list, use the following expression: item()['your_column_name'], just replacing the text in red for your actual Excel table column name:
Additionally, to learn more about expressions in Power Automate, refer to this blog post: http://digitalmill.net/2024/02/27/writing-expressions-in-power-automate/
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/
Share
Report
All responses (
Answers (
