Unanswered

how to handle 'Thu Sep 08 2022 09:00:00 GMT+0530 (India Standard Time)' like values of a share excel to show on calendar in power apps?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

My sharepoint excel table 'table1' is like

how to map it on power apps calendar?

usually we use filter our data source list/excel table like-filter('table1','Start Time'=_dateselected) when 'start Time' is in date format like 08/09/2022 . What should i do in this case?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-mingkz-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous,
Do you want to filter the data source using the Start Time column in Excel tabel and the DatePicker in PowerApps?
I did some test according to your requirements.

Following are my table and canvas.
Set the function as:
Filter(Table1_1,Find(Text(DatePicker1.SelectedDate,"mmm dd yyyy HH:mm:ss"),'Start Time')>0)
Note that: 'Table1_1' is my worksheet.

Best Regards,
Kyrie
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response,
I want to show my 'Start Time' of excel on power apps calendar. But it is not showing any circle on calendar for excel Start Time value.
I want to show all Start Time of gallery on calendar(on MonthDayGallery's by using visible Circle )

and filter the gallery by date selected on calendar in power apps. so that all Start Time of gallery(excel data) should be visible on calendar like below
here i used share List named-'YL' and 'Start date' is date column
for this i filter my gallery table first by visible property -Filter(YL,'Start date'=_dateSelected)
and
my MonthDayGallery's Circle by visible property - !IsBlank(LookUp(YL,'Start date'=DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days)).Title)

hope you can understand what i mean to say.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

can any one help for above query?