Hello,
I have a SharePoint list with functionality built using PowerApps.
The user accesses the site (SP Team site) and adds a new item to the list. Within the form is a hidden field Submission_Indicator that is set to '1'. I have created a Power Automate flow "When an item is created or modified".
Step 1 - Condition: Submission Indicator = '1' and SharePoint Status = 'Submit to RR'
If True - Send email and Update Submission_Indicator to 2
Step 2:
Condition: Submission Indicator = 2 and SharePoint Status =Submit to BCT
If True - Send email and Update Submission_Indicator to 3
And on it goes for 4 steps. Each time I have added in Dynamic Content I've made sure I am taking it from 'When an Item is created or modified', not the Update item field.
In the SharePoint list the Submission_Indicator field is set up as a single line of text defaulting to '1'. When adding in the condition, I made sure to include the inverted commas.
When I test the flow and create a new item in SharePoint, making sure I fulfil the conditions of Submission_Indicator = 1 and SharePoint Status = Submit to RR, the flow runs without error, however it is saying the result of the triggers is false.
Below is the code from the test, I've no idea if it helps:
[
{
"@odata.etag": "\"1\"",
"ItemInternalId": "71",
"ID": 71,
"Submission_Indicator": "1",
"Is_x0020_this_x0020_a_x0020_new_": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "New"
},
"Is_x0020_this_x0020_a_x0020_new_#Id": 1,
"Event_x0020_Start_x0020_Date": "2023-11-22",
"Date_x0020_of_x0020_Discovery": "2023-11-22",
"Has_x0020_this_x0020_event_x0020": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 2,
"Value": "Yes"
},
"Has_x0020_this_x0020_event_x0020#Id": 2,
"Business_x0020_Area_x0020__x0028": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "xxx"
},
"Business_x0020_Area_x0020__x0028#Id": 1,
"Specific_x0020_Business_x0020_Un": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 2,
"Value": "xxx"
},
"Specific_x0020_Business_x0020_Un#Id": 2,
"Event_x0020_Name": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 265,
"Value": "xxx"
},
"Event_x0020_Name#Id": 265,
"Event_x0020_Sub_x0020_Category": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 3,
"Value": "xxx"
},
"Event_x0020_Sub_x0020_Category#Id": 3,
"Specify_x0020_medium_x0020_throu": [],
"Specify_x0020_medium_x0020_throu@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"Specify_x0020_medium_x0020_throu#Id": [],
"Specify_x0020_medium_x0020_throu#Id@odata.type": "#Collection(Int64)",
"Please_x0020_confirm_x002c__x002": [],
"Please_x0020_confirm_x002c__x002@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"Please_x0020_confirm_x002c__x002#Id": [],
"Please_x0020_confirm_x002c__x002#Id@odata.type": "#Collection(Int64)",
"Regulatory_x0020_Legal_x0020_Pol": [],
"Regulatory_x0020_Legal_x0020_Pol@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference)",
"Regulatory_x0020_Legal_x0020_Pol#Id": [],
"Regulatory_x0020_Legal_x0020_Pol#Id@odata.type": "#Collection(Int64)",
"Sharepoint_x0020_Status": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "Submit to RR"
},
"Sharepoint_x0020_Status#Id": 0,
"Modified": "2023-11-22T11:12:34Z",
"Created": "2023-11-22T11:12:34Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": "",
"JobTitle": ""
},
"Author#Claims": "",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "",
"DisplayName": "",
"Email": "",
"Picture": "",
"Department": "",
"JobTitle": ""
},
"Editor#Claims": "",
"{Identifier}": "Lists%252fEvents1%252f71_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Link}": "https://",
"{Name}": "",
"{FilenameWithExtension}": "",
"{Path}": "Lists/Events1/",
"{FullPath}": "Lists/Events1/71_.000",
"{HasAttachments}": false,
"{VersionNumber}": "1.0",
"{TriggerWindowStartToken}": "MTszOzY5ZTk3MWIxLTQxNTgtNDc1OS04Zjk5LTMwOTNhODFmYTM3NTs2MzgzNjI0ODEwNzM0NzAwMDA7MjI4MTc5Njg=",
"{TriggerWindowEndToken}": "MTszOzY5ZTk3MWIxLTQxNTgtNDc1OS04Zjk5LTMwOTNhODFmYTM3NTs2MzgzNjI0ODM4OTY5MzAwMDA7MjI4MTg4MDI="
}
]
Can anyone help me please? I am at a complete loss! Thank you
