cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
addepallimadhu
Frequent Visitor

Unable to pass a custom value for Document library Excel Online (Business) Connector

Flow fails when passing the same value as a custom value. This preventing me from using a variable in place of the drop down.

addepallimadhu_2-1668324292022.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@addepallimadhu  can you please add header Content-type as shown in below screenshot

annajhaveri_0-1668525050361.png

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
annajhaveri
Community Champion
Community Champion

@addepallimadhuwe cant simply provide the library and filename as their actual names, we need to fetch the drive id and file id and use it in the Create Worksheet action, please check this post https://powerusers.microsoft.com/t5/Building-Flows/Get-drive-id-for-Doc-Library-selection/td-p/85653...the steps are mentioned how to get drive id and file id to use in Create Worksheet action.

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Thanks @annajhaveri  . It appears use of _api/v2.0/drives and _api/v2.0/drive is restricted in our environment. Getting an "Unexpected reponse" error. Is there any other way to get drive id? 

@addepallimadhu  can you please add header Content-type as shown in below screenshot

annajhaveri_0-1668525050361.png

 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,410)