web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to collect or patc...

Power Apps

Answered

How to collect or patch a date format and a combobox?

(0) Share

Report

Report

Posted on by nagestiada

504

Hey guys, I am trying to collect a record with a blank date and eventually patch it with the selected date. but I am getting an error with objnull

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Fredrik_A 3,639 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try the following:

1. Set the data type for date in Sharepoint as single line text
2. Add Datepicker in Date datacard in PowerApps. So now, you supposed to have 2 fields in the same datacard; datepicker and textfield.
3. Textfield:Default = Blank()
4. Date DataCard: Update = If(radio. Selected. Value ="Yes", DatePicker. SelectedDate, Textfield.Text)
5. Date DataCard:Visible = Radio. Selected. Value = "yes"

Was this reply helpful? Yes No
nagestiada 504 on at

Like (0)

Report
Copy link

Link copied!

Hello @StretchFredrik, I am not using any sharepoint list, just a local collection. or is it possible to add a column if you are patching?

Was this reply helpful? Yes No
Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @nagestiada ,
you can refer the below formula:

Collect(EmptyDates,Filter(YourDataSource, YourDateColumn=Blank())); ForAll(EmptyDates, Patch(YourDataSource,ThisRecord,{YourDateColumn:Date(2020,12,25) + Time(9,30,0)}))

If you use Datepicker you can directly use as below

Collect(EmptyDates,Filter(YourDataSource, YourDateColumn=Blank())); ForAll(EmptyDates, Patch(YourDataSource,ThisRecord,{YourDateColumn:YourDatePicker.selectedDate}))

I referred this link by @mdevaney's article for Date time column Patching.

Was this reply helpful? Yes No

Join the conversation