Answered

Date Formatting Issue - Using value from existing SharePoint list via galName.Selected.'Start Date' and Updating to new SharePoint list

(0) Share

Report

Posted on by AlexRay

1. Using an edit form to update an item in SharePoint list, when the status is changed to complete the PowerApp triggers a Power Automate flow to go ahead and create an item in a new SharePoint list and delete the record from the current SharePoint list. I'm taking the value Start Date from the existing SharePoint list using galName.Selected.'Start Date', I'm then in Power Automate cloud flow attempting to use this value when creating the item in the new SharePoint list but it does not want to accept the date format no matter what I try.

2. Error Message: PowerApps-CloseOutTasks.Run failed: { "error": { "code": "TriggerInputSchemaMismatch", "message": "The input body for the trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'String 07/06/2023' does not validate against format 'date'.'.'}}

3. Problem can be reduced on demand by attempting to submit form with completed status

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AlexRay ,

Please format the date string into ISO8601 format, and then pass this value to flow.

Text(DateValue("07/06/2023"),DateTimeFormat.UTC)

Best Regards,

Bof
AlexRay 23 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft just tried, still getting the below error
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AlexRay ,

Could you please show me your flow and the formula in your app?

Best Regards,

Bof
AlexRay 23 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft
Formula on clicking button to submit form and kick off move task:

SubmitForm(edfrmTaskInput);
If(DataCardValue23.Selected.Value = "Completed",
'PowerApps-CloseOutTasks'.Run(
galTaskList.Selected.Title,
galTaskList.Selected.'Item Detail',
galTaskList.Selected.Priority.Value,
galTaskList.Selected.Owner.Value,
galTaskList.Selected.Status.Value,
Text(DateValue(galTaskList.Selected.'Start Date'),DateTimeFormat.UTC),
galTaskList.Selected.Comments,
galTaskList.Selected.ID);
Navigate(scMasterSelection);
);

Code for create item in power automate flow (only item before this is current time to generate the current date for a different field that isn't causing an issue):
{
    "inputs": {
        "host": {
            "connectionName": "shared_sharepointonline",
            "operationId": "PostItem",
            "apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
        },
        "parameters": {
            "dataset": "<SharePoint URL>",
            "table": "<Table ID>",
            "item/Title": "@triggerBody()['Createitem_Title']",
            "item/ItemDetail": "@triggerBody()['Createitem_ItemDetail']",
            "item/Priority/Value": "@triggerBody()['Createitem_PriorityValue']",
            "item/Owner/Value": "@triggerBody()['Createitem_OwnerValue']",
            "item/Status/Value": "@triggerBody()['Createitem_StatusValue']",
            "item/StartDate": "@convertToUtc(triggerBody()['Createitem_StartDate'])",
            "item/DueDate": "@body('Current_time')",
            "item/Comments": "@triggerBody()['Createitem_Comments']"
        },
        "authentication": {
            "type": "Raw",
            "value": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"
        }
    },
    "metadata": {
        "operationMetadataId": "<ID>"
    }
}
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @AlexRay ,

Please replace the 'PowerAPPs' Trigger with 'PowerAPPs(V2)', and custom date input (select text type).

Best Regards,

Bof
AlexRay 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Bof, much appreciated!