cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mgwen01
Regular Visitor

Track my expenses in an Excel Online spreadsheet Error

I am having a few problems with this trigger:

 

1.) It will not let me add any more inputs ( I would like to add 2 more)

 

Capture1.JPG

2.) I can't locate the  Amount field to populate the excel report:

 

Capture2.JPG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @mgwen01,

 

Do you mean this field is configured with a hyperlink?

You could use HYPERLINK() function in Excel to implement your needs.

The first parameter uses the generated share link, and the second parameter can use the file name or other content.

Dynamic content needs to add double quotes outside.

Image reference:

23.PNG24.PNG

Please take a try.

 

Best Regards,

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

View solution in original post

3 REPLIES 3
v-bacao-msft
Community Support
Community Support

Hi @mgwen01,

 

I did a test on my side and added up to 20 inputs in Manually trigger.

I am afraid there is no way to achieve this.

If you want to expand the number of inputs you can add, you could post this idea in the Flow Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

For the second question, it seems that because of the type mismatch, the type of input is Number, but the type of the corresponding field in Excel is not this.

You could try to solve it in two ways:

  1. Fill the value of the input output in Compose action first, and then configure Dynamic content of Compose action output in this field.
  2. Change the input type to the type that matches the field.

Please take a try.

 

Best Regards,

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

Thank you @v-bacao-msft . I will post the idea in the Flows Idea Forum.

 

I went back to the excel file and changed the column format to "Number" and then after I searched for the "Amount" in the dynamic content box then clicked  "see more" I was able to find "Amount". So that solved this issue and the Tests worked.

Capture4.JPG

Next, I would like to improve the Excel file to shorten the Image Link to the receipt image label instead of the full web url. Any ideas?

Capture3.JPGCapture5.JPG

 

Hi @mgwen01,

 

Do you mean this field is configured with a hyperlink?

You could use HYPERLINK() function in Excel to implement your needs.

The first parameter uses the generated share link, and the second parameter can use the file name or other content.

Dynamic content needs to add double quotes outside.

Image reference:

23.PNG24.PNG

Please take a try.

 

Best Regards,

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

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (2,862)