Unanswered

Date Filtering

(0) Share

Report

Posted on by LTomas

Hi! I'm creating a Vehicle booking system. I would like to ensure that the users avoid from double booking. The set up is power apps connected to a SharePoint list. Both columns are in a date and time format.

My logic is the ff:

After the users entering 2 sets of date and time, power apps would filter the list in SharePoint and give an error message that they should look for another schedule since it is inconflict with other booked schedules.

I've sent screenshots for reference. Thank you for your feedback in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

On the Submit button, you can call a flow (with Power apps trigger). You could do the checking in your flow and then return a true/false value along with an error message. You could then display the error message back to the user.

regards

Was this reply helpful? Yes No
LTomas 40 on at

Like
a
(0)

Report
Copy link

Link copied!

I assume you're talking about inserting actions in a button. But how can I get the value in power automate?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You can send values from Power Apps as parameters to the flow.
The flow can return values back to power apps via the Output parameter, which you can save in PowerApps variable.
Something like this:
On your button submit property type Set(Result,FlowInApp.Run(DatePicker1.SelectedDate.Result,DatePicker2.SelectedDate.Result)
If your flow returns 2 output variables (Conflict,Message), they can be retrieved in PowerApps as
Result.Conflict (true/false)
Result.Message (Your error message)

Was this reply helpful? Yes No