Swapnil Shah

1. Community
2. Troubleshoot custom flows
3. How to clear the values (for a specific range, for example A2:M100) and also add the values (for a specific range, for example A2:M100) in a Microsoft excel online file stored in SharePoint site using the MicroSoft Graph API?

Has anyone experience working on an integration with Microsoft Excel Online?

• View comment
• 0 votes

1. Community
2. Troubleshoot custom flows
3. How to clear records from a Google Sheet and then Post new records on the same sheet?

Hi Bhavik, Thank you for the article. I was able to fix the issue when I changed it from RAW to USER_ENTERED. 

• View comment
• 0 votes

1. Community
2. Troubleshoot custom flows
3. How to clear records from a Google Sheet and then Post new records on the same sheet?

Hi Anitha/Community Members, When the data gets posted on the google sheets, how do I ensure the datatype (format) doesn't change for the attribute. Like in my use case, I am passing Customer Categ...

• View comment
• 0 votes

1. Community
2. Troubleshoot custom flows
3. In Import Mapping while creating Journal Entries, for one one of the fields I need to use the case or If-else statement. How do I use the if-else statement using handlebars?

Hi Godishela Sachin Goud , The Hook is working for me and I am successfully able to post the records and create Journal Entries. Thank you so much for investing your valuable time and providing me ...

• View comment
• 1 vote

1. Community
2. Troubleshoot custom flows
3. How to clear records from a Google Sheet and then Post new records on the same sheet?

Hi Anitha, The issue got resolved. I had to set the page size to 1 in the export side from NetSuite as Google Sheets API doesn't allow concurrent requests I guess.  Also I used this article -> HOW ...

• View comment
• 0 votes

1. Community
2. Troubleshoot custom flows
3. In Import Mapping while creating Journal Entries, for one one of the fields I need to use the case or If-else statement. How do I use the if-else statement using handlebars?

Hi  It seems like the handlebar which you suggested will solve my issue. So I replaced the value with Lines[*].Net_Amount and then tried this handlebar: {{divide (subtract (abs Lines[*].Net_Amount)...

• View comment
• 0 votes

1. Community
2. Troubleshoot custom flows
3. In Import Mapping while creating Journal Entries, for one one of the fields I need to use the case or If-else statement. How do I use the if-else statement using handlebars?

Hi Stephen, Without the curly braces, its giving me NULL value for Line:Debit The handlebars expression I am using for Line:Debit seems to be working for me but the one for Line:Credit is not worki...

• View comment
• 0 votes

1. Community
2. Troubleshoot custom flows
3. How to clear records from a Google Sheet and then Post new records on the same sheet?

Hi Community Members, Can anyone assist me with this issue?

• View comment
• 0 votes