I've read similar articles that have fixed similar solutions but none of those worked for this one, so forgive me if this is duplicative.
Here we go! 🙂
I have a manually triggered flow.
1st action 'list rows present in a table' ... this is an excel file
2nd action, which is a loop, 'Apply to each' with the value parameter from the first action/the excel
- 1st action in this loop is 'Get items' from a sharepoint list
- 2nd item in this loop is another loop 'Apply to each'
- The value parameter here is from the sharepoint list
- 1st action in this nested loop is a simple 'Condition' to compare a field from the excel and the sharepoint list.
- If Yes, 'Create item' in a sharepoint list........ this is where the problem is.
- If No, do nothing.
In the 'Create item' action above I am using an expression to call a date, or item, from the excel, the very first action, so that I can manipulate it and use it as a date that Sharepoint will accept. Here it is
converttoutc(addDays('1899/12/30', int(item()['Completion Date']), 'yyyy-MM-dd'), 'Pacific Standard Time')
The Completion Date property is from the excel... the error code tells me that the property is not available and that the available options are those from the Sharepoint list.
So, I just need to figure out how to call the Completion Date property in this expression so that it works.
Btw, all other properties from the excel are available as Dynamic items but as you may know, we need to use an expression to translate the date to a format that MS List will accept.
