Unanswered

Change a column depending on the day

(0) Share

Report

Posted on by pal95

266

Hi,

I would like to make an inspection application, so when the user clicks on a button, I would like Now() to move to a proper column in the Excel file.

Could you please advise me on how to determine the right column for each day? For example, if the user clicks the button on 6/23/2020, I would like the current time to fill the column named 6/23/2020.

Thank you for your time!

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

The difficulty is there are many rows for a particular day 6/23/2020. which row should it be sent to?
Try:
Patch( Table1, Defaults( Table1), { 6/23/2020: Now() } )
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
pal95 266 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your reply!

Before that, I click on an item in the gallery. Every single item in the gallery has it's own row. I basically would like to use the same row as an item in the gallery has. So, if we have 4 rows:
A
B
C
D
I would like to have this date in A row and 6/23/2020 column if I clicked on an icon in the row A
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I cant see any A in the excel you attached, can you show that with A, what column contains the A
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
pal95 266 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your reply. Here is the explanation of what exactly I want:
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Use:
Patch( Table1, First( Filter(Table1, ColumnWithD = "D" ) ), { 6/23/2020: Now() } )
Replace the column ColumnWithD with the column containing the A, B, C, D
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
pal95 266 on at

Like
a
(0)

Report
Copy link

Link copied!

But this solution will work only on 6/23/2020. I would like the system to automatically detect the current date, so, if it is 6/26/2020, I would like the information to be written under a column 6/26/2020, but on 6/27/20 I would like to use the column 6/27/2020.

Patch( Table1, First( Filter(Table1, ColumnWithD = "D" ) ), { 6/23/2020: Now() } )

6/23/2020 must change automatically, depending on a the current date
pal95 266 on at

Like
a
(0)

Report
Copy link

Link copied!

up, still not solved
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

You are having issues because your table does not have Column with "D". If you have, what is the name of that column?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.