Create a document location record using Flow/DataVerse

(0) Share

Report

Posted on by ACECORP

1,589

When users create an opportunity record, I need to create a custom folder in Sharepoint, with several subfolders and then create a document location record that points to the root of it so the sub folders appear in the documents area like what is shown below.

Screen-Shot-2021_2D00_04_2D00_25-at-1.03.46-AM.png

However I get an error at the very end when I try to create the document location record.

This is the error I get: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

My flow is shown below.

Screen-Shot-2021_2D00_04_2D00_25-at-12.59.59-AM.png

It creates the SharePoint folders properly.

Screen-Shot-2021_2D00_04_2D00_25-at-1.06.12-AM.png

However, it does not successfully create the document location record to link the folders due to the error Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

The DataVerse/Flow Action Card that is supposed to create the Document location record is shown below.

Screen-Shot-2021_2D00_04_2D00_25-at-1.00.46-AM.png

What could I be missing or overlooking?

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ACECORP 1,589 on at

Like (1)

Report

I fixed my own problem. There appears to be a BUG in DataVerse where it does not properly handle the OData.Id value of the Parent Site or Location (Document Location) and basically ignores it.

I was able to get the flow to complete without error by using the configuration shown below.

However, this results in a Document Location record that has a BLANK Parent Site or Location (Document Location).

The fix is to then create a traditional synchronous workflow in D365 that fires on create of Document Location Record when the value for Parent Site or Location (Document Location) does not contain data as shown below.

This is NOT the way this is supposed to work, so it appears there is some kind of Microsoft BUG with DataVerse Cloud Flows not properly interacting with the Parent Site or Location (Document Location) field.

However, the process detailed above successfully serves as a work-a-round.

Was this reply helpful? Yes No
Nya 29,060 on at

Like (0)

Report

Hi,

Thank you so much for sharing your answers!

Best Regards,

Nya

Was this reply helpful? Yes No
Ran Zhang on at

Like (0)

Report

Thanks Jim for the sharing!

Was this reply helpful? Yes No