Power Apps Community Power Automate Community Power Virtual Agents Community Power Pages Community 20-22nd - Dublin Microsoft Power Platform Conference – Oct. Power Apps Developers Summit – May 19-20th - London European Power Platform conference – Jun. Video series available at Power Platform Community YouTube channel. This episode premiered live on our YouTube at 12pm PST on Thursday 11th May 2023. Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show.Ĭheck out the blogs and articles featured in this week’s with David Warner:Īction requested: Feel free to provide feedback on how we can make our community more inclusive and diverse. More over I do not understand, how a column like ResourceProvisioningOptions, could contain an array in its cells ?ĭo you have any website or learning ressource to advise me ?Įpisode Thirteen of Power Platform Connections sees Hugo Bernier take a deep dive into the mind of co-host David Warner, alongside the latest news, videos, product reviews, and community blogs.

When I speak about the json scheme I mean, the following :Īnd if we add the data you have given ( Initialize Variable), will it fill the table with the following var Jack I am not really used to the json format, indeed I do not understand what will give the j son scheme you mentioned to format the empty array in the first step. I would like to apply the workflow that you have showed us, to my case (convert a json from 123 survey to an excel file), and I want to learn too. I think it will help me a lot, thanks : ) function main(workbook: ExcelScript.I really appreciate your accurate response. For more information about working with JSON, read Use JSON to pass data to and from Office Scripts. Note that for column names with spaces, be sure to place your key in quotation marks, such as with 'Event ID' in the sample. You can change the interface TableData structure to match your table columns.

Convert json to xlsx