Forum Discussion
Hi @ash42,
Do you want the output to be only one object?
If yes, then try with the following expression in a Mapper Snap:
$Names.reduce((acc,curr,ind) => acc.extend({[curr]: $Values[ind]}), {})
The output will look like this:
[
{
"key1": "Value1",
"key2": "Value2",
"key3": "Value3"
}
]
Let me know if this is the desired output.
BR,
Aleksandar.
- SpiroTaleski3 years agoValued Contributor
I guess you should add the absolute path of the directory where the file needs to be created(in the Target path field).
BR,
Spiro TaleskiThank you @Spiro_Taleski. Conceptually, I understand that, however, I am struggling with the syntax. Any insight you can offer on the below?
This works (but only in top level of doc library):
‘Mx_Manual_Ltrs_’ + Date.now().toLocaleDateTimeString({ timeZone: “EST”, format: “yyyy-MM-dd” }) + ‘.xlsx’This is what I tried for the absolute path to put the file in a subdirectory of the same library.
This does not work.
‘https://mln.sharepoint.com/:f:/r/sites/MxLettersTeamPeerReview/Shared%20Documents/Reports’+'Mx_Manual_Ltrs_’ + Date.now().toLocaleDateTimeString({ timeZone: “EST”, format: “yyyy-MM-dd” }) + ‘.xlsx’The error I get is:
Either source/target drive (%s) is not found in the tenant
Resolution:
verify if the drive name exists in the tenant.
Reason:
The drive name you have entered might not be available in the tenant.
- SpiroTaleski3 years agoValued Contributor
Did you try to disable the expression button for “Target path”?
If disabled, it should suggest the document library/libraries within the RxLettersTeamPeerReview Site.
Then from there, probably you can see/construct the exact path.
BR,
Spiro Taleski @Spiro_Taleski Thank you. Ironically, I just got help from a co worker who showed me the syntax. Basically, I did not need to put the entire path of the site. The correct syntax ended up being:
“/Reports/”+‘Mx_Manual_Ltrs_’ + Date.now().toLocaleDateTimeString({ timeZone: “EST”, format: “yyyy-MM-dd” }) + ‘.xlsx’
Where “Reports” is the sub dir (under the Doc Library “Documents”) that I put the file.
Thank you again, so much, for being willing to help.