cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DrishM13
Helper II
Helper II

Flow condition not working

Hi,

 

I have a flow that should send an email when column A in SharePoint is equal to 51 days. There are multiple documents that have different values for column A but I only want an email when it is equal to 51. So if yes, email sent.

 

As below:

 

DrishM13_0-1621320573890.png

 

It seems though that I am getting an email for all documents though and not just the one that has 51 in Column A.

 

Not sure why?

 

Thanks.

 

8 REPLIES 8
Achavan
Resolver II
Resolver II

hi @DrishM13 ,

just type 51 in equal to 

Achavan_0-1621321133786.png

If this helps you, please mark as solution.

DrishM13
Helper II
Helper II

Hi @Achavan , if I do that, I get the following error:

 

Which makes no sense as the expression should be true as there is an item on SharePoint that has 51 in Column A

DrishM13_0-1621324999343.png

 

did you try with int(51) ?

DrishM13
Helper II
Helper II

Hi @Achavan , still same error.

 

I am attaching my flow itself - not sure if a previous step is in the wrong?

 

DrishM13_0-1621328686094.png

 

 

DrishM13_1-1621328707120.png

 

can you please run your flow and show output of get files (properties) step ?

also try below expression 

 

Achavan_1-1621329028094.png

 

Still error with that expression

can you please run your flow and show output of get files (properties) step ?

DrishM13
Helper II
Helper II

{"statusCode":200,"headers":{"Transfer-Encoding":"chunked","Vary":"Origin,Accept-Encoding","X-SharePointHealthScore":"3","X-MS-SPConnector":"1","X-SP-SERVERSTATE":"ReadOnly=0","DATASERVICEVERSION":"3.0","SPClientServiceRequestDuration":"58","SPRequestGuid":"95d68c4d-1997-4cba-abeb-cb1f4bf0be97","request-id":"95d68c4d-1997-4cba-abeb-cb1f4bf0be97","MS-CV":"TYzWlZcZukyr68sfS/C+lw.0","Strict-Transport-Security":"max-age=31536000","X-FRAME-OPTIONS":"SAMEORIGIN","Content-Security-Policy":"frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com;","MicrosoftSharePointTeamServices":"16.0.0.21305","X-Content-Type-Options":"nosniff","X-MS-InvokeApp":"1; RequireReadOnly","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","Cache-Control":"max-age=0, private","Date":"Tue, 18 May 2021 10:30:39 GMT","P3P":"CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"","X-AspNet-Version":"4.0.30319","X-Powered-By":"ASP.NET","Content-Type":"application/json; charset=utf-8","Expires":"Mon, 03 May 2021 10:30:39 GMT","Last-Modified":"Tue, 18 May 2021 10:30:39 GMT","Content-Length":"12166"},"body":{"value":[{"@odata.etag":"\"1599\"","ItemInternalId":"1","ID":1,"ContractReferenceNumber":"AAA123","NameofCompanyEntityorEntities":"Entity 1","NameofOtherEntities":"Entity 2","DescriptionofContracts":"Test Purposes","ContractExpiryDate":"2021-07-08","Days_x0020_Until_x0020_Expiry":"51.0000000000000","Editor":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|email","DisplayName":"Name","Email":"Email","Picture":"site name/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Email","Department":"Technology","JobTitle":"Digital Systems Administrator"},"Editor#Claims":"i:0#.f|membership|email","TodaysDate":"2021-05-18","Created":"2021-05-17T07:25:15Z","Author":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|email","DisplayName":"Name","Email":"Email","Picture":"site name/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Email","Department":"Technology","JobTitle":"Digital Systems Administrator"},"Author#Claims":"i:0#.f|membership|email","Modified":"2021-05-18T10:30:02Z","OData__DisplayName":"","{Identifier}":"Contracts%252fTest.docx","{IsFolder}":false,"{Thumbnail}":{"Large":"https://northeurope1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=docx&cs=fFNQTw&docid... name/Contracts/Test.docx?d=wa219edd413814d30b8771029a5346ec6","{Name}":"Test","{FilenameWithExtension}":"Test.docx","{Path}":"Contracts/","{FullPath}":"Contracts/Test.docx","{IsCheckedOut}":false,"{VersionNumber}":"1599.0"},{"@odata.etag":"\"1594\"","ItemInternalId":"2","ID":2,"ContractReferenceNumber":"BBB5656","NameofCompanyEntityorEntities":"Entity 2","NameofOtherEntities":"Entity 3","DescriptionofContracts":"Test","ContractExpiryDate":"2021-05-25","Days_x0020_Until_x0020_Expiry":"7.00000000000000","Editor":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|email","DisplayName":"Name","Email":"Email","Picture":"site name/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Email","Department":"Technology","JobTitle":"Digital Systems Administrator"},"Editor#Claims":"i:0#.f|membership|email","TodaysDate":"2021-05-18","Created":"2021-05-17T07:54:03Z","Author":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|email","DisplayName":"Name","Email":"Email","Picture":"site name/_layouts/15/UserPhoto.aspx?Size=L&AccountName=Email","Department":"Technology","JobTitle":"Digital Systems Administrator"},"Author#Claims":"i:0#.f|membership|email","Modified":"2021-05-18T10:30:03Z","OData__DisplayName":"","{Identifier}":"Contracts%252fTest%2b-%2bCopy.docx","{IsFolder}":false,"{Thumbnail}":{"Large":"https://northeurope1-mediap.svc.ms/transform/thumbnail?provider=spo&inputFormat=docx&cs=fFNQTw&docid... name/Contracts/Test%20-%20Copy.docx?d=w6494a18ecf514561abb11525e1f6a856","{Name}":"Test - Copy","{FilenameWithExtension}":"Test - Copy.docx","{Path}":"Contracts/","{FullPath}":"Contracts/Test - Copy.docx","{IsCheckedOut}":false,"{VersionNumber}":"1594.0"}]}}

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (5,298)