web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Date picker to patch s...

Power Apps

Answered

Date picker to patch several days in one submission

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

PowerApps community.

I have created an app for visit reservation in the office for COVID times.

It is simple pick a date and department SP form.

I am trying to achieve a possibility to book couple of days in one submission.

I am aware that this is not possible using form, I can use regular controls to create collection and patch it to SP but I am not sure if this is even possible.

Could someone tell me how to start? I have not found any solution by myself..

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you please tell me what do you mean by "book couple of days in one submission"?

Do you want to book several days as multi records?

It is easy to achieve this using the collection, please take a try as below.

Set the OnChange property of the DatePicker as below:

Collect(DateCol,{Date:DatePicker1.SelectedDate})

Set the OnSelect property of the submit button as below:

ForAll( DateCol, Patch( Actions,// Here is my SP list name { Title: "testtest",// Here is my Title column Date: DateCol[@Date] } ) )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @v-qiaqi-msft
Thanks for response. Actually, I have tried to find a solution myself and came up with exactly the same idea two days ago. The implementation is already in progress 😄

Join the conversation