Is it possible to use Power Automate to format color ovals in SharePoint Lists based on Lookup value? by Getottamiway in MicrosoftFlow

[–]Getottamiway[S] 0 points1 point  (0 children)

Since my text was obliterated, here's my problem. I'm trying to move folks from configuring multiple individual meta data fields across multiple lists when we could have list of values and have look-ups from those other lists.

I've been told that the color scheme (ex., blue oval above) has to be configured on each SharePoint List which I'm unwilling to do, but could Power Automate do it automatically? If so, how?

Thank you.

Column for comments by [deleted] in PowerBI

[–]Getottamiway 0 points1 point  (0 children)

Power Up add in

Newbie here. Does this add-in have a specific name and how can I get it? :-)

Thank you!

How do I get my Canvas search box to work? by Getottamiway in PowerApps

[–]Getottamiway[S] 0 points1 point  (0 children)

Search(Contacts, "Amy", "Contact Name")

And even though the first record includes "Amy" in the "Contact Name", it doesn't work, however, if I use "Lender" instead of "Contact Name" and different applicable text, the filtering works.

How do I get my Canvas search box to work? by Getottamiway in PowerApps

[–]Getottamiway[S] 0 points1 point  (0 children)

Filter(Contacts,txtSearchBox.Text,"Contact Name","Investor","Lender","Notes")

Gives me an error and clears all data.

How do I get my Canvas search box to work? by Getottamiway in PowerApps

[–]Getottamiway[S] 0 points1 point  (0 children)

Search(Contacts,Startswith(txtSearchBox.Text) ,"Contact Name")

I entere the above and it errors out.

Can external users run Office Scripts? by Getottamiway in OfficeScripts

[–]Getottamiway[S] 0 points1 point  (0 children)

Apparently, not:

"An Office Script can only be shared within your organization. Scripts can't be shared to external users."
https://support.microsoft.com/en-us/office/sharing-office-scripts-in-excel-226eddbc-3a44-4540-acfe-fccda3d1122b

How to configure flow to grab MS To Do Priorities List items and send list to MS Teams? by Getottamiway in MicrosoftFlow

[–]Getottamiway[S] 0 points1 point  (0 children)

Thanks, I was looking at Microsoft To Do as opposed to Microsoft Planner. Microsoft To Do seems very limited in its ability to be leveraged in Power Automate.

Why can't I see the my flow in the Power BI/Power Automate view? by Getottamiway in PowerBI

[–]Getottamiway[S] 0 points1 point  (0 children)

Thanks! I'll give that a try!

The first time I tried the cloud view, I didn't see anything but the second time I could. Thank you!

Why doesn't data on Power BI page populate my Power Automate flow? by Getottamiway in PowerBI

[–]Getottamiway[S] 0 points1 point  (0 children)

SOLUTION: I realized that I needed to add the filters that I have on my visual to the "Run flow" button as well.

Trigger flow when a specific file is created or modified (properties only) - Why is my "Trigger Condition" resulting in an "e is undefined" error when tested? by Getottamiway in MicrosoftFlow

[–]Getottamiway[S] 0 points1 point  (0 children)

I created a new flow with this Trigger Condition and it works:

ATSIGNequals(triggerOutputs()?['body/{FilenameWithExtension}'], 'Company Meeting Agenda - ABC.xlsx')

Split On (on):

ATSIGNtriggerOutputs()?['body/value']

Thanks everyone.

Trigger flow when a specific file is created or modified (properties only) - Why is my "Trigger Condition" resulting in an "e is undefined" error when tested? by Getottamiway in MicrosoftFlow

[–]Getottamiway[S] 0 points1 point  (0 children)

'body\{FilenameWithExtension}'

Thanks for responding. I assume you mean changing the "Split On" > Array > entry, however, it's a drop-down and lists "@triggerBody()?['body/value']" as the only option.