cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Add Excel rows to create item on SharePoint

Hello,

 

I am trying to create what seems like a simple flow, but am running into some trouble. I want the scheduled flow to create and SP Item when someone adds a row to an Excel Business document. 

 

Now what I believe might be the problem is my format and set up with the excel file. The SP page has attributes that have multi-select options so I need the excel file to allow for multiple items to be in one cell. With that, I created a data validation with a VBA allowing for the drop down data validation list to select multiple items and put them all into that one cell. 

 

To give my scenario with an example: Managing applications and where they are housed. The table will hold information like what the application is, the manufacturer, the type of software, and the departments and roles that are approved for use. The roles and departments are the columns that can have multi-select options since multiple roles and departments may be approved for that application.

 

The error code is: 400 - The data returned from the tagging UI was not formatted correctly clientRequestId: 805aee2f-4c5f-4726-b7d8-348097282ff1 serviceRequestId: 805aee2f-4c5f-4726-b7d8-348097282ff1

 

I don't know if it is because of the format and data validation with my VBA, but if not what else could be the problem with this flow?

 

Thanks,

Blake

6 REPLIES 6
v-lin-msft
Post Prodigy
Post Prodigy

Hi @Anonymous,

 

Could you share the screenshots of flow configuration, column type of SP item and Excel Document instance?

You said you need an excel file to allow for multiple items to be in one cell, are you put multiple records into one cell for the creation of SP item's multi-select options? Just like this?Annotation 2019-06-26 144902.png

 

Since the error information is format incorrectly, confirming the data format and your flow processes are necessary.

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hello @v-lin-msft,

 

Thank you for your reply. I have mapped the SP item's columns to the columns in the excel file and selected the respective attribute on the flow map, but that is when I am not using the VB Project (See Yellow Note on Excel Picture).Excel_Example.PNG

Rows_Present.PNG

Flow_Mapping.PNG

For me to have a drop-down list that allows a user to select multiple items in a cell, I have to have this VBA code which forces me to save it as a .xls or .xlsm. I do want the cell to do that if capable in a data validated list and then publish those attributes to the multi-select column in the SP site. I have tried it without a data validated list and just manually type the options out, but even then, the flow doesn't seem to work. I tried typing out the options instead of using the drop-down and believe everything is mapped correctly, even on the .xlsx file, but it still won't work. 

Anonymous
Not applicable

Hi @v-lin-msft again,

 

I attempted something else based on a forum I saw on this issue, but it is now not even letting me save it and is giving me the Red Error line in the images. Thoughts on both methods? Parallel_Test.PNGMapping.PNG

Hi @Anonymous,

 

There is a blog about how to enable macros in Office files, you can refer to it:

https://support.office.com/en-us/article/enable-or-disable-macros-in-office-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6

 

Best Regards,

Community Support Team _ Lin Tu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

@v-lin-msft That doesn't really fix the fact that the flow doesn't work in either format or the fact that you cannot use Macro-enabled workbooks in Flow. Flow only supports .xlsx excel files. 

 

Please refer to the incorrect Flow and help troubleshoot that, not anything with the background data of the workbook because I understand that it won't allow me to utilize a VBA data validated list.

 

Best,

Blake

Anonymous
Not applicable

@efialttes  This is the flow I was referring to I could use further assistance on! 

 

Thanks.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,023)