{"id":18387,"date":"2023-04-19T15:04:41","date_gmt":"2023-04-19T11:34:41","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/power-apps-how-to-do-loops-in-power-fx-3k35\/"},"modified":"2023-04-19T15:04:41","modified_gmt":"2023-04-19T11:34:41","slug":"power-apps-how-to-do-loops-in-power-fx-3k35","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/power-apps-how-to-do-loops-in-power-fx-3k35\/","title":{"rendered":"Power Apps- \u0646\u062d\u0648\u0647 \u0627\u0646\u062c\u0627\u0645 \u062d\u0644\u0642\u0647 \u0647\u0627 \u062f\u0631 Power FX"},"content":{"rendered":"<div data-article-id=\"1431475\" id=\"article-body\">\n<p>Power FX \u0632\u0628\u0627\u0646 LowCode \u067e\u0644\u062a\u0641\u0631\u0645 Power \u0627\u0633\u062a\u060c \u062f\u0631 \u0627\u0635\u0644 \u0641\u0642\u0637 \u062f\u0631 Canvas Apps \u0628\u0647 Dataverse \u0648 Power Virtual Agents \u06af\u0633\u062a\u0631\u0634 \u0646\u0645\u06cc \u06cc\u0627\u0628\u062f.  \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0627\u06cc\u0646\u06a9\u0647 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0639\u0628\u0627\u0631\u0627\u062a (\u0645\u0627\u0646\u0646\u062f Excel \u0648 Power Automate) \u0627\u0633\u062a\u060c \u0628\u0647 \u0637\u0648\u0631 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0628\u0627 \u0686\u06cc\u0632\u06cc \u0645\u0627\u0646\u0646\u062f VBA \u06cc\u0627 Python \u0642\u0627\u0628\u0644 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0646\u06cc\u0633\u062a.  \u0645\u0627\u0646\u0646\u062f \u0627\u06a9\u0633\u0644\u060c Power FX \u062f\u0631 \u06cc\u06a9 \u0633\u0637\u062d \u067e\u0627\u06cc\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0627 \u0645\u0624\u0644\u0641\u0647\u200c\u0647\u0627 \u062f\u0631 \u0647\u0645 \u062a\u0646\u06cc\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a (\u0641\u0631\u0645\u0648\u0644\u200c\u0647\u0627\/\u062a\u0648\u0627\u0628\u0639 \u0627\u06a9\u0633\u0644 \u0628\u0627 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\/\u06a9\u0627\u0631\u0628\u0631\u06af\u200c\u0647\u0627 \u0648 \u063a\u06cc\u0631\u0647 \u062f\u0631 \u0647\u0645 \u062a\u0646\u06cc\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f)\u060c \u0627\u06cc\u0646 \u0628\u062f\u0627\u0646 \u0645\u0639\u0646\u0627\u0633\u062a \u06a9\u0647 \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u0635\u0644\u06cc \u0631\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0647 \u0645\u0624\u0644\u0641\u0647\u200c\u0647\u0627 \u0628\u0631\u0648\u0646 \u0633\u067e\u0627\u0631\u06cc \u06a9\u0631\u062f (\u0645\u0627\u0646\u0646\u062f \u062a\u0627\u06cc\u0645\u0631\u0647\u0627\/ \u062a\u0623\u062e\u06cc\u0631\u0647\u0627).<\/p>\n<p>\u06cc\u06a9\u06cc \u0627\u0632 \u062c\u0627\u0644\u0628\u200c\u062a\u0631\u06cc\u0646 \u062c\u0646\u0628\u0647\u200c\u0647\u0627\u06cc Power FX \u0646\u062d\u0648\u0647 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062d\u0644\u0642\u0647\u200c\u0647\u0627 \u0627\u0633\u062a.  \u062e\u0627\u0631\u062c \u0627\u0632 \u062c\u0639\u0628\u0647\u060c \u0633\u0627\u06cc\u0631 \u0632\u0628\u0627\u0646\u200c\u0647\u0627\u06cc \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0639\u0628\u0627\u0631\u062a \u062d\u0644\u0642\u0647 \u0646\u062f\u0627\u0631\u0646\u062f (Excel none \u0648 Power Automate \u0628\u0647 \u0627\u0642\u062f\u0627\u0645\u0627\u062a\u06cc \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u0646\u062f).  Power FX \u06cc\u06a9 \u062d\u0644\u0642\u0647 (ForAll) \u062f\u0627\u0631\u062f\u060c \u0627\u0645\u0627 \u06a9\u0627\u0645\u0644\u0627\u064b \u0645\u0634\u0627\u0628\u0647 \u062d\u0644\u0642\u0647 \u0647\u0627\u06cc \u0632\u0628\u0627\u0646 \u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0646\u06cc\u0633\u062a.  \u0628\u0631\u0627\u06cc \u067e\u0648\u0634\u0634 \u0628\u0631\u062e\u06cc \u0627\u0632 \u062d\u0630\u0641\u06cc\u0627\u062a \u0622\u0646 \u062c\u0632\u0621 \u062a\u0627\u06cc\u0645\u0631 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u062a\u06a9\u0631\u0627\u0631\u067e\u0630\u06cc\u0631\u06cc \u0622\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u062d\u0644\u0642\u0647 \u0646\u06cc\u0632 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u0648\u062f.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u062a\u063a\u06cc\u06cc\u0631 \u0648\u0636\u0639\u06cc\u062a \u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/power-apps-how-to-do-loops-in-power-fx-3k35\/#%D8%A8%D8%B1%D8%A7%DB%8C_%D9%87%D9%85%D9%87\" >\u0628\u0631\u0627\u06cc \u0647\u0645\u0647<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/power-apps-how-to-do-loops-in-power-fx-3k35\/#%D8%A8%D8%B1%D8%A7%DB%8C_%D9%87%D9%85%D9%87_%E2%80%93_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF\" >\u0628\u0631\u0627\u06cc \u0647\u0645\u0647 &#8211; \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/power-apps-how-to-do-loops-in-power-fx-3k35\/#ForAll_%E2%80%93_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%BA%DB%8C%D8%B1_%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF\" >ForAll &#8211; \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u063a\u06cc\u0631 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/power-apps-how-to-do-loops-in-power-fx-3k35\/#%D8%AA%D8%A7%DB%8C%D9%85%D8%B1%D9%87%D8%A7\" >\u062a\u0627\u06cc\u0645\u0631\u0647\u0627<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A8%D8%B1%D8%A7%DB%8C_%D9%87%D9%85%D9%87\"><\/span>\n<p>  \u0628\u0631\u0627\u06cc \u0647\u0645\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062a\u0627\u0628\u0639 ForAll \u0628\u06cc\u0634\u062a\u0631 \u0628\u0627 \u06cc\u06a9 \u062d\u0644\u0642\u0647 ForEach \u0642\u0627\u0628\u0644 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0627\u0633\u062a\u060c \u0632\u06cc\u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0641\u0632\u0627\u06cc\u0634 \u0628\u0647 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647\/\u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f.  \u0686\u0646\u062f \u0646\u06a9\u062a\u0647 \u06a9\u0644\u06cc\u062f\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0622\u0646\u0647\u0627 \u0622\u06af\u0627\u0647 \u0628\u0648\u062f:<\/p>\n<ul>\n<li>\u0634\u0645\u0627 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0645\u062a\u063a\u06cc\u0631\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0622\u0646 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f<br \/>\n\n<\/li>\n<li>\u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u062f (\u0634\u0645\u0627 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0631\u0627 \u06a9\u0647 \u062f\u0631 \u062d\u0627\u0644 \u062d\u0644\u0642\u0647 \u0632\u062f\u0646 \u0647\u0633\u062a\u06cc\u062f \u0648\u0635\u0644\u0647 \u06a9\u0646\u06cc\u062f)<br \/>\n<img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/04\/1681904080_483_Power-Apps-\u0646\u062d\u0648\u0647-\u0627\u0646\u062c\u0627\u0645-\u062d\u0644\u0642\u0647-\u0647\u0627-\u062f\u0631-Power-FX.png\" alt=\"\u062e\u0637\u0627\u06cc \u062e\u0648\u062f \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc ForAll\" loading=\"lazy\" width=\"800\" height=\"167\" title=\"\">\n<\/li>\n<li>\u062d\u0644\u0642\u0647 \u0628\u0627\u06cc\u062f \u06a9\u0627\u0645\u0644 \u0634\u0648\u062f (\u0628\u062f\u0648\u0646 \u0648\u0642\u0641\u0647 \/ \u062a\u0648\u0642\u0641)<\/li>\n<li>\u0647\u0645\u06cc\u0634\u0647 \u0645\u0631\u0627\u062d\u0644 \u06cc\u06a9 (\u0645\u062b\u0644\u0627\u064b \u0646\u0645\u06cc \u062a\u0648\u0627\u0646 \u062f\u0631 2 \u062b\u0627\u0646\u06cc\u0647 \u0627\u0641\u0632\u0627\u06cc\u0634 \u062f\u0627\u062f)<\/li>\n<li>\u0647\u06cc\u0686 \u0634\u0627\u062e\u0635 \u062f\u0627\u062e\u0644\u06cc \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f<\/li>\n<li>\u0647\u0645\u0647 \u0645\u0648\u0627\u0631\u062f \u062f\u0627\u062e\u0644\u06cc \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 ThisRecord \u0627\u0631\u062c\u0627\u0639 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f (\u062d\u0644\u0642\u0647\u200c\u0647\u0627\u06cc \u062f\u0631\u0648\u0646 \u062d\u0644\u0642\u0647\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u0627\u0631\u062c\u0627\u0639 \u0628\u0647 \u062d\u0644\u0642\u0647 \u0635\u062d\u06cc\u062d \u062f\u0634\u0648\u0627\u0631 \u0627\u0633\u062a)<\/li>\n<\/ul>\n<p>\u0627\u06af\u0631 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u062f\u0647\u0627\u06cc \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0628\u0631\u0627\u06cc \u0645\u0648\u0627\u0631\u062f \u062c\u0627\u0644\u0628\u200c\u062a\u0631 \u0635\u0631\u0641\u0646\u0638\u0631 \u06a9\u0646\u06cc\u062f\u060c \u0627\u06cc\u0646\u062c\u0627 \u0631\u0627 \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A8%D8%B1%D8%A7%DB%8C_%D9%87%D9%85%D9%87_%E2%80%93_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF\"><\/span>\n<p>  \u0628\u0631\u0627\u06cc \u0647\u0645\u0647 &#8211; \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u06cc\u06a9 ForAll \u0627\u0648\u0644\u06cc\u0647 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(array,[1,2,3,5,8,13,21]);\nForAll(array,\n    Notify(ThisRecord.Value)\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u0645\u0627 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc \u0628\u06cc\u0646\u06cc\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0628\u0647 \u0627\u06cc\u0646 \u0634\u06a9\u0644 \u0628\u06cc \u0645\u0639\u0646\u06cc \u0627\u0633\u062a (\u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0647\u06cc\u0686 \u062a\u0627\u062e\u06cc\u0631\u06cc \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0641\u0642\u0637 \u0622\u062e\u0631\u06cc\u0646 \u0627\u0639\u0644\u0627\u0646 \u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u06cc\u062f).<\/p>\n<p>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u0641\u06cc\u062f\u062a\u0631 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u062c\u062f\u06cc\u062f \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(array,[1,2,3,5,8,13,21]);\nClearCollect(array2,\n    ForAll(array,\n        {Value:Value+1}\n    )\n);\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0631 \u0628\u0627\u0644\u0627 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0627\u0632 2\u060c3\u060c4\u060c6\u060c9\u060c14\u060c22 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0645\u0627 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0647\u0627\u06cc Object \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(array,[\n    {fib:1,word:\"one\",id:1},\n    {fib:2,word:\"two\",id:2},\n    {fib:3,word:\"three\",id:3},\n    {fib:5,word:\"five\",id:4},\n    {fib:8,word:\"eight\",id:5},\n    {fib:13,word:\"thirteen\",id:6},\n    {fib:21,word:\"twenty on\",id:7}\n]);\nClearCollect(array2,\n    ForAll(array,\n        {Value:Left(word,2)}\n    )\n);\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647<br \/><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/04\/1681904081_586_Power-Apps-\u0646\u062d\u0648\u0647-\u0627\u0646\u062c\u0627\u0645-\u062d\u0644\u0642\u0647-\u0647\u0627-\u062f\u0631-Power-FX.png\" alt=\"\u0646\u062a\u0627\u06cc\u062c \u0645\u062c\u0645\u0648\u0639\u0647 \u0622\u0631\u0627\u06cc\u0647 2\" loading=\"lazy\" width=\"800\" height=\"672\" title=\"\"><\/p>\n<p>\u0627\u06af\u0631\u0686\u0647 \u0646\u06a9\u062a\u0647 \u0633\u0631\u06cc\u0639\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0639\u0645\u0644\u06a9\u0631\u062f\u0647\u0627\u06cc \u062e\u0627\u0635\u06cc \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0647\u0627 \u0646\u06cc\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u0648 \u0646\u06cc\u0627\u0632 \u0628\u0647 ForAll \u0631\u0627 \u0627\u0632 \u0628\u06cc\u0646 \u0628\u0628\u0631\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(array2,Left(array.word,2));\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0648\u0627\u0631\u062f \u0641\u0648\u0642 \u0647\u0645\u0627\u0646 \u0646\u062a\u0627\u06cc\u062c ForAll \u0628\u0627\u0644\u0627 \u0631\u0627 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u062e\u0648\u0627\u0647\u062f \u062f\u0627\u0634\u062a.<\/p>\n<p>\u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u062f\u06cc\u06af\u0631 \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0628\u0627 \u0645\u0642\u062f\u0627\u0631\u06cc \u0627\u0632 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u0648\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(Objects,\n    {a:1,b:\"A\",c:true,ID:1},\n    {a:11,b:\"B\",c:false,ID:2},\n    {a:-11,b:\"C\",c:false,ID:3},\n    {a:7,b:\"D\",c:true,ID:4}\n);\nForAll( Objects, \n    Patch(variables,{ID:ThisRecord.ID},\n        {LetterNo:ThisRecord.b&amp;ThisRecord.ID}\n    );\n);\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06af\u0631\u0686\u0647 \u0646\u06a9\u062a\u0647 \u062f\u06cc\u06af\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Drop\/Add\/RenameColumns \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0647\u0645\u06cc\u0646 \u06a9\u0627\u0631 \u0627\u0633\u062a:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(varaibles2,\n    DropColumns(\n        AddColumns(Objects,\"Letter\",b&amp;ID)\n    ,\n        \"a\",\"b\",\"c\"\n    )\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"ForAll_%E2%80%93_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%BA%DB%8C%D8%B1_%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF\"><\/span>\n<p>  ForAll &#8211; \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u063a\u06cc\u0631 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0645\u0646\u0638\u0648\u0631 \u0645\u0646 \u0627\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u063a\u06cc\u0631 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0686\u06cc\u0633\u062a\u060c \u062e\u0648\u0628 \u0627\u06cc\u0646 \u0631\u0648\u0634\u06cc \u0627\u0633\u062a \u0628\u0631\u0627\u06cc \u062f\u0648\u0631 \u0632\u062f\u0646 \u0628\u0631\u062e\u06cc \u0627\u0632 \u0645\u062d\u062f\u0648\u062f\u06cc\u062a \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0630\u06a9\u0631 \u06a9\u0631\u062f\u06cc\u0645.<\/p>\n<p><strong>\u0646\u0645\u06cc \u062a\u0648\u0627\u0646 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627 \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0631\u062f<\/strong><br \/>\u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0646\u062a\u0648\u0627\u0646\u06cc\u062f \u0645\u062a\u063a\u06cc\u0631\u0647\u0627 \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f\u060c \u0627\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0622\u0631\u0627\u06cc\u0647 \u0647\u0627\/\u0645\u062c\u0645\u0648\u0639\u0647 \u0647\u0627 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u062f.  \u0648 \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u062a\u06a9 \u0631\u062f\u06cc\u0641 \u062a\u0642\u0631\u06cc\u0628\u0627\u064b \u06cc\u06a9 \u0634\u06cc \u0627\u0633\u062a \u0648 \u06cc\u06a9 \u0634\u06cc\u0621 \u06af\u0631\u0648\u0647\u06cc \u0627\u0632 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627 \u0627\u0633\u062a (\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u062f \u0628\u0647 \u06a9\u062c\u0627 \u0645\u06cc \u0631\u0648\u0645).  \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062a\u0646\u0647\u0627 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0628\u0627 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0628\u0627 \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062a\u063a\u06cc\u0631 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.  \u0633\u067e\u0633 \u062f\u0631 ForAll \u0627\u0632 \u06cc\u06a9 If \u0628\u0631\u0627\u06cc Patch \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(Objects,\n    {a:1,b:\"A\",c:true,ID:1},\n    {a:11,b:\"B\",c:false,ID:2},\n    {a:-11,b:\"C\",c:false,ID:3},\n    {a:7,b:\"D\",c:true,ID:4}\n);\nClearCollect(variables3,\n    {ID:1,Field_b:\"\",\n    Field_c:false,\n    Field_a:0}\n);\nForAll(Objects,\n    If(ThisRecord.b=\"B\",\n        Patch(variables3,{ID:1},\n            {Field_b:ThisRecord.b}\n        )\n    );\n    If(ThisRecord.c=true,\n        Patch(variables3,{ID:1},\n            {Field_c:ThisRecord.c}\n        )\n    );\n      If(ThisRecord.a=-11,\n        Patch(variables3,{ID:1},\n            {Field_a:ThisRecord.a}\n        )\n    )\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/04\/1681904081_0_Power-Apps-\u0646\u062d\u0648\u0647-\u0627\u0646\u062c\u0627\u0645-\u062d\u0644\u0642\u0647-\u0647\u0627-\u062f\u0631-Power-FX.png\" alt=\"\u062a\u0648\u0636\u06cc\u062d\u0627\u062a \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"509\" height=\"378\" title=\"\"><\/p>\n<p><strong>\u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u062e\u0648\u062f\u0634 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u062f<\/strong><br \/>\u0628\u0631 \u0627\u0633\u0627\u0633 \u062a\u0646\u0638\u06cc\u0645 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u060c \u062a\u0646\u0647\u0627 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 Select() \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u060c \u0632\u06cc\u0631\u0627 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 Patch \u0631\u0627 \u0628\u0647 \u062f\u06a9\u0645\u0647 \u062f\u06cc\u06af\u0631\u06cc \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645\u060c \u06a9\u0647 \u0648\u0642\u062a\u06cc OnSelected \u0627\u0632 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\/\u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u06a9\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(Objects,\n    {a:1,b:\"A\",c:true,ID:1},\n    {a:11,b:\"B\",c:false,ID:2},\n    {a:-11,b:\"C\",c:false,ID:3},\n    {a:7,b:\"D\",c:true,ID:4}\n);\nClearCollect(variables4,\n    {ID:1,Set:0}\n);\nForAll(Objects,\n    If(ThisRecord.b=\"B\",\n        Patch(variables4,{ID:1},\n            {Set:ThisRecord.a}\n        );\n        Select(buUpdateSelf);\n    );\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>buUpdateSelf<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>Patch(Objects,{ID:Index(variables4,1).ID},{\n    a: Index(variables4,1).Set\n    }\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<hr\/>\n<p>\u0627\u06af\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f \u0628\u06cc \u0646\u0647\u0627\u06cc\u062a \u062a\u0639\u062c\u0628 \u0645\u06cc \u06a9\u0646\u06cc\u062f <br \/>\u062d\u0644\u0642\u0647 \u0647\u0627\u060c \u0645\u062a\u0623\u0633\u0641\u0627\u0646\u0647 \u0634\u0645\u0627 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0622\u0646\u0647\u0627 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.  \u0645\u0646 \u0633\u0639\u06cc \u06a9\u0631\u062f\u0645 \u062f\u06a9\u0645\u0647 \u0631\u0627 \u0628\u0647 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u062c\u062f\u06cc\u062f \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u0645\u060c \u0627\u0645\u0627 \u0628\u0647 \u0646\u0638\u0631 \u0645\u06cc \u0631\u0633\u062f ForAll \u0645\u062c\u0645\u0648\u0639\u0647 \u0631\u0627 \u062f\u0631 \u062d\u0627\u0641\u0638\u0647 \u067e\u0646\u0647\u0627\u0646 \u0646\u06af\u0647 \u0645\u06cc \u062f\u0627\u0631\u062f\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0647\u0631 \u062a\u063a\u06cc\u06cc\u0631\u06cc \u067e\u0633 \u0627\u0632 \u062a\u06a9\u0645\u06cc\u0644 \u0622\u0646 \u0627\u062a\u0641\u0627\u0642 \u0645\u06cc \u0627\u0641\u062a\u062f).<\/p>\n<p>buUpdateSelf<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>Patch(Objects,Defaults(Objects),{\n    a: Index(variables4,1).Set,\n    b:\"B\",\n    ID:Max(Objects,ID+1),\n    c:false\n    }\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<hr\/>\n<p><strong>\u062d\u0644\u0642\u0647 \u0628\u0627\u06cc\u062f \u0645\u0631\u0627\u062d\u0644 \u0648 \u0647\u0645\u06cc\u0634\u0647 \u0645\u0631\u062d\u0644\u0647 \u06cc\u06a9 \u0631\u0627 \u06a9\u0627\u0645\u0644 \u06a9\u0646\u062f<\/strong><br \/>\u0628\u0627 \u06a9\u0645\u06a9 \u06cc\u06a9 \u0627\u06af\u0631 \u063a\u0644\u0628\u0647 \u0628\u0631 \u0627\u06cc\u0646 \u0628\u0633\u06cc\u0627\u0631 \u0622\u0633\u0627\u0646 \u0627\u0633\u062a:<\/p>\n<p>\u062f\u0631 2 \u062a\u0648\u0642\u0641 \u06a9\u0646\u06cc\u062f<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(Objects,\n    {a:1,b:\"A\",c:true,ID:1},\n    {a:11,b:\"B\",c:false,ID:2},\n    {a:-11,b:\"C\",c:false,ID:3},\n    {a:7,b:\"D\",c:true,ID:4}\n);\n\nForAll( Objects, \n    If(ThisRecord.ID&lt;3,\n        Collect(variable,ThisRecord);\n    );\n);\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u06af\u0627\u0645 2<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ForAll( Objects, \n    If(Mod(ThisRecord.ID,2)=0,\n        Collect(variable,ThisRecord);\n    );\n);\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0622\u062e\u0631\u06cc\u0646 \u0646\u06a9\u062a\u0647 \u062c\u0627\u0644\u0628\u060c \u062a\u0627\u0628\u0639 Index() \u0627\u0633\u062a\u060c \u0632\u06cc\u0631\u0627 \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f \u0628\u0647 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u0631\u062c\u0627\u0639 \u062f\u0647\u06cc\u0645.  \u0632\u06cc\u0631 \u06cc\u06a9\u06cc \u0627\u0632 \u0642\u0628\u0644\u06cc\u060c \u06cc\u06a9\u06cc \u0627\u0632 \u0641\u0639\u0644\u06cc \u0648 \u06cc\u06a9\u06cc \u0627\u0632 \u0628\u0639\u062f\u06cc \u0631\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>ClearCollect(Objects,\n    {a:1,b:\"A\",c:true,ID:1},\n    {a:11,b:\"B\",c:false,ID:2},\n    {a:-11,b:\"C\",c:false,ID:3},\n    {a:7,b:\"D\",c:true,ID:4}\n);\nClearCollect(Objects2,\n    ForAll(Objects,\n        Switch(ID,\n        1,{a:a,b:b,c:Index(Objects,2).c,ID:ID},\n        Max(Objects,ID),{a:Index(Objects,ID-1).a,b:b,c:c,ID:ID},\n        {a: Index(Objects,ID-1).a,b:b,c:Index(Objects,ID+1).c,ID:ID}\n        )\n    )\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AA%D8%A7%DB%8C%D9%85%D8%B1%D9%87%D8%A7\"><\/span>\n<p>  \u062a\u0627\u06cc\u0645\u0631\u0647\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u0648\u0644\u06cc\u0646 \u062a\u0635\u0648\u0631 \u0627\u0632 \u06cc\u06a9 \u062a\u0627\u06cc\u0645\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u0639\u0645\u0644 \u062a\u0627\u062e\u06cc\u0631\u06cc \u0627\u0633\u062a.  \u0627\u0645\u0627 \u0686\u0648\u0646 \u06af\u0632\u06cc\u0646\u0647 \u062a\u06a9\u0631\u0627\u0631 \u0631\u0627 \u062f\u0627\u0631\u062f \u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0632 \u0622\u0646 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u062d\u0644\u0642\u0647 \u0646\u06cc\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f.  \u0686\u0647 \u0627\u0631\u0632\u0634\u06cc \u0646\u0633\u0628\u062a \u0628\u0647 ForAll \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u062f\u060c \u062e\u0648\u0628:<\/p>\n<ul>\n<li>\u0646\u0627\u0647\u0645\u06af\u0627\u0645 \u0627\u0633\u062a (\u0628\u062f\u0648\u0646 \u0645\u0633\u062f\u0648\u062f \u06a9\u0631\u062f\u0646\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u06a9\u0627\u0631\u0628\u0631 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u062f\u0627\u0645\u0647 \u062f\u0647\u062f)<\/li>\n<li>\u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0634\u0627\u0645\u0644 \u062a\u0627\u062e\u06cc\u0631 \u0628\u0627\u0634\u062f<\/li>\n<li>\u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0622\u0631\u0627\u06cc\u0647 \u0646\u062f\u0627\u0631\u062f<\/li>\n<li>\u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0647\u0631 \u0645\u0642\u062f\u0627\u0631 \u0642\u062f\u0645 \u0628\u0631\u062f\u0627\u0631\u06cc\u062f<\/li>\n<li>\u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062d\u0644\u0642\u0647 \u0631\u0627 \u0645\u062a\u0648\u0642\u0641 \u06cc\u0627 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u062c\u062f\u062f \u06a9\u0646\u06cc\u062f<\/li>\n<li>\u0647\u0631 \u062a\u0627\u0628\u0639\u06cc \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u062f\u0631 \u062d\u0644\u0642\u0647 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u06a9\u0631\u062f<\/li>\n<\/ul>\n<p>\u0648 \u062f\u0631 \u0645\u0648\u0631\u062f \u0645\u0648\u0627\u0631\u062f \u0645\u0646\u0641\u06cc \u0686\u0637\u0648\u0631:<\/p>\n<ul>\n<li>\u06a9\u0646\u062f\u06cc \u0622\u0646 (\u062d\u062f\u0627\u06a9\u062b\u0631 \u0633\u0631\u0639\u062a 1 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u0627\u0633\u062a)<\/li>\n<li>\u0628\u0627\u06cc\u062f \u06a9\u062f \u0628\u06cc\u0634\u062a\u0631\u06cc \u0628\u0646\u0648\u06cc\u0633\u06cc<\/li>\n<\/ul>\n<p>\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc \u0628\u06cc\u0646\u06cc\u062f\u060c \u062a\u0627 \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0633\u0631\u0639\u062a \u062d\u06cc\u0627\u062a\u06cc \u0646\u06cc\u0633\u062a\u060c \u06cc\u06a9 \u062a\u0627\u06cc\u0645\u0631 \u0628\u0647 \u0637\u0648\u0631 \u06a9\u0644\u06cc \u0628\u0647\u062a\u0631\u06cc\u0646 \u062d\u0644\u0642\u0647 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u06cc\u06a9 \u062a\u0627\u06cc\u0645\u0631 \u0628\u0647 \u06cc\u06a9 \u062d\u0644\u0642\u0647\u060c \u0628\u0627\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f (vbTimer \u0641\u0642\u0637 \u06cc\u06a9 \u0645\u062a\u063a\u06cc\u0631 \u0628\u0648\u0644\u06cc \u0627\u0633\u062a).<\/p>\n<p><code>Repeat<\/code>  \u062f\u0631\u0633\u062a \u0627\u0633\u062a\u060c \u0648\u0627\u0642\u0639\u06cc<br \/><code>Reset<\/code>  vbTimer<br \/><code>Start<\/code>  vbTimer<br \/><code>Duration<\/code>  1 (\u06cc\u0627 \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u062a\u0627\u062e\u06cc\u0631 \u0628\u06cc\u0634\u062a\u0631\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f)<br \/><code>OnTimerStart<\/code>  \u06cc\u0627 <code>OnTimerEnd<\/code> \u06a9\u062f \u0634\u0645\u0627<\/p>\n<p>\u06a9\u062f \u0632\u06cc\u0631 \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc \u0627\u0632 \u06cc\u06a9 ForLoop \u0633\u0627\u062f\u0647 \u0627\u0633\u062a <br \/>\u062f\u06a9\u0645\u0647 \u0634\u0631\u0648\u0639<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>Set(viCounter,0);\nSet(viLimit,100);\nSet(vbTimer,true);\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>OnTimerEnd<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>If(viCounter&lt;viLimit,\n    Notify(viCounter);\n    viCounter=viCounter+1;\n,\n    Set(vbTimer,false);\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0645\u0648\u0627\u0631\u062f \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 Patch &#038; Index \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>Set(viCounter,1);\nSet(viLimit,CountRows(Objects)+1);\nSet(vbTimer,true);\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>OnTimerEnd<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>If(viCounter&lt;viLimit,\n    viCounter=viCounter+1;\n    Patch(Objects,{ID:viCounter},\n        {a: Index(Objects,viCounter).a+viCounter}\n    )\n,\n    Set(vbTimer,false)\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u0648 \u0633\u067e\u0633 \u0634\u06a9\u0633\u062a\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>If(viCounter&gt;viLimit,Set(viCounter,1),Set(viCounter,viCounter+1));\nIf(Index(Objects,viCounter).b=\"D\",\n    Set(viFind,Index(Objects,viCounter).ID);\n    Set(vbTimer,false);\n)\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0622\u0646\u0686\u0647 \u0645\u0641\u06cc\u062f \u0627\u0633\u062a \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0631 \u062d\u0627\u0641\u0638\u0647 \u067e\u0646\u0647\u0627\u0646 \u0630\u062e\u06cc\u0631\u0647 \u0646\u0645\u06cc \u0634\u0648\u062f\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0645\u062c\u0645\u0648\u0639\u0647 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u062f \u0648 \u062f\u0631 \u062d\u0644\u0642\u0647 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.  \u062f\u0631 \u0645\u062b\u0627\u0644 \u0628\u0627\u0644\u0627\u060c \u062d\u0644\u0642\u0647 \u0647\u0631 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc \u06a9\u0646\u062f\u060c \u0627\u06af\u0631 \u0646\u062a\u0648\u0627\u0646\u062f \u0622\u0646 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u062f\u060c \u0633\u067e\u0633 \u062d\u0644\u0642\u0647 \u0645\u062c\u062f\u062f\u0627\u064b \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0647\u0631 \u0645\u0648\u0631\u062f \u0631\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u0627\u0645\u062a\u062d\u0627\u0646 \u0645\u06cc \u06a9\u0646\u062f.  \u0628\u0647 \u0645\u062d\u0636 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0645\u062c\u0645\u0648\u0639\u0647\u060c \u062e\u0648\u0627\u0646\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0627\u06af\u0631 \u0628\u0627 \u0634\u0631\u0627\u06cc\u0637 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0634\u062a\u060c \u062d\u0644\u0642\u0647 \u0645\u062a\u0648\u0642\u0641 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u06cc\u06a9 \u062d\u0644\u0642\u0647 \u0645\u0633\u062a\u0642\u06cc\u0645 DoWhile \u0628\u0627\u0634\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>If(Not(vbTimer),Set(viEndValue,viCounter));\nSet(viCounter,viCounter+1);\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<hr\/>\n<p>\u0627\u06af\u0631\u0686\u0647 \u062d\u0644\u0642\u0647\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u062f\u0631 PowerFX \u063a\u06cc\u0631\u0645\u0639\u0645\u0648\u0644 \u0628\u0627\u0634\u0646\u062f\u060c \u0627\u0645\u0627 \u0637\u06cc\u0641 \u06a9\u0627\u0645\u0644\u06cc \u0627\u0632 \u0639\u0645\u0644\u06a9\u0631\u062f \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f\u060c \u0641\u0642\u0637 \u06a9\u0645\u06cc \u062f\u0648\u0631 \u0627\u0632 \u0630\u0647\u0646 \u0627\u0633\u062a.<\/p>\n<hr\/>\n<p><strong>\u0628\u06cc\u0634\u062a\u0631 \u062e\u0648\u0627\u0646\u062f\u0646<\/strong><\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Power FX \u0632\u0628\u0627\u0646 LowCode \u067e\u0644\u062a\u0641\u0631\u0645 Power \u0627\u0633\u062a\u060c \u062f\u0631 \u0627\u0635\u0644 \u0641\u0642\u0637 \u062f\u0631 Canvas Apps \u0628\u0647 Dataverse \u0648 Power Virtual Agents \u06af\u0633\u062a\u0631\u0634 \u0646\u0645\u06cc \u06cc\u0627\u0628\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0627\u06cc\u0646\u06a9\u0647 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0639\u0628\u0627\u0631\u0627\u062a (\u0645\u0627\u0646\u0646\u062f Excel \u0648 Power Automate) \u0627\u0633\u062a\u060c \u0628\u0647 \u0637\u0648\u0631 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0628\u0627 \u0686\u06cc\u0632\u06cc \u0645\u0627\u0646\u0646\u062f VBA \u06cc\u0627 Python \u0642\u0627\u0628\u0644 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0646\u06cc\u0633\u062a. \u0645\u0627\u0646\u0646\u062f \u0627\u06a9\u0633\u0644\u060c Power FX \u062f\u0631 \u06cc\u06a9 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":18388,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-18387","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/18387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=18387"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/18387\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/18388"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=18387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=18387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=18387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}