powerplatformsolutions's Introduction
powerplatformsolutions's People
powerplatformsolutions's Issues
DEV.TO create custom connector
PL100-S6 : copilot create new table
Articles : add xrm intellisense to vs code
PL100-S16 23 24 25 27 : remaining learning
- S16
- S20 : AI Builder
- S23 Misc
- S24 Dataverse workflows
- S25 Teams
- S26 RPA Certif : desktop flows
Licensing
How I manage my project
present favorites,
github projects
Datasetgrid
- bug on power apps samples DatesetGrid
https://github.com/microsoft/PowerApps-Samples/tree/master/component-framework/DataSetGrid
https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/Table-Grid-Dataset-Component-Sample/m-p/397886#M1174
https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/Table-Grid-Dataset-Component-Sample/m-p/397886#M1174
sync folder for solution with github codespaces
power automate flow article for API
Automate article sharing with a p automate
P Automate : API Peerberry implement status and loan type lookup
PL100-S6 : add records to table from Excel
Custom API : Peerberry : creation of a custom connector to get loans list
- discover endpoint of peerberry
- authentication part
- bug with token variable empty. to debug modified code
- azure : get loan data
- azure : parse data
- security for password via azure portal to put again
- sync with github
- PA learning : PL100 S15 & S16 + PL400
- sort ChatGPT
- PA : get data from Azure function
- PA : write data to dataverse. issue on lookup fields. need guid of each related record
- PA : call flow from Pocket Invest : button and Javascript code
Perf Improvement
updatedtrans variables : limit only to necessary fields to improve performance
- Preimage
- dll
Make a workflow about the part of technical design with chat gpt maybe
Custom plugins should not catch exception
if profiling turn on, not able to test exception of the code :
Message: ISV code reduced the open transaction count. Custom plug-ins should not catch exceptions from OrganizationService calls and continue processing.
try
{
_service.Execute(request);
}
catch (Exception ex)
{
throw new InvalidPluginExecutionException("An error occurred in the FollupupPlugin plug-in. " + ex.Message);
}
S10-S11 Custom button to call custom Api to update XIRR or some others things
YouTube Channel
https://www.youtube.com/watch?v=uL8BwstqiqE (obs studio)
Implement change tracking for XIRR field on Originator and Platform
Pocket Invest : platform credentials
Manage credentials with a new form and Entra ID or Dataverse security
Then use these credentials by calling the JS function calling the API Azure io having credentials setup in the AZ function
create a canvas app and leverage the try of test studio
- use the error upcomingfeature management IfError
- Test studio with case and step and record
- canvas app for loan table or loan originator
GitHub MS move all files from ms from node 16 to node 20
Generate table schedule payment
- https://github.com/microsoft/PowerApps-Samples/tree/master/component-framework/MapControl/MapControl
- generate a table that will be the schedule of the payment planned for each loans&id
- create dynamically schedule table for each loans
https://github.com/microsoft/PowerApps-Samples/tree/master/component-framework/TableGrid/TableGrid
Option Set Value
- set OptionSet value : https://neilparkhurst.com/2015/10/21/javascript-set-optionset-values-by-name/
Udemy RPA 500
ZTM Courses : create portfolio website
Building Profile
- Build Portfolio website : https://academy.zerotomastery.io/courses/enrolled/2064593 https://zerotomastery.io/courses/ai-freelancing/
- Build case studies : https://zerotomastery.io/courses/become-a-freelancer/ , https://academy.zerotomastery.io/courses/enrolled/2064593, https://zerotomastery.io/courses/ai-freelancing/
- Build online presence, present content, community : https://zerotomastery.io/courses/learn-freelance-consulting/, https://academy.zerotomastery.io/courses/enrolled/2064593
- Build resume : https://academy.zerotomastery.io/courses/enrolled/2064593
- Create logo : https://academy.zerotomastery.io/courses/enrolled/2064593
- Upwork profile : https://zerotomastery.io/courses/become-a-freelancer/ , https://zerotomastery.io/courses/learn-freelance-consulting/
- Find freelance jobs : https://zerotomastery.io/courses/become-a-freelancer/
- Master freelance finance : https://zerotomastery.io/courses/become-a-freelancer/
Plug-in optimization with batching
Implement ExecuteMultileRequest with XIRR function from a loan platform maybe
cf powerapp samples
check on which data events from platform put this position or maybe if put this function behin a button, create a component instead
https://www.udemy.com/course/pl-400-microsoft-power-platform-developer-course/learn/lecture/34175118#overview
Create action to export and import data between environments
Pac pcf push issue
- component on power platform added and deleted issue with pac pcf push (dont use vs command prompt, user old version in visual studio code) : https://stackoverflow.com/questions/56199111/visual-studio-code-cmd-error-cannot-be-loaded-because-running-scripts-is-disabl/67420296#67420296
Articles about github actions
PL-400 Udemy Developer
Power Automate Peerberry API : error handling
add error handling in case of originator or platform doesn't exist, add them.
enhance others actions to prevent errors
Udemy RPA
PL100-S15 Power automate and Copilot
Resolve solution checker results on solution and solution components
Still old version after refresh
loan view
set up 2 views for loans available and active : https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps
Linkedin Publication
Linkedin part : https://nealschaffer.com/how-to-publish-on-linkedin/
pull request with my files to power platforms Microsoft lab
ConcurrencyModel
Articles on concurrency model
take care of loanref because does not contains the rowversion, so we have to make a retrieve to get the row version
Entity updatedTransaction = (Entity)context.PreEntityImages["PreImageXIRR"];
//tracingService.Trace("Stage {0}", ++tracingStep);
EntityReference loanRef = (EntityReference)updatedTransaction.Attributes["cr471_loanid"];
Entity loanEntity = organizationService.Retrieve("cr471_loans", loanRef.Id , new ColumnSet("cr471_xirr"));
//OK
//var loanEntity2 = new Entity("cr471_loans");
//loanEntity2.Id = loanEntity.Id;
//loanEntity2["cr471_xirr"] = devtest;
//organizationService.Update(loanEntity2);
//OK
////SIMPLE MODE TEST
//Entity loanEntity = organizationService.Retrieve("cr471_loans", loanRef.Id, new ColumnSet("cr471_xirr"));
//decimal devtest = 7;
//loanEntity["cr471_xirr"] = devtest;
//organizationService.Update(loanEntity);
//CONCURRENCY MODE TEST
Entity newLoan = new Entity("cr471_loans", loanEntity.Id);
decimal devtest = 9;
newLoan["cr471_xirr"] = devtest;
// Set the row version for concurrency behavior
// Error -2147088253 will occur if this is not set
newLoan.RowVersion = loanEntity.RowVersion;
UpdateRequest request = new UpdateRequest()
{
Target = newLoan,
// The operation will fail if the record is updated in the period since it was retrieved.
ConcurrencyBehavior = ConcurrencyBehavior.IfRowVersionMatches
};
organizationService.Execute(request);
Power Automate : Peerberry API add mail notifications with new loans as confirmation and manage update create
PL100-S6 export data from table and maybe import in PBI
pocket invest : improve model-driven app performance
- avoid button useless
- avoid loading not important fields on the first tab
- avoid loading of async js function on onload and onchange events
- avoid loading a maximum of function on loading event and on the first tab
- play with monitor and flags
3d contribution chart
S13 : GitHub use Power Platform actions
-
https://learn.microsoft.com/en-us/power-platform/alm/devops-github-actions
-
pl100 s23 144
-
pl100 s26
-
add these actions in export from dev :
https://github.com/VinEckSie/powerplatform-actions/blob/main/set-online-solution-version/action.yml[
](https://github.com/VinEckSie/powerplatform-actions/blob/main/check-solution/action.yml)
address-autocomplete/
Articles : URL to get metadata
- get metadata :
Get metadata :
The following example gets the
scheduledstart column of the
appointment table for the
row with ID d2862246-4763-ee11-8def-000d3a34118b.
https://org859aecd5.crm16.dynamics.com/api/data/v9.2.24022.00170/Loan(6b0e784b-9fd0-ee11-904d-002248e53c36)?
6b0e784b-9fd0-ee11-904d-002248e53c36
version :
var globalContext = Xrm.Utility.getGlobalContext();
globalContext.getVersion()
https://org859aecd5.crm16.dynamics.com/main.aspx?appid=f336cc89-bad0-ee11-904d-002248e53c36&pagetype=entityrecord&etn=cr471_
loans&id=6b0e784b-9fd0-ee11-904d-002248e53c36
https://org859aecd5.crm16.dynamics.com/api/data/v9.2.24022.00170/cr471_loanses
https://org859aecd5.crm16.dynamics.com/api/data/v9.2.24022.00170/cr471_loanses(6b0e784b-9fd0-ee11-904d-002248e53c36)
create github repo with power platform actions to share
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.