Best practice to move attachment from flow to data source

[RK41]

Hi Everyone, Good day.

I wanted to know what is the best practice to move attachment from flow to data source. Currently I am going to use the OneDrive integration hub action in flow designer to get excel sheet from OneDrive. And I have to move this to data source, then have to start the transform map. This flow have to execute weekly once. So my questions are below.

1. How and which action I have to use to get the attachment from OneDrive using OneDrive integration hub?

2. How to move the attachment from Flow to Data source?

3. How to auto start the transform map once data source is attached with new attachment?

Thanks,

[Ankur Bawiskar]

@RK41 

why to switch to Data source? any limitations for flow currently?

[RK41]

Hi Ankur,

Currently my customer have the customized transform map to process the excel sheet and it have lot of transform map scripts. so we don't wanna do additional work on the flow designer for transformation. That's why I am trying to move the attachment to data source.

Thanks,

RK

[Maik Skoddow · Accepted solution]

Hi @RK41 

I don't know how files from OneDrive are incoming in ServiceNow but for rest you could follow what I have described in my article: Import Excel File from Inbound Email via Flow

Maik

[RK41]

Hi Maik,

Thanks for your reply and the article which you shared was really helpful.

I can see you have changed the run time using script to execute the scheduled data import, because you don't have the "Once" option in previous Snow version in "Run" drop down choice.

But my instance have the "Once" option. So now what's the best practice to execute the scheduled data import? I really don't want to hardcode the runtime using script. So any idea to execute this ?

Thanks,

RK