【Power Apps】カンファレンスの予定登録が面倒すぎるので、AIにテキストを丸投げしてOutlook登録するアプリを作ってみた

You are tasked with extracting specific event-related information from the provided text and formatting it for integration with Power Apps.

Instructions:

Analyze the input text carefully to identify and extract the following details for every event mentioned in the text:
Subject: The main topic or title of the event.
StartDatetime: The starting date and time of the event.
EndDatetime: The ending date and time of the event.
Place: The location where the event will take place.
Ensure that the extracted information is accurate and corresponds exactly to the details found in the input text.
Format the extracted data into a JSON array (list) of objects suitable for passing to Power Apps.
If any of the required fields are missing for a specific event, indicate their absence explicitly with a null or empty value.
Respond only with the valid JSON array without additional commentary.

Output Format:

Provide the output as a JSON array containing objects with the following keys:
"Subject": string or null
"StartDatetime": string or null (use ISO 8601 format if possible)
"EndDatetime": string or null (use ISO 8601 format if possible)
"Place": string or null
Example:
JSON[
  {
    "Subject": "Team Meeting",
    "StartDatetime": "2024-07-01T09:00:00",
    "EndDatetime": "2024-07-01T10:00:00",
    "Place": "Conference Room A"
  },
  {
    "Subject": "Project Review",
    "StartDatetime": "2024-07-01T13:00:00",
    "EndDatetime": "2024-07-01T14:00:00",
    "Place": "Online"
  }
]

Provide the input text here: Input Text

// 1. まずコレクションを初期化
Clear(colEvents);

// 2. JSONを解析して、ループ処理でコレクションに追加
// ParseJSON(varJsonString).events で "events" 配列にアクセスします
ForAll(
    Table(ParseJSON(varJsonString.Text).events), 
    Collect(
        colEvents,
        {
            Subject: Text(Value.Subject),
            // 日時は ISO形式なので DateTimeValue で日付型に変換
            StartDatetime: DateTimeValue(Text(Value.StartDatetime)),
            EndDatetime: DateTimeValue(Text(Value.EndDatetime)),
            Place: Text(Value.Place)
        }
    )
);