Molweni nonke! Namhlanje siza kuzama ukwenza ngokuzenzekelayo inkqubo yokudala ii-odolo kusetyenziswa i-platform yedatha ye-Microsoft Common Data Service kunye ne-Power Apps kunye neenkonzo ze-Power Automate. Siza kwakha amaziko kunye neempawu ezisekelwe kwiNkonzo yeDatha eqhelekileyo, sebenzisa ii-Power Apps ukwenza isicelo esilula seselula, kunye ne-Power Automate iya kunceda ukudibanisa onke amacandelo ngengqiqo enye. Masingachithi xesha!
Kodwa okokuqala, isigama esincinci. Sele sisazi ukuba zeziphi ii-Power Apps kunye ne-Power Automate, kodwa ukuba nabani na akazi, ndincoma ukuba ufunde amanqaku am angaphambili, umzekelo, okanye . Nangona kunjalo, asikacingi ukuba yintoni iNkonzo yeDatha eqhelekileyo, ngoko lixesha lokongeza ithiyori encinci.
Inkonzo yeeNkcukacha eziqhelekileyo (i-CDS emfutshane) yindawo yokugcina idatha njengesiseko sedatha. Ngokwenyani, le yidatabase ebekwe kwiMicrosoft 365 cloud kwaye inoqhagamshelo olusondeleyo kunye nazo zonke iinkonzo ze-Microsoft Power Platform. I-CDS ikwafumaneka ngeMicrosoft Azure kunye neMicrosoft Dynamics 365. Idatha inokungena kwi-CDS ngeendlela ezahlukeneyo, enye yeendlela, umzekelo, ukudala iirekhodi kwi-CDS ngesandla, ezifana ne-SharePoint. Yonke idatha kwiNkonzo yeDatha eqhelekileyo igcinwe kwiitafile ezibizwa ngokuba ngamaqumrhu. Kukho inani lamaqumrhu asisiseko onokuthi uwasebenzisele iinjongo zakho, kodwa unokwenza awakho amaqumrhu ngeempawu zakho. Ngokufana ne-SharePoint, kwiNkonzo yeDatha eqhelekileyo, xa udala uphawu, ungacacisa uhlobo lwayo kwaye kukho inani elikhulu leentlobo. Enye yezinto ezinomdla kukukwazi ukwenza okubizwa ngokuba yi "IiSeti zokuKhetha" (ezifana neenketho zeNdawo yokuKhetha kwiSharePoint), enokusetyenziswa kwakhona kuyo nayiphi na intsimi yequmrhu. Ngaphezu koko, idatha inokulayishwa kwimithombo eyahlukeneyo exhaswayo, kunye ne-Power Apps kunye ne-Power Automate streams. Ngokubanzi, ngokufutshane, i-CDS yinkqubo yokugcina idatha kunye nenkqubo yokubuyisela. Inzuzo yale nkqubo kukudityaniswa kwayo ngokusondeleyo kunye nazo zonke iinkonzo ze-Microsoft Power Platform, ezikuvumela ukuba wakhe izakhiwo zedatha zamanqanaba ahlukeneyo obunzima kwaye uzisebenzise kamva kwizicelo ze-Power Apps kwaye udibanise ngokulula kwidatha ngokusebenzisa i-Power BI yokunika ingxelo. I-CDS inojongano lwayo lokudala amaqumrhu, iimpawu, imithetho yeshishini, ubudlelwane, iimbono kunye needashbhodi. Ujongano lokusebenza ngeCDS lubekwe kwiwebhusayithi kwicandelo "Idatha", apho zonke iinketho eziphambili zokuseta amaqumrhu ziqokelelwa.
Ngoko ke makhe sizame ukuseta into ethile. Masenze iziko elitsha "Umyalelo" kwiNkonzo yeDatha eqhelekileyo:
Njengoko ubona, xa usenza iziko elitsha, kufuneka uchaze igama lalo kwixabiso elinye kunye namanani amaninzi, kwaye kufuneka uchaze umhlaba ongundoqo. Kwimeko yethu, oku kuya kuba yintsimi ethi "Igama". Ngendlela, unokuphinda ubeke ingqalelo yokuba amagama angaphakathi kunye nokubonisa amaqumrhu kunye namasimi aboniswa ngokukhawuleza kwifom enye, ngokungafaniyo ne-SharePoint, apho kufuneka uqale udale intsimi ngesiLatini, uze uyiqambe kwakhona ngesiRashiya.
Kwakhona, xa udala iziko, kunokwenzeka ukwenza inani elikhulu lezicwangciso ezahlukeneyo, kodwa asiyi kuyenza ngoku. Senza iziko kwaye siqhubele phambili ekudaleni iimpawu.
Senza umhlaba weNdawo ngodidi lwe "Iseti yeeparameters" kwaye sichaze iiparamitha ezi-4 kumxholo wale ndawo (Okutsha, Ukwenziwa, Kwenziwa, Kwaliwe):
Ngokufanayo, sidala imimandla eseleyo esiya kuyidinga ukuphumeza isicelo. Ngendlela, uluhlu lweentlobo zentsimi ezikhoyo zidweliswe ngezantsi; uyavuma, kukho ngokucacileyo uninzi lwazo?
Nceda uqaphele ukusetwa kwemimandla ekunyanzelekileyo kuyo, ukongeza ku-“Kufuneka” kunye “noKhetho”, kukwakho nokhetho “luNcetyisiweyo”:
Emva kokuba sidale yonke imimandla eyimfuneko, unokujonga kulo lonke uluhlu lwemimandla yezinto ezikhoyo kwicandelo elihambelanayo:
Iqumrhu liqwalaselwe kwaye ngoku kufuneka uqwalasele ifom yokungena kwedatha kwinqanaba leNkonzo yeeNkcukacha eziQhelekileyo kwiziko langoku. Yiya kwithebhu ethi "Iifom" kwaye ucofe u-"Yongeza iFomu" -> "Ifom ephambili":
Siseta ifom entsha yokufaka idatha ngeNkonzo yeDatha eqhelekileyo kwaye ulungelelanise amasimi emva komnye, kwaye emva koko ucofe iqhosha elithi "Papasha":
Ifom ilungile, makhe sijonge ukusebenza kwayo. Sibuyela kwiNkonzo yeDatha eqhelekileyo kwaye uye kwithebhu ethi "Idatha", emva koko ucofe "Yongeza irekhodi":
Kwifom yefestile evulayo, faka yonke idatha efunekayo kwaye ucofe "Gcina":
Ngoku kwicandelo leDatha sinongeno olunye:
Kodwa iindawo ezimbalwa ezibonisiweyo. Oku kulula ukulungisa. Yiya kwithebhu ethi "Iimbono" kwaye uvule umbono wokuqala wokuhlelwa. Beka iindawo ezifunekayo kwifom yokungeniswa kwaye ucofe u-“Papasha”:
Sijonga ukubunjwa kwamasimi kwicandelo elithi "Idatha". Yonke into iilungile:
Ngoko ke, kwicala leNkonzo yeeNkcukacha eziqhelekileyo, iqumrhu, amasimi, ukunikezelwa kwedatha kunye nefom yokungena kwedatha ngesandla ngqo kwi-CDS ilungile. Ngoku masenze i-Power Apps canvas app ukwenzela iziko lethu elitsha. Masiqhubele phambili ekwenzeni usetyenziso olutsha lwe-Power Apps:
Kwisicelo esitsha, siqhagamshela kwiziko lethu kwiNkonzo yeDatha eqhelekileyo:
Emva kwalo lonke uqhagamshelo, siseta izikrini ezininzi zesicelo sethu sePower Apps. Ukwenza isikrini sokuqala ngezibalo ezithile kunye notshintsho phakathi kweembono:
Senza isikrini sesibini ngoluhlu lwee-odolo ezikhoyo kwiziko le-CDS:
Kwaye senza esinye isikrini sokwenza iodolo:
Sigcina kwaye sipapashe usetyenziso, kwaye emva koko siluqhubele uvavanyo. Gcwalisa iindawo kwaye ucofe iqhosha elithi "Yenza":
Makhe sijonge ukuba irekhodi yenziwe na kwi-CDS:
Masijonge okufanayo kwisicelo:
Yonke idatha isendaweni. Ukuchukumisa okokugqibela kuhlala. Masenze i-Automatic Power encinci igeleza ukuba, xa usenza irekhodi kwiNkonzo yeDatha eqhelekileyo, iya kuthumela isaziso kumphathi womyalelo:
Ngenxa yoko, senze iqumrhu kunye nefom kwiNqanaba leNkonzo yeeNkcukacha eziqhelekileyo, isicelo se-Power Apps sokusebenzisana nedatha ye-CDS, kunye ne-Power Automate flow yokuthumela ngokuzenzekelayo izaziso kubadlali xa kusenziwa umyalelo omtsha.
Ngoku malunga namaxabiso. Inkonzo yeeNkcukacha eziQhelekileyo azifakwanga kunye neeNkqubo zaMandla eziza kunye nokubhaliselwa kwakho kwe-Ofisi 365. Oku kuthetha ukuba ukuba unobhaliso lwe-Ofisi 365 olubandakanya ii-Power Apps, awuyi kuba neNkonzo yeeNkcukacha eziqhelekileyo ngokuzenzekelayo. Ukufikelela kwi-CDS kufuna ukuthengwa kwelayisenisi ye-Power Apps eyahlukileyo. Amaxabiso ezicwangciso kunye nokukhethwa kwelayisensi zidweliswe ngezantsi kwaye athathwe kwiwebhusayithi :
Kumanqaku alandelayo, siza kujonga ngakumbi iimpawu zeNkonzo yeDatha eqhelekileyo kunye nePlatifomu yaMandla yeMicrosoft. Yiba nosuku oluhle, wonke umntu!
umthombo: www.habr.com