Sharepoint List Date based on column inputs

(0) Share

Report

Posted on by ATUFAILHAASAN

I have created a process build tracking app and merged the data collection to my Sharepoint list.

I am having multiple input forms requiring multiple inputs from user along the build process.

In the background I want the Sharepoint list to populate the Date and Time in (column B) based on the time that I put my Input in Column A.

On a high level, Column B to display time as soon as Column A is populated.

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

Sanguine 29 on at

Like
a
(0)

Report
Copy link

Link copied!

You can create a lookup column within SharePoint and set it as a Date data type. For the formula, just do =NameofColumnA and format it as Date Only. For your high level, you can have the format as Date & Time.
ATUFAILHAASAN 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you add a few pictures on what you exactly mean by the Lookup column.
How can I input the formula to the Column?
Sanguine 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure. If you're in the list settings, click on "Create Column". From there, you can select what type of column it is. This will be a "Calculated" Column, which pulls data from another column. Once you select it, you can set what you want from it. You just need to hit = and then double click your Column A. From there, click "Date and Time" as a data type. If you don't want it to be on the default view, you can uncheck that box.
ATUFAILHAASAN 72 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried it your way but it does'nt seem to work. It is giving out the copy of the Text from previous Column.
Sanguine 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you looking to get the date of when "Passed" was entered?
ATUFAILHAASAN 72 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes
Sanguine 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, I had misunderstood what you were looking for. For this, you'll likely need to use Power Automate. Laura Rogers is awesome at this sort of stuff. https://wonderlaura.com/2020/08/25/flow-when-a-sharepoint-column-is-updated/comment-page-1/
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ATUFAILHAASAN ,

Maybe you could try as follows:

1. Select the submit icon and apply the following formula on its OnSelect property as:
SubmitForm(Formname);Set(passdatetime,Now())
2. Select the Form Control and apply the following formula on its OnSuccess property as:
If(LookUp(datasource,Formname.LastSubmit.ID=ID).'End of Line (EOL)'.Value="Passed",Patch(datasource,Formname.LastSubmit,{'EOL Record Date':passdatetime}))

Best Regards,
Charlie Choi