cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mgwen01
Level: Powered On

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
Community Support Team
Community Support Team

Re: Track my expenses in an Excel Online spreadsheet Error

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
Community Support Team
Community Support Team

Re: Track my expenses in an Excel Online spreadsheet Error

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.
mgwen01
Level: Powered On

Re: Track my expenses in an Excel Online spreadsheet Error

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

 

Community Support Team
Community Support Team

Re: Track my expenses in an Excel Online spreadsheet Error

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
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,243)