Custom Action là gì và cách tạo Custom Action trong Power Automate Desktop – Phần 1

Trong ví dụ này, tôi sẽ tạo một Custom Action để add a column vào một data table đã tồn tại.

Đây là code mẫu:

using Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK;

using Microsoft.PowerPlatform.PowerAutomate.Desktop.Actions.SDK.Attributes;

using System;

using System.Data;

namespace Modules.DataTable

{

    [Action(Id = “AddColumnToDataTable”, FriendlyName = “Add column”, Order = 10, Description = “Add new column to data table”)]

    [Throws(“ColumnExisted”, FriendlyName = “Column Existed”)] // TODO: change error name (or delete if not needed)

    public class AddColumn : ActionBase

    {

        #region Properties

        [InputArgument(Description = “Data table for add new column”, FriendlyName = “Data table”, Order = 1)]

        public System.Data.DataTable dtDataTable { get; set; }

        [InputArgument(Description = “New column to add into data table”, FriendlyName = “New column name”, Order = 2)]

        public string strNewColumnName { get; set; }

        [InputArgument(Description = “Default value to add into new column”, FriendlyName = “Default value”, Order = 3, Required = false)]

        public string strDefaultValue { get; set; }

        [OutputArgument(Order = 1, Description = “New Data table with new column added”)]

        public System.Data.DataTable dtNewDataTable { get; set; }

        #endregion

        #region Methods Overrides

        public override void Execute(ActionContext context)

        {

            try

            {

                //Add new column into Data table with strNewColumnName

                dtDataTable.Columns.Add(strNewColumnName);

                dtNewDataTable = dtDataTable.Copy();

                //If strDefaultValue is not null, set default value for new column

                if (!string.IsNullOrEmpty(strDefaultValue))

                {

                    foreach (DataRow row in dtNewDataTable.Rows)

                    {

                        row[strNewColumnName] = strDefaultValue;

                    }

                }

            }

            catch (Exception e)

            {

                if (e is ActionException) throw;

                throw new ActionException(“ColumnExisted”, e.Message, e.InnerException);

            }

            // TODO: set values to Output Arguments here

        }

        #endregion

    }

}