To display dates between start date and end date

(0) Share

Report

Posted on by Hemasai1999

Hi,

I have start date and end date as two different date pickers,

Formula for start date

Screenshot (109).png

Formula for end date

Screenshot (110).png

I have to display these dates in one gallery, I have formula in items of gallery as DateRange

Screenshot (111).png

I have one button to patch all dates displayed in gallery to Sharepoint list. Formula to patch all dates in splist is Screenshot (112).png

Here My issue is : If I select dates for two months(02-08-2021-02-11-2021) all dates are getting displayed in gallery but it is not getting patched, while patching some dates in between are missing when patching to splist from gallery. And also it is taking much time to patch when I select more dates.

Sometimes , all dates are getting patch , but in most cases only few dates are getting patched from gallery to splist .

Any suggestion would be helpful

Thanks in Advance

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey! I think evertything is correct. Although i would use a formula for dates like this:

Filter(myItens; DateAdd(Date;0;Days) >= DatePicker1.SelectedDate; DateAdd(Date;0;Days) =< DatePicker2.SelectedDate)

But I think that both ways work.

For the patch. Do you have a ForAll ?

Also. It is slow becaus of the number of itens. As everything, if you insert more items, the slower it gets.
The Patch may also not work because of that
bkk 34 on at

Like
a
(0)

Report
Copy link

Link copied!

As @Nogueira1306 suggested more records in ForAll would be slower when doing patch. Instead of patch from Power Apps, send it to Power Automate and insert/update the records. I did something like this for a customer of mine.
Hemasai1999 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Thanks for your suggestion.
Can you give any idea to use power automate for patch
bkk 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Create a Power Automate flow and Call from Power Apps. You send all the data from Power Apps to Power Automate in JSON Format. Look for JSON function in Power Apps.
Let us say you have a Power Automate flow called "FinalSave" which takes string parameter (for JSON input). In Power Apps on a button click of save
FinalSave.Run(JSON(myDataCollection,includeBinaryData));

myDataCollection is your collection that contains all the data that you want to save. The JSON method will convert your collection to JSON and include binary data flag will tell you to include attachments and or other binary data.

Hope this is helpful.