Answered

Place the datepicker adjacent to each other, added through SharePoint

(0) Share

Report

Posted on by Kumar9024021

195

I had a field in SharePoint list called "Registration Date". I designed a powerapps form and was able to submit successfully.

However, we had a change in design and the "Registration Date" field to be split into 1. Registration Date (From) , 2. Registration Date(To).

To implement this, I renamed the existing Registration Date to Registration Date (From) and created an extra field in SharePoint for Registration Date(To)

However, I needed FromDate and ToDate field inline, rather than on separate datacard. Since its 2 different datacards, am unable to club it together in a single field adjacent to each other.

I added a datepicker inside one of the datacard and the datepicker now appear adjacent to each other. However, the 2nd datefield added through powerapps, should get saved into the SharePoint field.

Anyidea on how to save the date value from the datepicker added through powerapps to Sharepoint.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Pstork1 69,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Since the Datacard itself is bound to a specific field there is no way to have two datepickers bound to different fields inside a single datacard. But here's a workaround

1) Set Visible property of the two regular start and end date datacards to false

2) Add two datepickers to the form and set their default to Today() for a new form and the date in the field for an edit form

3) Set the default property of the two hidden datacard fields to the appropriate datepicker's selected date property.

Now when you edit the visible start and end datepickers on the form it will set the two hidden datacards. When you submit the form those values will be saved.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Kumar9024021 ,

Do you want to put the two date fields data card into single one data card rather than separated data fields?

Based on the needs that you mentioned, I afraid that there is no direct way to achieve your needs. As an alternative solution, I think the custom data cards could achieve your needs.

On your side, you could consider disable the "Registration Date (From)" field and "Registration Date (To)" field within your Edit form, instead, add a custom data card in your Edit form, then within the custom data card, add two DatePicker controls:

Please configure your Edit form as above, then set the OnSelect property of the "Submit" button to following:

Set(FromDate, RegistrationDateFromPicker.SelectedDate); Set(ToDate, RegistrationDateToPicker.SelectedDate); SubmitForm(EditForm1)

set the OnSuccess property of the Edit form to following:

Patch( 'Your SP List', EditForm1.LastSubmit, { 'Registration Date (From)': FromDate, 'Registration Date (To)': ToDate } ); Set(FromDate, Blank()); Set(ToDate, Blank()); Back()

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No