powerplatformsolutions's Issues
sync folder for solution with github codespaces
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
Articles : add xrm intellisense to vs code
Option Set Value
- set OptionSet value : https://neilparkhurst.com/2015/10/21/javascript-set-optionset-values-by-name/
Power Automate : Peerberry API add mail notifications with new loans as confirmation and manage update create
Perf Improvement
updatedtrans variables : limit only to necessary fields to improve performance
- Preimage
- dll
Implement change tracking for XIRR field on Originator and Platform
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
address-autocomplete/
PL100-S6 : add records to table from Excel
How I manage my project
present favorites,
github projects
PL100-S6 : copilot create new table
PL100-S6 export data from table and maybe import in PBI
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)
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
PL-400 Udemy Developer
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);
}
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/
Udemy RPA
P Automate : API Peerberry implement status and loan type lookup
power automate flow article for API
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);
Licensing
DEV.TO create custom connector
S10-S11 Custom button to call custom Api to update XIRR or some others things
Udemy RPA 500
YouTube Channel
https://www.youtube.com/watch?v=uL8BwstqiqE (obs studio)
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
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
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)
Automate article sharing with a p automate
ZTM Courses : create portfolio website
Make a workflow about the part of technical design with chat gpt maybe
3d contribution chart
PL100-S15 Power automate and Copilot
pull request with my files to power platforms Microsoft lab
PL100-S16 23 24 25 27 : remaining learning
- S16
- S20 : AI Builder
- S23 Misc
- S24 Dataverse workflows
- S25 Teams
- S26 RPA Certif : desktop flows
Linkedin Publication
Linkedin part : https://nealschaffer.com/how-to-publish-on-linkedin/
Create action to export and import data between environments
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
create github repo with power platform actions to share
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
Resolve solution checker results on solution and solution components
Articles about github actions
Still old version after refresh
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
TODO RPA
-
dress the plan according to the docs
-
wait next meeting next thursday
-
make exercises
-
mix example of chat gpt about pa pad and pbi with the fact to
-
interact with contosoinvoicing apps (check all action we can do in this application)
-
add a step to to use action regarding open a browser and fill informations
i think about one cloud flow that when we receive an email we call the desktop flow to put information about an invoice on the invoice contoso app. either informations are in the body of the mail, either wehave to extract to a pdf joined file
-
issue . check if pdf extraction is possible and checke with parallel desktop how to add this machine to a machine group this is mandtaroy to call desktop flow from pa
-
use try catch scope on cloud flow and onerror block on desktop
flow
- child flow with cloud flow
loan view
set up 2 views for loans available and active : https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps
GitHub MS move all files from ms from node 16 to node 20
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.