I have tried so many variation and reviewed many many similar issues, but can not seem to get this to work. I have tried if(equals) expressions with no luck (template errors). Please help I have been working on this too long. It is the only issue I have had since working in power automate love the tool. So I am looking to take and action based on a form response. I began by using an item in a list, but moved to creating a yes/no to try to simplify the issue. Below is the flow. I am creating item in a list in SharePoint and when ever YES is selected from question "Is this Reg MFP, " it should trigger an approval, whenever no email with options. I have also tried to change the yes to 'yes' based on other memo on basic versus dynamic.
I have blown this a part and started over many times. I also have the process of updating the SharePoint when item is created or modified working to adjust approval status fine. This is the only item that I can not figure out. Let me know what other info you may need. I have tried this as a stand alone condition of yes, and, or and any other options as well as contains etc. with no success. Thanks.
"@odata.etag": "\"1\"",
"ItemInternalId": "74",
"ID": 74,
"Title": "Agency 101",
"SubmissionDate": "2022-05-23",
"IsthisRegMFP_x003f_": "Yes",
"Program": "Regular MFP Non-Grant Related",
"Rescheduleneeded_x003f_": false,
"ApprovalStatus": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 0,
"Value": "Pending Approval"
},
"ApprovalStatus#Id": 0,
"Isthisanewagency_x003f_": "No",
"DestinationAddress": "here st",
"IsthisaHHFBEvent_x003f_": "No",
"Existingagencyaddress": "Family Health Center - 3548 Marie St. Orangeburg",
"Numberofboxes": "2000",
"DeliveryMethod": "Delivery",
"OData__x0031_stChoiceDeliveryDate": "2022-06-01",
"OData__x0031_stChoiceTime": "10 am to 10:30 am",
"OData__x0032_ndChoiceDeliveryDate": "2022-05-19",
"OData__x0032_ndChoiceTime": "11 am to 11:30",
"ImpactedWarehouse": "Midlands Warehouse",
"County": "[\"Chester\"]",
"Modified": "2022-05-23T12:13:11Z",
"Created": "2022-05-23T12:13:11Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|mwise@harvesthope.org",
"DisplayName": "Misty Wise",
"Email": "MWISE@harvesthope.org",
"Department": null,
"JobTitle": null
},
"Author#Claims": "i:0#.f|membership|mwise@harvesthope.org",
"Editor": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|mwise@harvesthope.org",
"DisplayName": "Misty Wise",
"Email": "MWISE@harvesthope.org",
"Department": null,
"JobTitle": null
},
"Editor#Claims": "i:0#.f|membership|mwise@harvesthope.org",
"TaxKeyword": [],
"TaxKeyword@odata.type": "#Collection(Microsoft.Azure.Connectors.SharePoint.SPListExpandedTaxonomy)",
"TaxKeyword#WssId": [],
"TaxKeyword#WssId@odata.type": "#Collection(Int64)",
"{Identifier}": "Lists%252fMFP%2bDistribution%2bList%252f74_.000",
"{IsFolder}": false,
"{Thumbnail}": {
"Large": null,
"Medium": null,
"Small": null
},
"{Name}": "Agency 101",
"{FilenameWithExtension}": "Agency 101",
"{Path}": "Lists/MFP Distribution List/",
"{FullPath}": "Lists/MFP Distribution List/74_.000",
"{ContentType}": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
"Id": "0x0100233072613DA1794FB16F6EE7F3E6705700C31CAF4349531740BA7A1554DB0A3C11",
"Name": "Item"
},
"{ContentType}#Id": "0x0100233072613DA1794FB16F6EE7F3E6705700C31CAF4349531740BA7A1554DB0A3C11",
"{HasAttachments}": false,
"{VersionNumber}": "1.0"