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.
Read the latest about new experiences and capabilities in the Power Automate product blog.
User | Count |
---|---|
25 | |
25 | |
25 | |
21 | |
15 |
User | Count |
---|---|
53 | |
45 | |
35 | |
32 | |
30 |