Hi all,
I don't have much experience with JSON, but I'm trying to decipher and use a date value from the "Shared with details" column in a SharePoint library in a Flow. The column data ends up looking like this:
{"i:0#.f|membership|firstname.lastname@domain.org":{"DateTime":"/Date(1557740213028)/","LoginName":"person.who.shared@domain.org"}}
And I've managed to extract the date in a compose action, but now I guess I need to use JSON to translate this to a usable date value. A user said I could use this formula:
var d = new Date(); d.setTime(1557740213028);
but I have no idea how to plop that into a Parse JSON action. Help?
Is your example a valid JSON format? If so you can use "Pasrse JSON" action block currently supported in Microsoft Flow
Here you will find an excellent tutorial via @sergeluca
https://sergeluca.wordpress.com/2017/11/23/using-json-in-microsoft-flow-part-1/
Hope this helps
Proud to be a Flownaut!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
User | Count |
---|---|
32 | |
32 | |
24 | |
24 | |
20 |
User | Count |
---|---|
60 | |
57 | |
43 | |
37 | |
28 |