Skip to main content
Community site session details

Community site session details

Session Id : QiQmOxUHKwvmFeVU44+2TJ
Power Automate - Power Automate Desktop
Answered

How to write in excel if the value is same

Like (0) ShareShare
ReportReport
Posted on 22 Nov 2023 09:58:24 by

Hi,

So basically i have this Excel, first column is department and second column is resume downloaded.

 

nraindmia_2-1700646830661.png

I want to create flow when we enter the name of the department in the custom form, if exist, it will write resume downloaded in the column resume downloaded for that row. 

Eg: Custom form prompt, I write SABAH STATE OFFICE, then it will read the excel, if exist, write 'resume downloaded' at the same row as the sabah state office. if not, prompt message. For now I got problem when it found the department, it will write the 'resume downloaded' not at the same row as the department name, it will write at the last row.

 

nraindmia_1-1700646812093.png

Thank you !

  • nraindmia Profile Picture
    on 23 Nov 2023 at 02:17:24
    Re: How to write in excel if the value is same

    Hi @UshaJyothi20 ,

    It's working! but I changed the 'Write to Excel' to the specific column since if I use the %TextList[0]+1% it will write to another column. Thanks!

  • Verified answer
    UshaJyothiKasibhotla Profile Picture
    53 Moderator on 22 Nov 2023 at 11:12:26
    Re: How to write in excel if the value is same

    Use find or replace activity to find the value which you require

    I have built a flow take this as reference and try 

    UshaJyothi20_0-1700651533129.png

    Let me know if that works

    Usha

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.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!