This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
EDIT: Problem solved, I went about this wrong.
Hello, I'm new to Power Automate so sorry if the answer to this question is obvious.
I'm trying to use Power Automate to put data in a specific cell of excel, so I'm trying to figure out how exactly to filter by both a column and a row so I can find that cell.
More specifically, the user's name, date of working, and time are input into the flow and I have a column for users and one for every date individually. When a user submits their time worked for that date, I'm trying to add that time on the right row (for user) and column (for date)
I've tried listing only row for the user's name but I'm not sure how to choose the right date column at all. Another wrinkle is that a new date column is being made every day for that day, and that users can submit their time worked for previous days if they missed it.
Thank you for the help. Also if there's a better or easier way to format this data, that would be amazing too.
Subreddit
Post Details
- Posted
- 3 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/MicrosoftFl...