web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Having trouble buildin...

Power Automate

Unanswered

Having trouble building an odata query using addDays from a sharepoint column

(0) Share

Report

Report

Posted on by hss0827

Hi All

New to this forum and new to Power Automate. I am trying to build an OData query using data stored in SharePoint list. The expression looks like this-

addDays(utcNow(),int('EmailAlertDays'),'yyyy-MM-dd')

Here EmailAlertdays is a number field from a SharePoint list. Expression builder is telling me that this expression is invalid.

Any ideas?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Ramspevi 110 on at

Like (0)

Report
Copy link

Link copied!
Hello

please consider this as solution if your EmailAlertDays is already a number field.

addDays(utcNow(),outputs('Get_item')?['body/EmailAlertDays'],'yyyy-MM-dd')
If it is text but you are 100% sure there are only numbers coming in consider this as solution:
addDays(utcNow(),int(outputs('Get_item')?['body/EmailAlertDays']),'yyyy-MM-dd')

In your example you are trying to format the string of text 'EmailAlertDays' to an integer which is impossible.

Hope this helps

Was this reply helpful? Yes No
v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @hss0827

Has your problem been solved?

Do you want to filter out items that meet certain condition from sharepoint list? Could you please share a bit more about your scenario?

I set up a simple flow, you can refer to below screenshots to see if it helps.

This is my test list, I will filter out items that Date is less or equal to current UTC time plus 'EmailAlertDays‘ days.

Expression:

addDays(utcNow(),int(item()?['EmailAlertDays']),'yyyy-MM-dd')

If you problem has been solved by Ramspevi , please accept Ramspevi's answer as Solution.

Best Regards.

Was this reply helpful? Yes No

Join the conversation