cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Get a row and the update a specific column dynamically in an excel file

Hello guys!

My name is ben, and I am pretty new to flows, and am trying to implement something like an attendance check to my company.

Basically, we have limited parking spots and I was asked to implement something along the lines of:

User insert dates hes not at work>get his row>change the columns accordingly.

The table is going to have rows of users and columns of dates.

 

Now my problem is, I can get the row and it works wonderfully when the column value is constant, but I didnt find a way to search for a specific column key (Compare each column key with the date the worker entered and then change the value to an X)

 

Thats all too easy in VBA, powershell and any other scripting language but I cant seem to be able to do it here, and I must do it on flows because the workers cant access an excel file or a powershell script from home.

 

Any ideas? I already managed to use addDays to increment the date until it reached the end date (to get all the range of date into an array) and just cant figure out how to "question" columns

 

Thanks!

 

***EDIT***:I forgot to mention, I talk about an excel file, and creating a flow for it.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: Get a row and the update a specific column dynamically

@bendd221 

I guess once you get all rows, you can filter them with the appropriate conditions (for example, via Filter Array action block) and delete these rows only, by means of an apply to each

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

6 REPLIES 6
Highlighted
Dual Super User
Dual Super User

Re: Get a row and the update a specific column dynamically

@bendd221 

Not sure I understood your question. You mentioned that ' The table is going to have rows of users and columns of dates' . Can you elaborate it a bit more, even provide a screenshot of the SP list as example?

Let's hope this way we can help you better



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper I
Helper I

Re: Get a row and the update a specific column dynamically

@efialttes 

Oh wait, I never specified excel right?

I am talking about an excel database, which is going to include:

a row for each worker in the company.

a column for each day for the next 6 months.

Now, next to each row is going to be a V or an X to signal if he is coming to work this day or not, to indicate if his parking spot is available.

So what I was trying to implement is a flow that changes the V to X according to specified date by the worker.

My problem is , while I did manage to get the row according to whoever launched the flow, I couldnt find how to do something like "for each column available, if it equals the date the worker entered, change the V to X"

hope that makes sense, thank you!

Highlighted
Dual Super User
Dual Super User

Re: Get a row and the update a specific column dynamically

@bendd221 

Did you try with 'update a row' action block?

This post describes limitations of current excel connectors.

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper I
Helper I

Re: Get a row and the update a specific column dynamically

I see, well we still have to work with excel on this one because of limitations (a long story)

Anyway we found some sort of a workaround, and now ran into a similar problem, so let me rephrase the problem in a more simpler way.

 

Is it possible to delete a row based on two parameter validation?

For example, delete this row only if the email cell equals test@gmail.com AND the date is 03/12/2019.

 

Thanks!

Highlighted
Dual Super User
Dual Super User

Re: Get a row and the update a specific column dynamically

@bendd221 

I guess once you get all rows, you can filter them with the appropriate conditions (for example, via Filter Array action block) and delete these rows only, by means of an apply to each

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Highlighted
Helper I
Helper I

Re: Get a row and the update a specific column dynamically

Yes, thats exactly what I did. I never actually found a solution to my first method (That will require a way to go through all columns, and theres no 'get column' function) but after recreating the excel file with a single date cell, filter array worked for me. Thanks!

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (10,163)