User Profile
Freenit
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Unique values in group collection
Hello. I have a collection that displays the results of employees' certifications. The certificate shows the "position" where an employee can work. One employee can have several result pass and not pass. I need to display the last exam result based on position. I have grouped the collection by "Position_certification": ClearCollect(GroupedBy_Position, GroupBy( CertificationList_coll, "Position_certification", "UserData" )); And now I need to filter"UserData"so that only the latest and unique values by user`s email stay in. In the end, I need a collection with all unique employees with their latest certification result Could someone help with this challenge?Date Subtraction
Hello. I am trying to subtract two days in PowerApps: DateDiff( Now(), DateValue("1/1/2014") ) Logically the result should be a positive value, but I get the negative one. According to the specification, it also should be positive. Could someone explain why the result is negative? I have made some experiments and If I change the position of members then I got a positive result. So, why the PowerApps is working not according to specification?PowerApps: get calendar from Outlook
Hello. Is it possible in PowerApps to get a custom calendar from Outlook? When I use a formula to get a calendar from my Outlook: ClearCollect( Calendar_Coll, /*Calendar_Coll is my custom collection*/ Office365Outlook.V4CalendarGetItems( LookUp( Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar" /*"Calendar" is one of my calendars*/ ).Name ).value ) I can get only the default calendars when I change a value for the "DisplayName" - Calendar, Birthday... I create a custom calendar with "Add from directory" Outlook`s functionality for tracking meeting rooms. Is it possible somehow to get data from that calendar into the PowerApps? Thanks a lot.Delegation complex type
Hello. I am trying to filter the data in the SharePoint list based on the "Person" type field. Based on the specification it is possible if you use DisplayName or Email properties. I need to receive data that is responding only to the user that is open PowerApps application. I am trying to filter data with "Email" and "DisplayName" but the result is the same - delegation warning. Filter('Materials Permissions',Person.DisplayName = Office365Users.MyProfileV2().displayName) Filter('Materials Permissions',Person.Email = Office365Users.MyProfileV2().mail) "Material Permissions" is my SharePoint list where data is saving. "Person" is the column in the SPO list with the "Person" type. Could someone advise how to solve this problem? Thanks in advance.Hitting an action limit
Hello. I have received the next message I have created one flow with a mistake and as a result, it sends continuous emails during the night. I cannot create flow with the "SEND EMAIL" block because it all time fails. Additionally, all my flows stop working where I am using this action "SEND EMAIL". I have tried to rebuild the flow but it always fails on the step of sending an email. How to solve this issue, that I can start using this action again???Not all parameters visible
I think after some updates of PowerApss by Microsoft now not all parameters are visible when you add PowerAutomate to PowerApps applications. Only several first parameters are visible. And how to understand what you need to add next? Only through testing your flow and see what you receive to your variables.PowerAutomate: Get Changes for an item or a file (Properties Only)
Hello. I am trying to use new action control: But when I check if one of the properties is changed or not the result is always true even when I don't change it. Could someone recommend how to use correctly properties from this action? Thanks in advance.PowerApps Set(varName, camera1.stream) not working
Hello. I am trying to get an image from "Camera" control by using a variable and then assign this value to the "Image" media control. When the button is clicked then variable assigned to camera.stream value. Set(varName, camera1.Stream) I don't know what happened but now this method not working. Variable does not take the camera1.stream value. In my previous programs, all are working fine.
