Help to fix a Powerautomate error on expressions

Occasional Contributor

Hi,

 

Does anyone know how to fix this error. I keep getting it but I do not know how to fix it. The intend is to run a recurrence check on dateline set on sharepoint list and send out reminder 7 days before the mentioned date. 

Bessie1335_4-1673504960362.png

 

 

Bessie1335_1-1673504849552.png

Bessie1335_2-1673504892436.png

 

 

3 Replies

@Bessie1335 I think you are using incorrect name of your column in filter query. You have to use the internal name of column in filter query and not the display name.

 

Use this link to find the correct internal name: Find the internal name of SharePoint column 

 

Then use filter query in format: 

 

Created ge datetime'2018-10-05T00:00:00Z' and Created le datetime'2018-10-05T23:59:59Z'

Check this thread for more information about filter query on date fields: Filter Created in SP REST API 

 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@ganeshsanap How do i find the internal name of the column? my sharepoint list look like this , and the circle in Red is where i need the flow to refer to.

 

Bessie1335_0-1673507080855.png

 

@Bessie1335 From the list view, click on Settings (gear) icon at the top right corner and select List settings

Once you are redirected to List settings page, follow this blog to find the internal name of your date column: Find the internal name of SharePoint column 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.