Hi, Thank you very much for the video, very useful. I would ask you a solution. My template file has colums in format "number", but when the flow export the data are in "text format". How can i solve the matter and put correctly the format data?
If you need anything specific, I'll do my best to provide a solution.
2 ปีที่แล้ว
Hello I would like to change the SharePoint Columns of infinite unknown documents which are identified in Excel by their File Name with Extension. I tried this workflow but in the Action Get a Row Key Value I added the dynamic option "File name with extension", and the difference is that in the action Update file properties "Processed" does not appear in my options to complete, so I get a Flow checker warning telling me infinite loop in this action
Excellent video! I got it all to work - all but one other part that I am not sure how to figure out. My Excel template has a column for dates. It is not pulling the date data correctly into the SharePoint column. Any solutions? Thank you!
Yeah SharePoint does not work with dates in the same way as Excel - which is number of days since Jan 1st 1900 (or 1904 in a Mac). So you have to convert the date to a ISO 8601 format which is YYYY-MM-DDThh:mm:ss. Use the Year Month Day Hour and MINUTE functions. store them into separate variables and then use Compose to CONCATenate them into a string.
I went through the process of setting up the Excel sheet and table, created the flow and it shows as running successfully but the data does not populate in the SharePoint column, any help is appreciated.
Why does the first Action have to be “Properties only”? I want the trigger to happen when a file’s contents are modified, not its properties. Also, why does this Flow trigger every time I open the Document Library? It’s Locking files that I’m not even opening.
another excellent demo that is extremely practical!
Excellent Demo. Never even thought of using Data tables like this.
Hi, Thank you very much for the video, very useful. I would ask you a solution. My template file has colums in format "number", but when the flow export the data are in "text format". How can i solve the matter and put correctly the format data?
Where are the other videos for preventing locking? and endless loop? Very informative. Thanks!
If you need anything specific, I'll do my best to provide a solution.
Hello I would like to change the SharePoint Columns of infinite unknown documents which are identified in Excel by their File Name with Extension. I tried this workflow but in the Action Get a Row Key Value I added the dynamic option "File name with extension", and the difference is that in the action Update file properties "Processed" does not appear in my options to complete, so I get a Flow checker warning telling me infinite loop in this action
Excellent video! I got it all to work - all but one other part that I am not sure how to figure out.
My Excel template has a column for dates. It is not pulling the date data correctly into the SharePoint column. Any solutions?
Thank you!
Yeah SharePoint does not work with dates in the same way as Excel - which is number of days since Jan 1st 1900 (or 1904 in a Mac). So you have to convert the date to a ISO 8601 format which is YYYY-MM-DDThh:mm:ss. Use the Year Month Day Hour and MINUTE functions. store them into separate variables and then use Compose to CONCATenate them into a string.
I went through the process of setting up the Excel sheet and table, created the flow and it shows as running successfully but the data does not populate in the SharePoint column, any help is appreciated.
Thanks
Fantastic
Thank you so much 😀
Why does the first Action have to be “Properties only”? I want the trigger to happen when a file’s contents are modified, not its properties. Also, why does this Flow trigger every time I open the Document Library? It’s Locking files that I’m not even opening.
nice