How to get record before and after in forall loop powerapps

See also questions close to this topic

• compare two separate data sets

  is it possible to compare particular values from a table/report from power bi data set with another table from excel sheet?

  In the power bi data set i have the organization data about all employees, and in my excel i have the data for 10 particular individuals. (something like: Name, Grade, Role, Team, Joining Date, Departure Date)

  What i now do is to create in power bi the report with just the 10 people, export the data and then i compare that table with my local one, if there are any mismatches, like if the grades changed or they move to another team/department or some thing, in my local file i have some custom/aditional columns that arent in the powerbi dataset (Name, Grade, Role, Team, Joining Date, Departure Date, Comment, Skills, Future team)

  i could not load a data set from the excel file, and also from the company powerbi dataset, in the same report/page
• Format date with dax

  I have dates like:

  

  I need to do two transformations:

  Convert it into datetime

  field date and time in the initial data shows in GMT. Necessary translate into our local time as well as our working hours. Local time = time in Kyiv which also takes into account daylight saving time. Working hours = because we work 24/7, we take into account the beginning of each day not from 00:00, and from 7:25 am. That is, if the purchase was made on February 1 at 7:15, it has enroll until January 31. For the second point I used this function, how to midify it to respond to the requirement please?

  let
  Source = (datetimecolumn as datetime) =>
  
  let
  date = DateTime.Date(datetimecolumn),
  time = DateTime.Time(datetimecolumn),
  lastSundayOfOctober = Date.StartOfWeek(#date(Date.Year(date), 10, 31), Day.Sunday),
  lastSundayOfMarch = Date.StartOfWeek(#date(Date.Year(date), 3, 31), Day.Sunday),
  
  isSummerTime = (date = lastSundayOfMarch and time >= #time(2,0,0))
  or
  (date > lastSundayOfMarch and date < lastSundayOfOctober)
  or
  (date = lastSundayOfOctober and time <= #time(2,0,0)),
  timeZone = 1 + Number.From(isSummerTime),
  CET =
  DateTime.From(date)
  + #duration(0,Time.Hour(time),Time.Minute(time),Time.Second(time))
  + #duration(0, timeZone, 0, 0)
  in
  CET
  in
  Source 2e
  
• Display data from SharePoint Online document library on Powerapp

  I am looking for the best solution to get the documents from SharePoint online document library and display them on a website or power app. The website or app will be used by anonymous users. I worked on the Powerapp and was able to display the documents from SharePoint but when we deploy the app then it asks for authentication. How can this be avoided?

  Can this be achieved by azure logic app? Many thanks, Rajesh
• Power Platform admin center - missing "Data export (preview)" option

  I've tried to enable synchronization of logs between my Dataverse environment and Azure Application Insights service. I've tried to setup the thing according to the https://docs.microsoft.com/en-us/power-platform/admin/set-up-export-application-insights article. What I'm missing is the "Data export (preview)" menu option in my admin.powerplatform.com portal :/.

  

  Any idea what is the reason of the described situation?

  Am I missing some feature? Or should I enable something in my tenant?

  Any help will be appreciated.
• retrieving data from a Sharepoint Person column on PowerApp

  i have a powerapp with a gallery showing users stored in a sharepoint list inside a Person column named User.

  I have no problem in showing the users, for instance, in my gallery i can use ThisItem.User.DisplayName with no problem, but when i want to make a search filtered on some user data it doesnt work. If i try filtering using another column such as "city" it works, so it seems an error due to the type of the data that the Person column output.

  this is the code i want to apply to my gallery

  search(MyList,searchbar.text,User.DisplayName)
  

  the error says "Name isn't valid. 'User' isn't recognized." how to fix this? Thanks in advance
• Submit Form based on dataverse table with Polymorphic field owner

  I've created a form based on a dataverse table with User/Team ownership.

  In such table only 3 fields are required:

  • ID
  • Status
  • Owner

  When adding those 3 field to the form I can see values for the first 2, not for the Owner field.

  Trying to submit the form (after modifying an existing record) I get a generic failure message.

  An entry is required or has an invalid value. Please correct and try again
  

  I have the suspect that the form doesn't provide data for updating the Owner field, and this led me to study those Polymorphic fields.

  After reading this, that and another post, I understood how to show the Owner of this field in the form datacard (although this was not my goal). But I'm still having problem updating that field.

  so my question is, if a record already has an owner, do I still need to Update it? how can I do that? do I need to use Patch or can I write it in the Update property to make it work along with SubmitForm(...)?

  In this case for me the owner should be automatically picked up based on User().Email.

  Bonus question, when creating a new record in this table, will I also have to generate the ID or dataverse will still take care of it? on the same topic, will I have to figure out how to provide an "Active" value for the Status field too?

  Thank you in advance for any help!
• Dynamics 365 OAuth 2.0 Authentication failed

  I have set up Dynamics 365 using a Trial subscription with a database. Deployment is set to FieldService Premium Trial.

  For querying data from Dataverse I have to use WebAPI but it is failing to authenticate from the postman. I have set up Azure Active directory with the following settings.

  

  And manifest is set up like this:

  {
      "acceptMappedClaims": null,
      "accessTokenAcceptedVersion": null,
      "addIns": [],
      "allowPublicClient": true,
      "appRoles": [],
      "oauth2AllowUrlPathMatching": false,
      "createdDateTime": "2022-04-22T11:11:03Z",
      "description": null,
      "certification": null,
      "disabledByMicrosoftStatus": null,
      "groupMembershipClaims": null,
      "identifierUris": [],
      "informationalUrls": {
          "termsOfService": null,
          "support": null,
          "privacy": null,
          "marketing": null
      },
      "keyCredentials": [],
      "knownClientApplications": [],
      "logoUrl": null,
      "logoutUrl": null,
      "name": "RentReady",
      "notes": null,
      "oauth2AllowIdTokenImplicitFlow": true,
      "oauth2AllowImplicitFlow": true,
      "oauth2Permissions": [],
      "oauth2RequirePostResponse": false,
      "optionalClaims": null,
      "orgRestrictions": [],
      "parentalControlSettings": {
          "countriesBlockedForMinors": [],
          "legalAgeGroupRule": "Allow"
      },
      "passwordCredentials": [],
      "preAuthorizedApplications": [],
      "publisherDomain": "rentreadytrialtest.onmicrosoft.com",
      "replyUrlsWithType": [
          {
              "url": "https://localhost",
              "type": "Web"
          }
      ],
      "requiredResourceAccess": [
          {
              "resourceAppId": "00000007-0000-0000-c000-000000000000",
              "resourceAccess": [
                  {
                      "id": "78ce3f0f-a1ce-49c2-8cde-64b5c0896db4",
                      "type": "Scope"
                  }
              ]
          },
          {
              "resourceAppId": "00000003-0000-0000-c000-000000000000",
              "resourceAccess": [
                  {
                      "id": "e1fe6dd8-ba31-4d61-89e7-88639da4683d",
                      "type": "Scope"
                  }
              ]
          }
      ],
      "samlMetadataUrl": null,
      "signInUrl": null,
      "signInAudience": "AzureADMultipleOrgs",
      "tags": [],
      "tokenEncryptionKeyId": null
  }
  

  I have removed the App Id from this manifest for security reasons. Sharing the postman configuration.

  

  I have removed the App ID here as well for security concerns. After authorizing using both as a postman and on a web browser I am having the same error.