Unanswered

Form date picker output integer when submitted

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have an app with a form, the form gets it's fields from a SharePoint list. There are Start Date and End Date columns in the list formatted as Date and Time. This gives me a date picker in my app form. I use a flow to approve overtime after the form is submitted.

I need to collect the date as an integer in a separate column when the form is submitted. I have been searching for hours and can't find a solution in either apps or flow.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you want to create the Date as an integer into a collection?

Show a sample screen shot of your existing column and the output you expect in the collection

------------

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I want to create date as an integer into the SharePoint list, in a different column than what is tied to the date form fields.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The end goal is to be able to display how many hours the person has had approved in the last 3 months as they request OT, but I need dates in integer format to run a formula on it.