save the data into sharepoint, dates in gallery control

(0) Share

Report

Posted on by Powerappsuser11

237

Hi Community Team,

I created App. My requirement is when user select "add dates" button dynamically add next 5days except weekends to the screen.

Submit the user data into sharepoint list. onselect of submit button how can write dynamic dates. please help to achieve this one.

Below image for better understand requirement.

Dates in gallery how to save those records?

hour and description saved based on date means like date is 17/7.2023,hour and description also same date.

Thanks in advance for quick respond and efforts....!!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

narayan225 2,547 Super User 2025 Season 2 on at

Like (0)

Report

@Powerappsuser11

You can use the following link that has a clear explanation and example on how to achieve this:

https://www.matthewdevaney.com/how-to-add-business-days-to-a-date-in-power-apps-excludes-weekends/

Cheers!

Was this reply helpful? Yes No
Powerappsuser11 237 on at

Like (1)

Report

Hi @narayan225

Thanks for response ,
I'm able to retrieve the business days but my issue is onselect of submit button save the gallery records.
For above reference image shows save the user data but how can save, any idea please share me

Thanks....

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @Powerappsuser11 ,

When creating the dates using Add week button, you should create a collection to include all the dates, and also add blank columns for hours and description. In a Gallery, use this collection as data source. At last, update all Gallery items to SharePoint list using ForAll/Patch method.

Best regards,

Was this reply helpful? Yes No
narayan225 2,547 Super User 2025 Season 2 on at

Like (0)

Report

@Powerappsuser11

Please check out the comment by @v-jefferni

Cheers!

Was this reply helpful? Yes No
Powerappsuser11 237 on at

Like (0)

Report

Hi @v-jefferni ,
Thanks for response on my issue.
User by enter values in hour and description text input. only dates are dynamically updated in gallery.
I written below code on Add days button. Lease rectify below code into my requirement.
Clear(Next5Days);
Collect(Next5Days,
FirstN(Filter(ForAll(Sequence(
DateDiff(DatePicker4.SelectedDate,DatePicker4.SelectedDate + 7)),
DatePicker4.SelectedDate + Value-1),
!(Text(ThisRecord.Value, "dddd") = "Saturday" || Text(ThisRecord.Value, "dddd") = "Sunday")),5)
)
Please provide logic on select of submit button.

Thanks in advance

Was this reply helpful? Yes No
Sanshubh 512 on at

Like (0)

Report
You can use ForAll function
I'm assuming you have inserted onlu one Galley for Date,hours and Description field's answers
ForAll( Gallary1.AllItems, Patch( ListName, Defaults(ListName), { Task:ThisRecord.drpTask.Selected, Project:ThisRecord.drpProject.Selected, Date:ThisRecord.lblDate.Text, Hours:ThisRecord.txtHours.Text, Description:ThisRecord.txtDescription.Text, TotalHours:ThisRecord.txtTotalHours.Text } ) )
I've written field names based on my assumptions.
This Code will create 5 Entries in List All Data will be similar Except Date-Hours-Description field and ID.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @Powerappsuser11 ,

You should have only one Gallery to include the dates as well as hours and descriptions. So, to create the collection, you can add another two columns to the Next5Days collection then use is as Gallery data source.

Clear(Next5Days); Collect(Next5Days, AddColumns( FirstN(Filter(ForAll(Sequence( DateDiff(DatePicker4.SelectedDate,DatePicker4.SelectedDate + 7)), DatePicker4.SelectedDate + Value-1), !(Text(ThisRecord.Value, "dddd") = "Saturday" || Text(ThisRecord.Value, "dddd") = "Sunday")),5) ), "Hours",Blank(),"Description",Blank() )

On the submit button:

ForAll( Gallery.AllItems As GA, Patch( SPlist, Defaults(SPlist), { Date: GA.Date, Hours: GA.HoursTextInput.Text, Description: GA.DescriptionTextInput.Text } ) )

Best regards,

Was this reply helpful? Yes No
Powerappsuser11 237 on at

Like (0)

Report

Hi @SanshubhLubal

Thanks for your help
I only created one gallery for dates.
user manually enter Hours and description.
based on date ,same date hours and description save in sharepoint list.
In gallery created labels for dates.
Please help

Was this reply helpful? Yes No
Powerappsuser11 237 on at

Like (0)

Report

Hi @v-jefferni ,

I written below code in on select of add days but getting below errors.please rectify.

Thanks for help.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Clear(Next5Days); Collect(Next5Days, AddColumns( FirstN(Filter(ForAll(Sequence( DateDiff(DatePicker4.SelectedDate,DatePicker4.SelectedDate + 7)), DatePicker4.SelectedDate + Value-1), !(Text(ThisRecord.Value, "dddd") = "Saturday" || Text(ThisRecord.Value, "dddd") = "Sunday")),5) , "Hours",Blank(),"Description",Blank() )

Best regards,

Was this reply helpful? Yes No