Get Column name if entry has text

(0) Share

Report

Posted on by GOB

Hi folks,

I have a data source connected to a google sheet - unfortunately I cant change the formatting of that google sheet.

The format of that sheet is as follows:

column headers:

TimeStamp | Location1 | Location2 | ...

In the Location column, there is text of a method used, i.e. "A", "B", or "C".

In my powerapp vertical gallery, I want to display the timestamp, and then if there is an entry in any of the Location columns, display that location name.

To demonstrate, here is an example:

on the data source:

Timestamp | Location1 | Location2 | Location3

1/1/2023 | A | B |

1/2/2023 | A,B | | A

So in my gallery I would want to display

1/1/2023 Location1 A

1/1/2023 Location2 B

1/2/2023 Location1 A,B

1/2/2023 Location3 A

I'm having some real trouble figuring out how to do this!

Thanks for all the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report
Hi @GOB ,

Please try hard code.

Filter( ForAll( Ungroup( ForAll(List299,[{Value1:"Location1",Value2:Location1,Value3:Timestamp},{Value1:"Location2",Value2:Location2,Value3:Timestamp},{Value1:"Location3",Value2:Location3,Value3:Timestamp}]),"Value"),Value),!IsBlank(Value2))

Best Regards,

Wearsky

Was this reply helpful? Yes No
GOB 4 on at

Like (0)

Report

I really appreciate the help!

The issue is, the example I gave above was to demonstrate what I need to do, but my actual data has over 700 entries, not just the two lines I gave in the description.

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @GOB ,

Try to modify the threshold of the delegation.

Best Regards,

Wearsky

Was this reply helpful? Yes No
GOB 4 on at

Like (0)

Report

Hi Wearsky,

I guess I may be misunderstanding your recommendation, or I didn't explain my challenge well enough.

It looks to me like you are saying to hard code all the entries in the gallery, with all combinations of locations and methods A,B,C.

My data source (google sheet) looks like;

Timestamp | Location1 | Location2 | Location3 . . . . Location 30
1/1/2023 | A | B |
1/2/2023 | A,B | | A
.
.
.
.
100's of dates (rows)

- so I can't hardcode 700+ entries with multiple methods (A,B,C) in each.

Am I misunderstanding your approach?

Was this reply helpful? Yes No