Answered

How to Add A Specific Value To an Existing Excel Row

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have a flow. This flow gets excel attachment from the email save to a folder. Than this excel file is copied to another excel file which is in another folder. But I have to update some rows after paste.

I'm using update a row action but how can I give the new value to a specific row. I tried to use replace function to make this change but I couldn't do.Also I have to do these changes according to some conditions.

You can find below screenshots of my flow:

Can I write a specific value manually to the column?

I have the same question (0)

All responses (9)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

Re: How to Add A Specific Value To an Existing Excel Row

Hi!

Are you familiar with WDL expressions? Then help you to manipulate data obteined previously by your flow.

Great stuff here

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

YOu can also add a specific, manual value to your column, as you hoghlighted.

Now, if you need further assistance, you need to explain how to calculate your new column value

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: How to Add A Specific Value To an Existing Excel Row

Dear @efialttes I'm not good at expressions actually.
My problem is there is a row value in my excel it can be empty or maybe there is a value. I want to update row value like:

"if my vendor is xxxxx, then update columna as xxxx"""
I've tried expressions such as:
replace(item()?['Column name'],'xxx')
bu it didn't work.
Also I've tried in update a row action wrting manual bu it didn't work too like in second screenshot.
Thanks.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Re: How to Add A Specific Value To an Existing Excel Row

Hi!

item() based expressions will only work if you are inside a loop

How do you figure out which vendor is? Does this info come as part of your trigger outputs? If so, which trigger you are using?

Hope this helps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: How to Add A Specific Value To an Existing Excel Row

@efialttes Also you can find below my condition and my update row action:

I want to update columns a value as consignment is the condition is supplied

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Re: How to Add A Specific Value To an Existing Excel Row

So, COLUMNA shall take value 'Consignment' (the one you typed as its input) if Condition is evaluated as true, right?

And, it doesn't, right?

So, is your flow executing the false branch of your Condition (meaning your condition rule is not properly set) or is it 'Update row' executed, but no change in COLUMNA is experienced?

Gracias!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: How to Add A Specific Value To an Existing Excel Row

Dear @efialttes ,
Yes you're right my condition turns false and COLUMNA still empty.
So you say that my condition is not set as right. Is that right?

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Re: How to Add A Specific Value To an Existing Excel Row

Hi!

If you execute the flow and your condition is evaluated as false but, according to the data processed in the current execution you expected it to be evaluated as true, then the problem is with the current definition of your condition rules.

Something wrong or missing. Usual errors:

A-you type a number on the right side of a condition rule, so Flow understands it of type integer; while the left side of your condition rule is the same number of type string

B-a hidden space makes operator 'equal' fails (in such a case try with operator 'contains' instead

I would say your problem is of type B... I would try to remove 0 and add the following WDL expression instead

concat('0')

Same for the other condition rule

concat('11276')

Hope this helps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: How to Add A Specific Value To an Existing Excel Row

Thank you very much @efialttes . You were right I have changed the condition logic and then it worked.
Have a nice day.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

Re: How to Add A Specific Value To an Existing Excel Row

So, you fixed it?

Congrats! Great Job!

I have also seen you marked the opic as solved. THanx for your kindness!

May I ask you for a little (an optional) favour?

That is to click on 'Thumbs up' in any answer you found valuable... or even in all of them 😉

So this is the cheapest, easiest way to say thanks to somebody that spent its time simply trying to help. And just between you and me, everytime an inspiring answer receive a kudo in this community, an ewok escapes from The Emperor menace

Thanx for your help making this community great!

Was this reply helpful? Yes No