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

Text not Showing Up

Hello,

 

I am trying to build a flow that pulls data from a "selected row" in an Excel online spreadsheet and then creates a To-Do in Planner. Most of the data is pulling correctly when I am trying to give the task a name but one part of it is not working. 

 

Below is an example of the spread:

 

OrganizationWeek #Game #DateTimeHomeAway
MLB100011/12/2015:00NYBOS
MLB200021/16/2011:00BOSNY

 

I would like the title for each of the tasks I make to be: MLB - CR - WK 1 - 0001 - NY vs BOS

Unfortunately, the flow is giving me this: MLB - CR - WK  - 0001 - NY vs BOS

 

It is missing the Week # in the text string. I have tried changing the cell's formating to Text and to Number but it still comes back with the same issue.

 

Any help?

Thanks,

Alex

 

1 ACCEPTED SOLUTION

Accepted Solutions

@agoldstein 

It can sound weird, but... would you mind to create another Table in your Excel file, just for testing purposes? Add the same column names than in the current table, with the exception of 'Week #'. Please call it 'WeekNr'.

Fill one row on the new table.

Next, select 'Save as' in your current flow, so you will have a backup.

Now switch to the new flow, edit it, change table in your trigger. Save it, and remember to Turn it on (when saving as... the copy is by default turn off).

Finally, execute the flow from your new table

 

There must be something really simple we are missing...

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

11 REPLIES 11
Dual Super User III
Dual Super User III

Hi!

Can you share a screenshot from your current flow design? Also whatever expression you are currently using

Please also a share the trigger selected row output JSON ( you need to inspect on any of your flow executions from Run history), so we can doublecheck Excel internal column names, datatypes and values

Thanx!

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Attached is the screenshot of the flow. 

 

How do I get the JSON of the selected row output?Flow Screenshot.PNG

Hi!

You can inspect JSON trigger output by accesing Flow run history from your Flow main page.

Flow_Run_history.png

Once you access your last flow execution, doubleck on the trigger to expand it. You will see a section called 'Outputs' will all related info, also JSON output

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Wait, wait, wait... there is probably a faster approach.

JUst after your trigger, add a Compose action block, assign as its input 'Week #' column value from dynamic content menu.

 

THen reexecute your flow, go to 'Flow Run History', open last execution, doubleclick on 'Compose' action block share its content in this thread please.

 

So if its content is what you expect, probably need to replace 'Week #' dynamic content from your 'Create planner' Title and add 'Compose' outputs instead, you can select it from the dynamic content menu also

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Below is the new flow. 

Flow Screenshot_2.PNGIt looks like once the "For a Selected Row" option is started the outputs don't pull the Week # at all.

 

I can't seem to download the 

Input data: 

{
  "type""object",
  "properties": {
    "rows": {
      "type""array",
      "items": {
        "type""object",
        "properties": {
          "entity": {
            "type""object",
            "properties": {
              "League": {
                "title""League",
                "type""any"
              },
              "League_Formatted": {
                "title""League (Formatted)",
                "type""string"
              },
              "Game": {
                "title""Game",
                "type""any"
              },
              "Home Team": {
                "title""Home Team",
                "type""any"
              },
              "Visiting Team": {
                "title""Visiting Team",
                "type""any"
              },
              "Home \nTeam": {
                "title""Home \nTeam",
                "type""any"
              },
              "Visiting \nTeam": {
                "title""Visiting \nTeam",
                "type""any"
              },
              "WK _x0023_": {
                "title""WK #",
                "type""any"
              }
            },
            "required": [
              "League",
              "League_Formatted",
              "Game",
              "Home Team",
              "Visiting Team",
              "Home \nTeam",
              "Visiting \nTeam",
              "WK _x0023_"
            ]
          }
        },
        "required": [
          "entity"
        ]
      }
    }
  },
  "required": [
    "rows"
  ]
}
 
Output Data:
{
  "entity": {
    "League""MLS",
    "Game"7002,
    "Home \nTeam""LEO",
    "Visiting \nTeam""ATL",
    "League_Formatted""MLS"
  }
}
 
Here is the Compose function: 
Compose.PNGNothing happens when I choose "Click to Download"

@agoldstein 

AS you said, trigger does not deliver Week # content, even though the JSON schema hasthis column declared as mandatory...

 

              "WK _x0023_": {
                "title": "WK #",
                "type": "any"
              }

 

And, you are sure the item you selected (Game 7002) has value assigned to this Week # column, right?

 

Output Data:
{
"entity": {
"League": "MLS",
"Game": 7002,
"Home \nTeam": "LEO",
"Visiting \nTeam": "ATL",
"League_Formatted": "MLS"
}
}

 

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Yes. Right now the cell is filled in with the number 0 but others are filled with 1-34 and they aren't getting pulled.

 

I tried copying the cell formats from Game number into Week # and that didn't fix it. Also tried changing its format from number to text and custom.

@agoldstein 

It can sound weird, but... would you mind to create another Table in your Excel file, just for testing purposes? Add the same column names than in the current table, with the exception of 'Week #'. Please call it 'WeekNr'.

Fill one row on the new table.

Next, select 'Save as' in your current flow, so you will have a backup.

Now switch to the new flow, edit it, change table in your trigger. Save it, and remember to Turn it on (when saving as... the copy is by default turn off).

Finally, execute the flow from your new table

 

There must be something really simple we are missing...

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

It looks like that fixed this issue. Was it as simple as a # in the column name?

OMG!
HURRAY!
IT WORKS!
Sharepoint Column Names with special characters like spaces, #, etc are a nightmare in terms of Power Automate integration. What I didn't expect is that they would be also a nightmare also when interacting with Excel... Microsoft should improve it.
In the meantime, please avoid them if possible.

Hooe this helps


Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Thanks for the help and guidance!! 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Top Kudoed Authors
Users online (7,186)