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.

Users online (2,655)