I have found a workaround by controlling which fields are visible in the Detail screen. As each log is entered on a separate line (i.e. morning, afternoon, etc) by hiding the empty fields it will only show the fields with data in (i.e. for the morning, afternoon, etc.).
i.e. If(IsBlank(ThisItem.'Lunch Accepted'),false,true)
This means that I should achieve the end result by just filtering the Gallery by the DatePicker1.
I have got this to work: Filter('Daily Logs', DayMonthYear = Today()) but can't work out how to get it to recognise the DatePicker. Does anyone know what I need to replace Today() with to achieve this please.
Hi @IvanZ, thanks for the reply.
I've created a new single line text column called 'DateCol'. Can you help with the formula to make the DateCol data card equal Datepicker1 in the EditForm? I get that I'd have to convert the date value to text but I don't know how to do that in a formula.
Also what would the formula be for the Gallery items property for it to filter from a Drop-down list showing Distinct values from DateCol?
Hi @IvanZ , thank you for your help with this. But I'm not there yet.
I've entered the formula's as described (hopefully) and, although there are no errors (no white crosses in red circles), it isn't working as hoped.
I've attached screen shots to show what I have put in.
The Dropdown_DateCol isn't showing varFilter but the DropDownSample (1,2,3). Should there be something in Items?
I hate IE, gave me error and I have to retype it again. I reread your question, and there are few things you need to modify
1. In your "Daily log' sharepoint list (datebase), is there a column datecol which you convert the date to ddmmyyyy, or yyyymmdd format?( yyyymmdd is preferred)?If not, you need to do this first, or if your sp list will not going over 2000, then you can do addcolumn with collection to avoid physically create a column in SP datebase.
2. In powerapps, create a label, text=Text(datepicker1.selectedDates,"yyyymmdd"), now the text should be 20191116 when you play with datepicker1.
3. Create a height flexible gallery, in item=Filter('Daily logs',DateCol = text1.Text), it should now filter your gallery based on datepicker1 now.
4. Your shiftperiod dropdown is good, now in your gallery, selected all the parts (date, person, shift period, arrow, separator) and choose "group", in the group's Visible property = If(Thisitem.shiftperiod = varFilter,true,false)
5. Now if you play it, it should filter based on datepicker1, and it will further hide the item based on shift dropdown.
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!