I am trying to automate some of the corrections I have to make each month to our Fuel Transactions for a report.
One of those is assigning trucks that did not get assigned to their driver's department.
I cannot get Power Automate to replace cells that contain 'Unassigned' in Column BK with the Driver Department in Column BD on the same row.
I thought it would be a simple If then, but I think I have messed something up.
I keep getting errors along the lines of Variable 'ColumnBKValues' doesn't have a Property 'Row"
I have changed the wording in the loop to everything I could think of, but I get the same Error.
I'm hoping it's just user ignorance, but I could really use some help.
I even tried using copilot and get the same error.
Your flow looking proper but you have use ColumnBKValues.rows that why its give error.
instead of ColumnBKValues.Rows used ColumnBKValues.Rowscount so that its work fine
Thanks & Regards
Chetan Ninghot
Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
8
Share
Report
All responses (
Answers (
